lbr_productcategory

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lbr_productcategory_id numeric 10 null
c_charge.lbr_productcategory_id Implied Constraint R
cof_fciline.lbr_productcategory_id lbrproductcategory_coffciline R
cof_rv_confimpostos.lbr_productcategory_id Implied Constraint R
cof_rv_productsmanufacturedandsold.lbr_productcategory_id Implied Constraint R
i_product.lbr_productcategory_id lbrproductcategory_iproduct R
lbr_cfopline.lbr_productcategory_id Implied Constraint R
lbr_taxdefinition.lbr_productcategory_id Implied Constraint R
m_product.lbr_productcategory_id Implied Constraint R
rv_storage.lbr_productcategory_id Implied Constraint R
rv_storage_per_product.lbr_productcategory_id Implied Constraint R
ad_org_id numeric 10 null
ad_client_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
name varchar 60 null
description varchar 255 √ null
lbr_productcategory_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
lbr_productcategory_key Primary key Asc lbr_productcategory_id
lbr_productcategory_uu_idx Must be unique Asc lbr_productcategory_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation