c_addresstransaction

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_caddresstransaction R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_caddresstransaction R
address1 varchar 60 √ NULL::character varying
address2 varchar 60 √ NULL::character varying
address3 varchar 60 √ NULL::character varying
address4 varchar 60 √ NULL::character varying
c_addresstransaction_id numeric 10 null
c_addresstransaction_uu varchar 36 √ NULL::character varying
c_addressvalidation_id numeric 10 null
c_addressvalidation.c_addressvalidation_id caddressvalidation_caddresstra R
c_location_id numeric 10 √ NULL::numeric
c_location.c_location_id clocation_caddresstransaction R
city varchar 60 √ NULL::character varying
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
ad_user.ad_user_id createdby_caddresstransaction R
isactive bpchar 1 'Y'::bpchar
isvalid bpchar 1 'N'::bpchar
postal varchar 10 √ NULL::character varying
processed bpchar 1 'N'::bpchar
region varchar 60 √ NULL::character varying
result varchar 2000 √ NULL::character varying
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
ad_user.ad_user_id updatedby_caddresstransaction R
country varchar 60 √ NULL::character varying
comments varchar 2000 √ NULL::character varying
address5 varchar 60 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
c_addresstransaction_key Primary key Asc c_addresstransaction_id
c_addresstransaction_uu_idx Must be unique Asc c_addresstransaction_uu

Check Constraints

Constraint Name Constraint
c_addresstransaction_isvalid_check ((isvalid = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_addresstransaction_processed_check ((processed = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
c_addresstransaction_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation