cof_packinglist

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cof_packinglist_id numeric 10 null
cof_ocorrenciaembdes.cof_packinglist_id cofpackinglist_cofocorrenciaem R
cof_packinglist_line.cof_packinglist_id cofpackinglist_cofpackinglistl C
cof_rv_detalheslistaembarque.cof_packinglist_id Implied Constraint R
cof_packinglist_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
status varchar 2 'OP'::character varying
cof_packingtype varchar 2 null
cof_packingdate timestamp 29,6 √ null
startdate timestamp 29,6 √ null
enddate timestamp 29,6 √ null
cof_driver_id numeric 10 √ NULL::numeric
cof_driver.cof_driver_id cofdriver_cofpackinglist R
cof_licensenumber varchar 11 √ NULL::character varying
lbr_cpf varchar 14 √ NULL::character varying
cof_equipments_id numeric 10 √ NULL::numeric
cof_equipments.cof_equipments_id cofequipments_cofpackinglist R
cof_chassi varchar 17 √ NULL::character varying
cof_platenumber varchar 8 √ NULL::character varying
cof_kminitial numeric 0 √ null
cof_kmfinal numeric 0 √ null
m_shipper_id numeric 10 √ NULL::numeric
m_shipper.m_shipper_id mshipper_cofpackinglist R
description varchar 255 √ NULL::character varying
weight numeric 0 √ null
documentno varchar 30 √ NULL::character varying
cof_processing bpchar 1 √ NULL::bpchar
processing bpchar 1 √ NULL::bpchar
cof_stateplate_id numeric 10 √ NULL::numeric
c_region.c_region_id cofstateplate_cofpackinglist R
linkurl varchar 2000 √ null
html text 2147483647 √ null
cof_isprinted bpchar 1 'N'::bpchar
cof_m_shipregion_id numeric 10 √ NULL::numeric
cof_m_shipregion.cof_m_shipregion_id cofmshipregion_cofpackinglist R
cof_porteiroentrada_id numeric 10 √ null
ad_user.ad_user_id cofporteiroentrada_cofpackingl R
cof_porteirosaida_id numeric 10 √ null
ad_user.ad_user_id cofporteirosaida_cofpackinglis R
cof_kmentrada numeric 10 √ NULL::numeric
cof_kmsaida numeric 10 √ NULL::numeric
cof_toleranciaadsaida numeric 0 √ null
cof_toleranciaadentrada numeric 0 √ null
cof_situacaoembarque varchar 2 'AP'::character varying
issotrx bpchar 1 'Y'::bpchar
cof_pesocarregamento numeric 15 √ null
cof_pesoentrada_id numeric 15 √ null
cof_pesosaida_id numeric 15 √ null
cof_tara numeric 15 √ null
cof_fase varchar 3 √ NULL::character varying
cof_helper varchar 40 √ NULL::character varying
cof_warehouseto_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id cofwarehouseto_cofpackinglist R
cof_warehouse_id numeric 10 √ NULL::numeric
m_warehouse.m_warehouse_id cofwarehouse_cofpackinglist R

Indexes

Constraint Name Type Sort Column(s)
cof_packinglist_key Primary key Asc cof_packinglist_id
cof_packinglist_uu_idx Must be unique Asc cof_packinglist_uu

Check Constraints

Constraint Name Constraint
cof_packinglist_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_packinglist_cof_isprinted_check ((cof_isprinted = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_packinglist_issotrx_check ((issotrx = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation