cof_configexportcontab

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_configexportcontab_id numeric 10 null
cof_configexportcontabcontas.cof_configexportcontab_id cofconfigexportcontab_cofconfigexportcontabcontas R
cof_configexportcontabcustos.cof_configexportcontab_id cofconfigexportcontab_cofconfigexportcontabcustos R
cof_configexportcontabexcecoes.cof_configexportcontab_id cofconfigexportcontab_cofconfigexportcontabexcecoes R
cof_configexportcontabformato.cof_configexportcontab_id cofconfigexportcontab_cofconfigexportcontabformato R
cof_configexportcontab_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
value varchar 40 null
description varchar 255 √ NULL::character varying
c_element_id numeric 10 √ null
c_element.c_element_id celement_cofconfigexportcontab N
cof_elementref_id numeric 10 √ NULL::numeric
c_element.c_element_id cofelementref_cofconfigexportc N
cof_processing bpchar 1 √ NULL::bpchar
cof_c_fileformat varchar 10 'UTF-8'::character varying
cof_tipoarquivo varchar 2 'PF'::character varying
separatorchar varchar 1 √ NULL::character varying
cof_datafiltrolancamento varchar 22 √ NULL::character varying
cof_ordemescritalancamento varchar 22 √ NULL::character varying
cof_lancamentosvalor bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
cof_configexportcontab_key Primary key Asc cof_configexportcontab_id
cof_configexportcontab_uu_idx Must be unique Asc cof_configexportcontab_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation