Shipment Group (tbl)
From UG
(Difference between revisions)
(Created page with 'Category:DB') |
|||
Line 1: | Line 1: | ||
[[Category:DB]] | [[Category:DB]] | ||
+ | |||
+ | |||
+ | <pre> | ||
+ | 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 | ||
+ | </pre> |
Revision as of 23:57, 8 December 2009
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