tbl_lithic

69975 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid serial 10 √ nextval('tbl_lithic_refid_seq'::regclass)
tbl_lithic_analysis.lithic_record tbl_lithic_analysis_lithic_record_fkeyC
tbl_lithic_lithic_entity.lithic_refid tbl_lithic_lithic_refid_fkeyC
tbl_photos.lithic_record tbl_photos_lithic_record_fkeyC
tbl_photos_audit.lithic_record tbl_photos_audit_lithic_record_fkeyC
context_no numeric 6 null
find_no numeric 5 null
pieces_no int4 10 √ null
raw_material varchar 20 √ null
lkp_lithic_raw_material.raw_material tbl_lithic_rawMaterial_fkeyR
burnt bool 1 √ null
survival varchar 20 √ null
lkp_lithic_survival.survival tbl_lithic_survival_fkeyR
type varchar 20 √ null
lkp_lithic_type.type tbl_lithic_type_fkeyR
sub_type varchar 20 √ null
lkp_lithic_sub_type.sub_type tbl_lithic_subType_fkeyR
classification varchar 30 √ null
lkp_lithic_classification.classification tbl_lithic_classification_fkeyR
comments text 2147483647 √ null
ml numeric 5,2 √ null
mw numeric 5,2 √ null
mth numeric 5,2 √ null
box_no numeric 4 √ null
gridsquare_no numeric 131089 √ null
group_no_old numeric 6 √ null
analysis bool 1 √ null
knapping_group int4 10 √ null
tbl_knapping_groups.knapping_group tbl_lithic_knapping_group_fkeyN
analysis_table varchar 20 √ null
lkp_lithic_analysis_tables.analysis_tables tbl_lithic_analysis_table_fkeyN
material_removed_from_archive bool 1 √ false
weight numeric 5,2 √ null
the_geom geometry 2147483647 √ null
category varchar 50 √ null
lkp_lithic_category.category tbl_lithic_category_fkeyR

Indexes

Constraint Name Type Sort Column(s)
tbl_lithic_pkey Primary key Asc refid
idx_lithic_log Performance
idx_tbl_lithic Must be unique Asc refid

Relationships

Close relationships within degrees of separation