Steamshipline tbl

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:Admin Data Objects == MySQL Table Definitions == on 02-Feb-2010 <pre> mysql> describe tblsteamshipline; +---------------------+-------------+------+-----+------…')
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:''
+

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,

Personal tools