constituentdatabases

41 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
databaseid serial 10 √ nextval('ndb.seq_constituentdatabases_databaseid'::regclass)
datasetdatabases.databaseid fk_datasetdatabases_constituentdatabases C
datasetsubmissions.databaseid fk_datasetsubmissions_constituentdatabases C
stewarddatabases.databaseid fk_stewarddatabases_constituentdatabases C
databasename varchar 80 null
contactid int4 10 √ null
contacts.contactid fk_constituentdatabases_contacts R
url varchar 128 √ null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null
description text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
constituentdatabases_pkey Primary key Asc databaseid

Relationships

Close relationships within degrees of separation