Steamshipline tbl
From UG
(Difference between revisions)
(Created page with 'Category:Admin Data Objects == MySQL Table Definitions == on 02-Feb-2010 <pre> mysql> describe tblsteamshipline; +---------------------+-------------+------+-----+------…') |
|||
Line 27: | Line 27: | ||
</pre> | </pre> | ||
- | == | + | == Fields == |
- | + | ||
- | + | ||
- | + | ||
- | + | ||
=== Id === | === Id === | ||
- | + | ` int(10) NOT NULL AUTO_INCREMENT, | |
=== Name === | === Name === | ||
- | + | ` varchar(30) NOT NULL, | |
- | + | ||
- | + | ||
- | === | + | === SCACCode === |
- | + | ` varchar(4) NOT NULL, | |
- | + | ||
- | + | ||
- | === | + | === TrackingCarrierCode === |
- | + | ` varchar(30) DEFAULT NULL, | |
- | + | ||
- | + |
Revision as of 19:59, 3 February 2010
Contents |
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;
Fields
Id
` int(10) NOT NULL AUTO_INCREMENT,
Name
` varchar(30) NOT NULL,
SCACCode
` varchar(4) NOT NULL,
TrackingCarrierCode
` varchar(30) DEFAULT NULL,