Airline bo

From UG

Revision as of 21:08, 3 February 2010 (edit) Alex (Talk | contribs) (Created page with 'Category:Admin Data Objects == Links == * ''CRUD:'' Airlines (component) * ''MySQL:'' Airlines tbl == Fields == === Two Letter Code === * ''meaning:'' Airline …') ← Older edit		Revision as of 21:09, 3 February 2010 (edit) (undo) Alex (Talk | contribs) (→Links) Newer edit →
Line 4:		Line 4:
	* ''CRUD:''  [[Airlines (component)]]		* ''CRUD:''  [[Airlines (component)]]
-	* ''MySQL:'' [[Airlines tbl]]	+	* ''MySQL:'' [[Airline tbl]]
	== Fields ==		== Fields ==

---

Revision as of 21:09, 3 February 2010

Contents 1 Links 2 Fields 2.1 Two Letter Code 2.2 Name 2.3 Numeric Code

Links

• CRUD: Airlines (component)
• MySQL: Airline tbl

Fields

Two Letter Code

• 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

Numeric Code

• meaning: Airline 3 Letter Numeric unique Code:
• type/format: Datatypes#positive integer; exactly 3 digits
• example: 999