repositoryinstitutions

372 rows


Description

A lookup table of institutions that are repositories for fossil specimens. Table is referenced by the RepositorySpecimens table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
repositoryid serial 10 nextval('ndb.seq_repositoryinstitutions_repositoryid'::regclass)
repositoryspecimens.repositoryid fk_repositoryspecimens_repositoryinstitutionsR
specimens.repositoryid fk_specimens_repositoryinstitutionsC
acronym varchar 64 null
repository varchar 128 null
notes text 2147483647 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
repositoryinstitutions_pkey Primary key Asc repositoryid

Relationships