tbl_projectdata

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
projectid serial 10 √ nextval('"tbl_ProjectData_projectID_seq"'::regclass)
jtbl_project_citations.projectid jtbl_project_citations_projectid_fkey C
tbl_megastructuredata.projectid fk_megastructure_projectID N
v_export_master.mega_projectid Implied Constraint R
v_export_master.project_projectid Implied Constraint R
v_export_mega.mega_projectid Implied Constraint R
v_export_project.project_projectid Implied Constraint R
projectname varchar 255 √ null
principalinvestigator varchar 255 √ null
siteorlocationname varchar 255 √ null
startdate date 13 √ null
enddate date 13 √ null
instrumentsused varchar 255 √ null
orcid varchar 255 √ null
otherteammembers varchar 255 √ null
areaofinterest varchar 255 √ null
purposeofstudy varchar 255 √ null
fundingsource varchar 255 √ null
grantid varchar 255 √ null
projecttectonicsettingid int4 10 √ null
tlkpprojecttectonicsetting.valueid fk_Tectsetting_Lookup R

Indexes

Constraint Name Type Sort Column(s)
tbl_ProjectData_pkey Primary key Asc projectid

Relationships

Close relationships within degrees of separation