lbr_legalmessage

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lbr_legalmessage_id numeric 10 null
c_invoiceline.lbr_legalmessage_id lbrlegalmessage_cinvoiceline R
c_orderline.cof_legalmessagedelivery_id coflegalmessagedelivery_corder R
c_orderline.lbr_legalmessage_id lbrlegalmessage_corderline R
lbr_cfopline.cof_legalmessagedelivery_id coflegalmessagedelivery_lbrcfo R
lbr_cfopline.lbr_legalmessage_id lbrlegalmessage_lbrcfopline R
lbr_taxdefinition.lbr_legalmessage_id lbrlegalmessage_lbrtaxdefiniti R
lbr_taxline.lbr_legalmessage_id lbrlegalmessage_lbrtaxline R
m_movementline.lbr_legalmessage_id lbrlegalmessage_mmovementline R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 null
createdby numeric 10 null
updated timestamp 29,6 null
updatedby numeric 10 null
textmsg varchar 500 null
lbr_legalmessage_uu varchar 36 √ NULL::character varying
name varchar 60 √ NULL::character varying
comments varchar 255 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
lbr_legalmessage_key Primary key Asc lbr_legalmessage_id
lbr_legalmessage_uu_idx Must be unique Asc lbr_legalmessage_uu

Check Constraints

Constraint Name Constraint
lbr_legalmessage_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation