Steamshipline tbl

From UG

Revision as of 18:21, 2 February 2010 by Andrei (Talk | contribs)
(diff) ← Older revision | Current revision (diff) | Newer revision → (diff)
Jump to: navigation, search


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;

Related Business Object and Its Fields

This table corresponds to Steamshipline business object.

See its fields (attributes) below.

Id

  • meaning: PRI key

Name

  • meaning: human readable steamshipline company name
  • type/format: Datatypes#alphanumeric; min=1 char; max=30 chars
  • example: China Shipping

SCACCode

  • meaning: Steamshipline 4 Letter unique Code
  • type/format: Datatypes#alpha; exactly 4 chars
  • example: CHHK

TrackingCarrierCode

  • meaning:
  • type/format: Datatypes#; max=30 chars
  • example:
Personal tools