tbl_ceramics_lookup

28 rows


Description

This table serves as a reference for ceramic types and their associated details.

Columns

Column Type Size Nulls Auto Children Parents Comments
ceramics_lookup_id int4 10 √
tbl_ceramics.ceramics_lookup_id fk_ceramics_ceramics_lookup_id R

Primary key (automatically incremented).
method_id int4 10
tbl_methods.method_id fk_ceramics_lookup_method_id R

Specifies the method used to classify the ceramic type.
description text 2147483647 √

Detailed description of the ceramic type.
name varchar 2147483647

Name of the ceramic type.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_ceramics_lookup_pkey Primary key Asc ceramics_lookup_id

Relationships

Close relationships within degrees of separation