Steamshipline tbl

From UG

Revision as of 19:59, 3 February 2010 (edit) Alex (Talk | contribs) ← Older edit		Current revision as of 21:22, 3 February 2010 (edit) (undo) Alex (Talk | contribs)
(One intermediate revision not shown)
Line 1:		Line 1:
-	[[Category:Admin Data Objects]]	+	[[Category:Carriers]]
	== MySQL Table Definitions  ==		== MySQL Table Definitions  ==

---

Current revision as of 21:22, 3 February 2010

Contents 1 MySQL Table Definitions 2 Fields 2.1 Id 2.2 Name 2.3 SCACCode 2.4 TrackingCarrierCode

[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,