cof_mdfe_reboque

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_cofmdfereboque R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_cofmdfereboque R
cof_mdfe_id numeric 10 √ NULL::numeric
cof_mdfe.cof_mdfe_id cofmdfe_cofmdfereboque R
cof_mdfe_reboque_id numeric 10 null
cof_mdfe_reboque_uu varchar 36 √ NULL::character varying
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_cofmdfereboque R
isactive bpchar 1 'Y'::bpchar
updated timestamp 29,6 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_cofmdfereboque R
cof_equipments_id numeric 10 null
cof_equipments.cof_equipments_id cofequipments_cofmdfereboque R
cof_mdfe_placa varchar 100 √ NULL::character varying
cof_mdfe_renavam varchar 100 √ NULL::character varying
cof_mdfe_capkg numeric 0 √ null
cof_mdfe_capacidadekg numeric 0 √ null
cof_mdfe_ufequip_id numeric 10 √ NULL::numeric
c_region.c_region_id cofmdfeufequip_cofmdfereboque R
cof_mdfe_isveicproprio bpchar 1 'Y'::bpchar
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_cofmdfereboque R
c_bpartner_location_id numeric 10 √ NULL::numeric
c_bpartner_location.c_bpartner_location_id cbpartnerlocation_cofmdfereboq R
cof_mdfe_rntrc varchar 100 √ NULL::character varying
cof_mdfe_tipoprop bpchar 1 √ null
cof_mdfe_codagendamento varchar 16 √ NULL::character varying
cof_mdfe_tpcar varchar 2 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
cof_mdfe_reboque_key Primary key Asc cof_mdfe_reboque_id
cof_mdfe_reboque_uu_idx Must be unique Asc cof_mdfe_reboque_uu

Check Constraints

Constraint Name Constraint
cof_mdfe_reboque_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
cof_mdfe_reboque_cof_mdfe_isveicproprio_check ((cof_mdfe_isveicproprio = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation