Airline tbl
From UG
(Difference between revisions)
(→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
- meaning: Airline 3 Letter Numeric unique Code:
- type/format: Datatypes#positive integer; exactly 3 digits
- example: 999