c_rfqline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
c_rfqline_id numeric 10 null
c_rfqlineqty.c_rfqline_id crfqline_crfqlineqty C
c_rfqresponseline.c_rfqline_id crfqline_crfqresponseline C
c_rfqresponseline_v.c_rfqline_id Implied Constraint R
c_rfqresponseline_vt.c_rfqline_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
c_rfq_id numeric 10 null
c_rfq.c_rfq_id crfq_crfqline C
line numeric 10 0
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_crfqline R
m_attributesetinstance_id numeric 10 √ 0
m_attributesetinstance.m_attributesetinstance_id masetinstance_crfqline R
description varchar 255 √ null
help varchar 2000 √ null
deliverydays numeric 10 √ 0
dateworkcomplete timestamp 29,6 √ null
dateworkstart timestamp 29,6 √ null
c_rfqline_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_rfqline_pkey Primary key Asc c_rfqline_id
c_rfqline_uu_idx Must be unique Asc c_rfqline_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation