Airline tbl

From UG

Revision as of 01:01, 30 January 2010 (edit) Alex (Talk | contribs) (→MySQL Table Definitions) ← Older edit		Revision as of 06:08, 31 January 2010 (edit) (undo) Alex (Talk | contribs) (→Related MySQL Table Definitions) Newer edit →
Line 1:		Line 1:
	[[Category: DB]]		[[Category: DB]]
-	== Related MySQL Table Definitions  ==	+	== MySQL Table Definitions  ==
	<pre>		<pre>

---

Revision as of 06:08, 31 January 2010

Contents 1 MySQL Table Definitions 2 Related Business Object and Its Fields 2.1 TwoLetterCode 2.2 Name 2.3 NumericCode

MySQL Table Definitions

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 business object.

See its fields (attributes) below.

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