Airline tbl

From UG

(Difference between revisions)
Jump to: navigation, search
(Related Business Object and Its Fields)
 
(9 intermediate revisions not shown)
Line 1: Line 1:
-
[[Category: DB]]
+
[[Category:Carriers]]
-
== Describe and Create ==
+
== MySQL  ==
<pre>
<pre>
Line 27: Line 27:
</pre>
</pre>
 +
==  Fields ==
 +
 +
===Id===
-
== Related Business Object and Its Fields ==
+
` int(10) NOT NULL auto_increment,
-
This table corresponds to Airline object.
+
===TwoLetterCode===
-
=== TwoLetterCode ===
+
` varchar(2) NOT NULL,
-
* ''meaning:'' Airline 2 Letter unique Code
+
===Name===
-
* ''type/format:''  [[Datatypes#alpha]]; exactly 2 chars; all caps
+
-
* ''example:'' CA
+
-
=== Name ===
+
` varchar(30) NOT NULL,
-
* ''meaning:'' human readable airline company name
+
===NumericCode===
-
* ''type/format:''  [[alphanumeric]]; min=1 char; max=30 chars
+
-
* ''example:'' Air China
+
-
===  NumericCode ===
+
` varchar(3) NOT NULL,
-
 
+
-
* ''meaning:'' Airline 3 Letter Numeric unique Code:
+
-
* ''type/format:'' [[Datatypes#positive integer]]; exactly 3 digits
+
-
* ''example:'' 999
+

Current revision as of 21:22, 3 February 2010


Contents

[edit] MySQL


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;

[edit] Fields

[edit] Id

` int(10) NOT NULL auto_increment,

[edit] TwoLetterCode

` varchar(2) NOT NULL,

[edit] Name

` varchar(30) NOT NULL,

[edit] NumericCode

` varchar(3) NOT NULL,

Personal tools