Steamshipline tbl

From UG

Revision as of 18:21, 2 February 2010 (edit) Andrei (Talk | contribs) (Created page with 'Category:Admin Data Objects == MySQL Table Definitions == on 02-Feb-2010 <pre> mysql> describe tblsteamshipline; +---------------------+-------------+------+-----+------…') ← Older edit		Current revision as of 21:22, 3 February 2010 (edit) (undo) Alex (Talk | contribs)
(2 intermediate revisions not shown)
Line 1:		Line 1:
-	[[Category:Admin Data Objects]]	+	[[Category:Carriers]]
	== MySQL Table Definitions  ==		== MySQL Table Definitions  ==
Line 27:		Line 27:
	</pre>		</pre>
-	== Related Business Object and Its Fields ==	+	== Fields ==
-		+
-	This table corresponds to '''Steamshipline''' business object.	+
-		+
-	See its fields (attributes) below.	+
	=== Id ===		=== Id ===
-	* ''meaning:'' PRI key	+	` int(10) NOT NULL AUTO_INCREMENT,
	=== Name ===		=== Name ===
-	* ''meaning:'' human readable steamshipline company name	+	` varchar(30) NOT NULL,
-	* ''type/format:''  [[Datatypes#alphanumeric]]; min=1 char; max=30 chars	+
-	* ''example:'' China Shipping	+
-	=== SCACCode ===	+	=== SCACCode ===
-	* ''meaning:'' Steamshipline 4 Letter unique Code	+	` varchar(4) NOT NULL,
-	* ''type/format:'' [[Datatypes#alpha]]; exactly 4 chars	+
-	* ''example:'' CHHK	+
-	=== TrackingCarrierCode ===	+	=== TrackingCarrierCode ===
-	* ''meaning:''	+	` varchar(30) DEFAULT NULL,
-	* ''type/format:'' [[Datatypes#]]; max=30 chars	+
-	* ''example:''	+

---

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,