Table: study

Comment: One row per study. The study within which the individuals have been observed. At present, the same taxon and the same site applies to all individuals within the study.

ColumnTypeComment
sidcharacter varying(12)Unique row identifier. May not be 'all' or NULL.
namecharacter varying(32) NULLThe name of the study. This may be a descriptive or encoded, must be unique if not NULL.
ownerscharacter varying(128) NULLThe owners of the observational data that this study gave rise to. This may be a single person, an organization, or a (comma-delimited) list of such.
taxonidintegerThe row identifier of the taxon for the individuals that were or are being observed in this study.
siteidintegerThe row identifer of the site where this study was or is being conducted, and hence where the individuals have been observed.

Indexes

PRIMARYsid
UNIQUEname

Foreign keys

SourceTargetON DELETEON UPDATE
taxonidtaxon(taxonid)NO ACTION NO ACTION Alter
siteidsite(siteid)NO ACTION NO ACTION Alter

Triggers

Language: