Shipment Group (tbl)
From UG
(Difference between revisions)
(→Useful Queries) |
|||
Line 1: | Line 1: | ||
- | [[Category: | + | [[Category:Shipment Data Objects]] |
Revision as of 08:30, 31 January 2010
mysql> describe tblShipmentGroup; +-----------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------+------+-----+---------+----------------+ | Id | int(10) | NO | PRI | NULL | auto_increment | | TransportModeId | int(10) | NO | MUL | NULL | | | ClientCompanyId | int(10) | NO | MUL | NULL | | | MasterId | int(10) | YES | MUL | NULL | | +-----------------+---------+------+-----+---------+----------------+ 4 rows in set
Useful Queries
- selectAll
SELECT sg.Id AS Id, sg.MasterId as MasterId, tm.Id AS TransportModeId, tm.Mode AS TransportModeValue, cc.Id AS ClientCompanyId, cc.CompanyName AS ClientCompanyName FROM tblShipmentGroup sg, tblTransportMode tm, tblClientCompany cc WHERE sg.TransportModeId=tm.Id AND sg.ClientCompanyId=cc.Id ORDER BY Id;
- delete grp
DELETE FROM tblShipmentGroup WHERE Id= ...
SELECT Id AS Id FROM tblGenericShipment WHERE ShipmentGroupId = ... ORDER BY Id