dataset

10361 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dataset_num serial 10 √ nextval('dataset_dataset_num_seq'::regclass)
action.dataset_num fk_action_datasetR
citation_dataset.dataset_num fk_citation_dataset_datasetR
dataset_external_identifier.dataset_num fk_dataset_external_identifier_datasetR
mv_dataset_result_summary.dataset_num Implied ConstraintR
mv_dataset_summary.dataset_num Implied ConstraintR
v_dataset_result.dataset_num Implied ConstraintR
v_dataset_result_summary.dataset_num Implied ConstraintR
v_dataset_summary.dataset_num Implied ConstraintR
dataset_uuid uuid 2147483647 uuid_generate_v4()

table_in_ref_num
dataset_type varchar 128 'Reference Table'::character varying
dataset_code varchar 64 null
dataset_title varchar 512 'N/A'::character varying
dataset_abstract varchar 2000 'N/A'::character varying
dataset_type_num int4 10 1
dataset_type.dataset_type_num dataset_dataset_type_num_fkeyR

Indexes

Constraint Name Type Sort Column(s)
dataset_pkey Primary key Asc dataset_num
uc_dataset_type_dataset_code_dataset_title Must be unique Asc/Asc/Asc dataset_type + dataset_code + dataset_title
uc_dataset_uuid Must be unique Asc dataset_uuid

Relationships

Close relationships within degrees of separation