test

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
test_id numeric 10 null
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
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
t_integer numeric 10 √ null
t_number numeric 0 √ 0
t_date timestamp 29,6 √ null
t_datetime timestamp 29,6 √ null
c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
t_qty numeric 0 √ 0
c_currency_id numeric 10 √ null
c_currency.c_currency_id Implied Constraint R
t_amount numeric 0 √ 0
c_location_id numeric 10 √ null
c_location.c_location_id Implied Constraint R
account_acct numeric 10 √ null
c_validcombination.c_validcombination_id vc_account_test R
c_payment_id numeric 10 √ null
c_payment.c_payment_id Implied Constraint R
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
m_locator_id numeric 10 √ null
m_locator.m_locator_id Implied Constraint R
processing bpchar 1 √ null
binarydata bytea 2147483647 √ null
processed bpchar 1 √ 'N'::bpchar
characterdata text 2147483647 √ null
test_uu varchar 36 √ NULL::character varying
lbr_tax_id numeric 10 √ NULL::numeric
lbr_tax.lbr_tax_id Implied Constraint R
cof_r_survey_id numeric 10 √ NULL::numeric
cof_r_survey.cof_r_survey_id Implied Constraint R
html varchar 2000 √ NULL::character varying
color varchar 7 √ NULL::character varying
t_timestamp timestamptz 35,6 √ null
ad_table_id numeric 10 √ NULL::numeric
ad_table.ad_table_id adtable_test R
record_id numeric 10 √ NULL::numeric

Indexes

Constraint Name Type Sort Column(s)
test_pkey Primary key Asc test_id
test_uu_idx Must be unique Asc test_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation