Active
Table
Column
Type
Description
CTGov Data Point
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
-
Secondary Id Type
Yes
id_information
id_type_description
character varying
-
Secondary Id Domain
Yes
id_information
id_link
character varying
-
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
-