data_source

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
data_source_id serial 10 √ nextval('examples.data_source_data_source_id_seq'::regclass)
predator.data_source_id predator_data_source_id_fkeyR
sample.data_source_id sample_data_source_id_fkeyR
survey_index.data_source_id survey_index_data_source_id_fkeyR

Numeric ID for this entry
name varchar 1024 null
data_source.t_group data_source_t_group_fkeyR

Short name used in data files / output data (in ltree notation)
t_group varchar 1024 √ null
data_source.name data_source_t_group_fkeyR

Value grouping (short name)
description varchar 1024 √ null

Long description

Indexes

Constraint Name Type Sort Column(s)
data_source_pkey Primary key Asc data_source_id
data_source_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation