sampling_feature_external_identifier

4035 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
bridge_num serial 10 √ nextval('sampling_feature_external_identifier_bridge_num_seq'::regclass)
sample_feature_num int4 10 null
sampling_feature.sampling_feature_num sampling_feature_external_identifier_sample_feature_num_fkeyR
sampling_feature_external_id varchar 256 null

LLS000001
sampling_feature_external_identifier_uri varchar 2000 √ null

http://app.geosamples.org/igsn/
external_identifier_system_num int4 10 null
external_identifier_system.external_identifier_system_num sampling_feature_external_ide_external_identifier_system_n_fkeyR

Indexes

Constraint Name Type Sort Column(s)
sampling_feature_external_identifier_pkey Primary key Asc bridge_num
uc_sampling_feature_external_identifier Must be unique Asc/Asc/Asc sample_feature_num + sampling_feature_external_id + external_identifier_system_num

Relationships

Close relationships within degrees of separation