sunnycoder
asked on
Generating ID and GUID
I have defined a PatientInfo table with following fields
PatientGUID uniqueidentifier not NULL
PatientID bigint not NULL
LastName Varchar(50) not NULL
FirstName Varchar(50) not NULL
MiddleName Varchar(50)
Gender SmallInt not NULL
VoterID Varchar(50)
PAN Varchar(50)
DLNo Varchar(50)
PatientID can be a incrementing number starting from 1 while PatientGUID has to be generated in such a way that no two patient records have same GUID even on different installations - may be adding NIC MAC address or something.
What is the best way to generate these IDs?
PatientGUID uniqueidentifier not NULL
PatientID bigint not NULL
LastName Varchar(50) not NULL
FirstName Varchar(50) not NULL
MiddleName Varchar(50)
Gender SmallInt not NULL
VoterID Varchar(50)
PAN Varchar(50)
DLNo Varchar(50)
PatientID can be a incrementing number starting from 1 while PatientGUID has to be generated in such a way that no two patient records have same GUID even on different installations - may be adding NIC MAC address or something.
What is the best way to generate these IDs?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
VoterID is not a mandatory field - that increases the chance of a clash. Wondering if same patient registered at two different installation should have the same patientGUID. If yes then system specific GUID might be a bad ... hmm I need to give this a second thought.
Hello
>>VoterID is not a mandatory field.
Well don't include the Voters ID in our GUID system.
>>Wondering if same patient registered at two different installation should have the same patientGUID.
It's not bad at all, our guid system has a date and time value, so it will never have an identical id.
Great is our GOD.
:)
>>VoterID is not a mandatory field.
Well don't include the Voters ID in our GUID system.
>>Wondering if same patient registered at two different installation should have the same patientGUID.
It's not bad at all, our guid system has a date and time value, so it will never have an identical id.
Great is our GOD.
:)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hello TechTiger007
Thanks for that answer, it gives direction to my comments for sunnycoder.
Great is our GOD.
:)
Thanks for that answer, it gives direction to my comments for sunnycoder.
Great is our GOD.
:)
ASKER
Thank you
You can add also the date like:
Patient GUID: 2RRTM1-OC0812
OC is for month october
08 is for year 2008
12 is for day 12
You can also add the time.
Patient GUID: 2RRTM1-OC0812-141505
14 is for the hours
15 is for the minutes
05 is for the seconds
I don't think there will be an identical GUID for that system.
And also it is an autogerated GUID if you apply that.
Great is our GOD.
:)