Tables [dbo].[Person_Race]
Races for a person (implemented for patients).
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Person_Race_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Person_Race table.
Indexes NIX_Person_Race_PersonID_RaceDEForeign Keys FK_Person_Race_Person_ID: [dbo].[Person_Other].PersonIDPersonID[dbo].[uniqueid]9NOT NULLPerson. Key to the Person Table
Indexes NIX_Person_Race_PersonID_RaceDEForeign Keys FK_Person_Race_Race_DE_ID: [dbo].[Race_DE].RaceDERaceDE[dbo].[dict_id]5NOT NULLRace. Link to Race_DE.
IsDeletedbit1NOT NULL((0))Deleted Race entry?
LastUpdatedDTTMdatetime8NULL allowedModified date/time of Race Entry.