cof_labelconfig

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_labelconfig_id numeric 10 null
cof_labelentry.cof_labelconfig_id coflabelconfig_coflabelentry R
cof_labelfield.cof_labelconfig_id coflabelconfig_coflabelfield C
cof_labelwindow.cof_labelconfig_id coflabelconfig_coflabelwindow C
cof_labelconfig_uu varchar 36 √ NULL::character varying
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
cof_labeltype varchar 2 null
cof_verifyingdigit numeric 10 √ NULL::numeric
name varchar 60 null
value varchar 40 null
description varchar 255 √ NULL::character varying
cof_verifyiflabelexists bpchar 1 √ 'Y'::bpchar
cof_labelconfigtype varchar 2 'BO'::character varying
cof_allowrepeteadlabel bpchar 1 √ 'N'::bpchar
cof_ischecksize bpchar 1 √ 'N'::bpchar
cof_labelsize numeric 10 √ '1'::numeric

Indexes

Constraint Name Type Sort Column(s)
cof_labelconfig_key Primary key Asc cof_labelconfig_id
cof_labelconfig_uu_idx Must be unique Asc cof_labelconfig_uu

Check Constraints

Constraint Name Constraint
cof_labelconfig_cof_verifyiflabelexists_check ((cof_verifyiflabelexists = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_labelconfig_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_labelconfig_cof_allowrepeteadlabel_check ((cof_allowrepeteadlabel = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_labelconfig_cof_ischecksize_check ((cof_ischecksize = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation