Steamshipline tbl
From UG
Contents |
[edit] MySQL Table Definitions
on 02-Feb-2010
mysql> describe tblsteamshipline; +---------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+-------------+------+-----+---------+----------------+ | Id | int(10) | NO | PRI | NULL | auto_increment | | Name | varchar(30) | NO | | NULL | | | SCACCode | varchar(4) | NO | | NULL | | | TrackingCarrierCode | varchar(30) | YES | | NULL | | +---------------------+-------------+------+-----+---------+----------------+ 4 rows in set CREATE TABLE `tblsteamshipline` ( `Id` int(10) NOT NULL AUTO_INCREMENT, `Name` varchar(30) NOT NULL, `SCACCode` varchar(4) NOT NULL, `TrackingCarrierCode` varchar(30) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
[edit] Fields
[edit] Id
` int(10) NOT NULL AUTO_INCREMENT,
[edit] Name
` varchar(30) NOT NULL,
[edit] SCACCode
` varchar(4) NOT NULL,
[edit] TrackingCarrierCode
` varchar(30) DEFAULT NULL,