Airline tbl

From UG

(Difference between revisions)
Jump to: navigation, search
(TwoLetterCode)
(Related Business Object and Its Fields)
Line 34: Line 34:
=== TwoLetterCode ===
=== TwoLetterCode ===
-
* ''meaning:''
+
* ''meaning:'' Airline 2 Letter unique Code
* ''type/format:''  [[Datatypes#alpha]]; exactly 2 chars; all caps
* ''type/format:''  [[Datatypes#alpha]]; exactly 2 chars; all caps
-
* ''example:''
+
* ''example:'' CA
=== Name ===
=== Name ===
 +
* ''meaning:'' human readable airline company name
* ''type/format:''  [[alphanumeric]]; min=1 char; max=30 chars
* ''type/format:''  [[alphanumeric]]; min=1 char; max=30 chars
 +
* ''example:'' Air China
===  NumericCode ===
===  NumericCode ===
 +
* ''meaning:'' Airline 3 Letter Numeric unique Code:
* ''type/format:'' [[Datatypes#positive integer]]; exactly 3 digits
* ''type/format:'' [[Datatypes#positive integer]]; exactly 3 digits
 +
* ''example:'' 999

Revision as of 00:57, 30 January 2010


Contents

Describe and Create


mysql> describe tblAirline;
+---------------+-------------+------+-----+---------+----------------+
| Field         | Type        | Null | Key | Default | Extra          |
+---------------+-------------+------+-----+---------+----------------+
| Id            | int(10)     | NO   | PRI | NULL    | auto_increment |
| TwoLetterCode | varchar(2)  | NO   |     | NULL    |                |
| Name          | varchar(30) | NO   |     | NULL    |                |
| NumericCode   | varchar(3)  | NO   |     | NULL    |                |
+---------------+-------------+------+-----+---------+----------------+
4 rows in set



CREATE TABLE `tblAirline` (
  `Id` int(10) NOT NULL auto_increment,
  `TwoLetterCode` varchar(2) NOT NULL,
  `Name` varchar(30) NOT NULL,
  `NumericCode` varchar(3) NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=83 DEFAULT CHARSET=latin1;


Related Business Object and Its Fields

This table corresponds to Airline object.

TwoLetterCode

  • meaning: Airline 2 Letter unique Code
  • type/format: Datatypes#alpha; exactly 2 chars; all caps
  • example: CA

Name

  • meaning: human readable airline company name
  • type/format: alphanumeric; min=1 char; max=30 chars
  • example: Air China

NumericCode

Personal tools