Shipment Group (tbl)
From UG
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