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