CREATE TABLE Investigator_Patient_PPLTN ( INVSTGTR_PATNT_POPLTN_ETHCY_ID OID_DM NOT NULL, Ethnic_Group_PC Percentage_4_2_DM, Survey_DT Date_DM NOT NULL, Investigator_Party_ID OID_DM NOT NULL, Ethnicity_ID OID_DM NOT NULL, Creation_DT datetime NOT NULL, Last_Update_DT datetime NOT NULL, Deletion_DT datetime NULL, Logically_Deleted_YN varchar(1) NOT NULL CHECK (Logically_Deleted_YN IN ('Y', 'N')), Created_By_User_ID OID_DM NOT NULL, Last_Updated_By_User_ID OID_DM NOT NULL, Deleted_By_User_ID OID_DM ) go CREATE UNIQUE INDEX XAK1Investigator_Patient_PPLTN ON Investigator_Patient_PPLTN ( Survey_DT, Investigator_Party_ID, Ethnicity_ID ) go ALTER TABLE Investigator_Patient_PPLTN ADD PRIMARY KEY (INVSTGTR_PATNT_POPLTN_ETHCY_ID) go