Airline bo

From UG

Revision as of 15:44, 23 March 2010 (edit) Montira (Talk | contribs) (→Fields) ← Older edit		Revision as of 15:50, 23 March 2010 (edit) (undo) Montira (Talk | contribs) (→Fields) Newer edit →
Line 28:		Line 28:
	=== Carrier's headquarter address ===		=== Carrier's headquarter address ===
-		+	* ''meaning:'' address of carrier's headquarter per local office
		+	* ''type/format:'' [[alphanumeric]] and symbol
	=== Agent's IATA code ===		=== Agent's IATA code ===

---

Revision as of 15:50, 23 March 2010

Contents 1 Links 2 Fields 2.1 Two Letter Code 2.2 Name 2.3 Numeric Code 2.4 Carrier's headquarter address 2.5 Agent's IATA code 2.6 Carrier's account number

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

Carrier's headquarter address

• meaning: address of carrier's headquarter per local office
• type/format: alphanumeric and symbol

Agent's IATA code

Carrier's account number