tbl_document_type

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_document_type_id_seq'::regclass)
type_name varchar 100 null
type_label varchar 100 null
type_mapping varchar 100 √ null
type_index int8 19 null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Timestamp of the last modification.
Stored as: UTC
Usage: Audit trail.

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_document_type Primary key Asc id

Relationships

Close relationships within degrees of separation