tds_declarationtitlemaster

114 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tdsdectitleid serial 10 √ nextval('tds_declarationtitlemaster_tdsdectitleid_seq'::regclass)
tbl_tds_detail.tdsdectitleid fk__tbl_tds_d__tdsde__1d99f6d2 R
tdsdeccatid int4 10 √ null
title varchar 2147483647 √ null
type varchar 50 √ null
status bool 1 √ null
com1 varchar 2147483647 √ null
com2 varchar 2147483647 √ null
com3 varchar 2147483647 √ null
com4 varchar 2147483647 √ null
com5 varchar 2147483647 √ null
com6 varchar 2147483647 √ null
com7 varchar 2147483647 √ null
createdby varchar 50 √ null
createdon timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifiedon timestamp 29,6 √ null
producedamountrownumber varchar 5 √ null
limitedamountcolumnnumber varchar 5 √ null
limitedamountrownumber varchar 5 √ null
isattachmentrequired bool 1 √ true
flag bool 1 √ false
producedamountcolumnnumber varchar 5 √ null

Indexes

Constraint Name Type Sort Column(s)
tds_declarationtitlemaster_pk_tds_declarationtitlemaster Primary key Asc tdsdectitleid

Relationships

Close relationships within degrees of separation