tbl_lithic_audit

166122 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uid serial 10 √ nextval('tbl_lithic_audit_uid_seq'::regclass)
refid int4 10 null
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 Implied ConstraintR
burnt bool 1 √ null
survival varchar 20 √ null
lkp_lithic_survival.survival Implied ConstraintR
type varchar 20 √ null
sub_type varchar 20 √ null
classification varchar 30 √ null
lkp_lithic_classification.classification Implied ConstraintR
comments text 2147483647 √ null
ml numeric 5,2 √ null
mw numeric 5,2 √ null
mth numeric 5,2 √ null
audit_timestamp timestamp 29,6 √ now()
audit_author int4 10 √ '-1'::integer
tbl_users.refid tbl_evidence_log_audit_audit_author_fkeyR
audit_action varchar 10 √ 'unknown'::character varying
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
analysis_table varchar 20 √ null
material_removed_from_archive bool 1 √ false
weight numeric 5,2 √ null
category varchar 50 √ null
lkp_lithic_category.category Implied ConstraintR

Indexes

Constraint Name Type Sort Column(s)
tbl_lithic_audit_pkey Primary key Asc uid
idx_lithic_audit Performance Asc refid
idx_lithic_audit_insert Performance Asc refid
idx_lithic_audit_uid Must be unique Asc uid

Relationships

Close relationships within degrees of separation