Yes

facility_investigators

facility_id

integer

-

-

Yes

facility_investigators

role

character varying

-

Location Contact Role

Yes

facility_investigators

name

character varying

-

Location Contact Name

Yes

id_information

id

integer

primary key

-

Yes

id_information

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

id_information

id_source

character varying

-

-

Yes

id_information

id_value

character varying

-

Secondary Id

Yes

id_information

id_type

character varying

Type of organization's unique protocol ID

Secondary Id Type

Yes

id_information

id_type_description

character varying

-

Secondary Id Domain

Yes

id_information

id_link

character varying

URL link based on OrgStudyId and OrgStudyIdType input in PRS, include system-generated links to NIH RePORTER, specifically (associated with the types of federal funding identified as OrgStudyIdType)

Secondary Id Link

Yes

intervention_other_names

id

integer

primary key

-

Yes

intervention_other_names

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

intervention_other_names

intervention_id

integer

-

-

Yes

intervention_other_names

name

character varying

-

-

Yes

interventions

id

integer

primary key

-

Yes

interventions

nct_id

character varying

foreign key referencing studies.nct_id

-

Yes

interventions

intervention_type

character varying

-

Intervention Type

Yes

interventions

name

character varying

-

Intervention Name

Yes

interventions

description

text

-

Intervention Description

Yes

ipd_information_types

id

integer

primary key

-