client


Description

Client list

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idclient int4 10 null
afcdevice.idclient fk_afcdevice_idclient R
client_deviceconf.idclient fk_client_deviceconf R
client_extra_privilege.idclient fk_client_extra_privilege_idclient R
client_pos_status_conf.idclient fk_client_pos_status_conf_idclient R
coverage.idclient FK_coverage_client R
customunit.idclient FK_customunit_client R
device_profile_client.idclient fk_device_profile_client_idclient R
driver.idclient FK_driver_client R
driverloginconf.idclient fk_driverloginconf_idclient R
driverstatusconf.idclient fk_idclient R
georeference.idclient FK_georeference_client R
georeferencecategory.idclient FK_catgeoreference_client R
indicator.idclient fk_indicator_idclient R
macroconf.idclient fk_macroconf_client R
mayauser.idclient FK_mayauser_client R
mayausergroup.idclient FK_mayausergroup_client R
omnitracsuser.idclient FK_omnitracsuser_client R
report.idclient FK_report_client R
role.idclient FK_role_client R
route_definition.idclient route_definition_idclient_fkey R
shipperconf.idclientowner FK_shipperconf_clientowner R
shipperconf.idclientshipper FK_shipperconf_client R
technicalaccount.idclient FK_technicalaccount_client R
template.idclient FK_template_client R
unit.idclient FK_unit_client R
unitgroup.idclient FK_unitgroup_client R
vir_form.id_client fk_idclient R
idclientgroup int4 10 √ null
clientgroup.idclientgroup FK_client_company R
idprivilegegroup int4 10 null
privilegegroup.idprivilegegroup FK_client_privilegegroup R
idpreference int4 10 √ null
preference.idpreference FK_client_preference R
name varchar 256 null
clientcode varchar 16 √ null
contact varchar 30 √ null
phone varchar 20 √ null
createbyuser int4 10 null
creationdate timestamp 29,6 null
lastmodifiedbyuser int4 10 null
lastmodificationdate timestamp 29,6 null
originatingsystem varchar 50 null
enabled bool 1 true
status int4 10 0
aef_meta hstore 2147483647 √ null
aef_id int4 10 √ null

Identificador del sistema anterior para motivos de sincronización en el proceso de migración parcial
idbranch int4 10 √ null
branch.idbranch fk_client_idbranch R

Para saber de qué sucursal es el cliente
erpid varchar 20 null
idproduct int4 10 √ null
product.idproduct fk_client_idproduct R

Indexes

Constraint Name Type Sort Column(s)
PK_idclient Primary key Asc idclient
idx_unique_client_erpid_idproduct Must be unique Asc/Asc erpid + idproduct
UQ_client_idclient Must be unique Asc idclient
UQ_client_idpreference Must be unique Asc idpreference
UQ_clientcode Must be unique Asc clientcode

Relationships

Close relationships within degrees of separation