shipperconf


Description

A method with which two or more different client accounts can allow command execution on its own units

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idshipperconf int4 10 null
mvw_shipperconf.idshipperconf Implied Constraint R
shipperconf_command.idshipperconf FK_sharedview_command_sharedview R
shipperconf_macros.idshipperconf FK_sharedview_macros_sharedview R
shipperconf_unitgroup.idshipperconf FK_sharedview_unitgroup_sharedview R
vw_shipperconf.idshipperconf Implied Constraint R
vw_shipperconf_all.idshipperconf Implied Constraint R
vw_shipperconf_extended.idshipperconf Implied Constraint R
vw_shipperconf_extended_all.idshipperconf Implied Constraint R
idclientowner int4 10 null
client.idclient FK_shipperconf_clientowner R
idclientshipper int4 10 null
client.idclient FK_shipperconf_client R
mgssendreceive bpchar 2 null
startdate timestamp 29,6 null
finishdate timestamp 29,6 √ null
configdate timestamp 29,6 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
assigntype int4 10 0
aef_id int4 10 √ null
idbranch int4 10 √ null
branch.idbranch Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
PK_idshipperconf Primary key Asc idshipperconf
UQ_shipperconf_idshipperconf Must be unique Asc idshipperconf

Relationships

Close relationships within degrees of separation