Airline tbl

From UG

Revision as of 08:45, 31 January 2010 (edit) Alex (Talk | contribs) m (moved Tbl Airline to Airline (tbl)) ← Older edit		Revision as of 21:10, 3 February 2010 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 1:		Line 1:
	[[Category:Admin Data Objects]]		[[Category:Admin Data Objects]]
-	== MySQL Table Definitions ==	+	== MySQL  ==
	<pre>		<pre>
Line 27:		Line 27:
	</pre>		</pre>
-	== Related Business Object and Its Fields ==	+	== Fields ==
		+
		+	===Id===
-	This table corresponds to '''Airline''' business object.	+	` int(10) NOT NULL auto_increment,
-	See its fields (attributes) below.	+	===TwoLetterCode===
		+	` varchar(2) NOT NULL,
-	=== TwoLetterCode ===	+	===Name===` varchar(30) NOT NULL,
-	* ''meaning:'' Airline 2 Letter unique Code	+	===NumericCode===` varchar(3) NOT NULL,
-	* ''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	+

---

Revision as of 21:10, 3 February 2010

Contents 1 MySQL 2 Fields 2.1 Id 2.2 TwoLetterCode

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;

Fields

Id

` int(10) NOT NULL auto_increment,

TwoLetterCode

` varchar(2) NOT NULL,

===Name===` varchar(30) NOT NULL,

===NumericCode===` varchar(3) NOT NULL,