PID Data type clarification

OpenEMR Development
1

ranjithavi wrote on Thursday, November 01, 2012:

Hello All,

I need a clarification on the data type of PID.
In patient_data PID data type is bigint(20) NOT NULL DEFAULT ‘0’.
But in the openemr_postcalendar_events table," pc_pid "  data type is varchar(11) DEFAULT NULL.

Is there any specific reason for this data type change ?

Thanks,

2

tmccormi wrote on Friday, November 02, 2012:

I doubt anyone here knows.  Probably just sloppiness from way, way, way back in time.
-Tony

3

ranjithavi wrote on Friday, November 02, 2012:

So I  guess, there is no problem to change that data type as bigint. This change  will be used  for some performance metrics.

-Ranjith

4

tmccormi wrote on Friday, November 02, 2012:

Do a backup and try it.   I suspect you’ll be OK.