tbl_contexts

6779 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ctx_id serial 10 √ nextval('tbl_contexts_ctx_id_seq'::regclass)
site_code varchar 50 √ null
context int4 10 null
tbl_context_entity.context tbl_context_entity_context_fkeyC
tbl_finds.context finds_fkeyR
tbl_monolith.context tbl_monolith_context_fkeyR
tbl_relationships.context tbl_relationships_context_fkeyC
tbl_relationships.related_context tbl_relationships_related_context_fkeyC
tbl_strat_relationship.context tbl_strat_relationship_context_fkeyC
tbl_strat_relationship.related_context tbl_strat_relationship_related_context_fkeyC
unique_id varchar 255 √ null
trench varchar 50 √ null
site_sub_div varchar 50 √ null
lkp_sitesubdiv.site_sub_div tbl_contexts_site_sub_div_fkeyR
phase varchar 50 √ null
lkp_context_phase.phase tbl_contexts_phase_fkeyR
period varchar 50 √ null
lkp_context_period.period tbl_contexts_period_fkeyR
part_of_group int4 10 √ null
part_of_subgroup int4 10 √ null
context_type varchar 50 √ null
lkp_contexttype.context_type tbl_contexts_context_type_fkeyR
description text 2147483647 √ null
interpretation text 2147483647 √ null
category varchar 50 √ null
lkp_categorytype.category_type tbl_contexts_category_fkeyR
rank int4 10 √ null
comments text 2147483647 √ null
spot_date varchar 255 √ null
site_sub_div_sm varchar 50 √ null
entity varchar 50 √ null
the_geom geometry 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
contexts_pkey Primary key Asc ctx_id
contexts_idx Must be unique Asc context

Relationships

Close relationships within degrees of separation