Airline bo

From UG

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

[edit] Links

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

[edit] Fields

[edit] Two Letter Code

• meaning: Airline 2 Letter unique Code
• type/format: Datatypes#alpha; exactly 2 chars; all caps
• example: CA

[edit] Name

• meaning: human readable airline company name
• type/format: alphanumeric; min=1 char; max=30 chars
• example: Air China

[edit] Numeric Code

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

[edit] Carrier's headquarter address

• meaning: address of carrier's headquarter per local office
• type/format: Alphanumeric#ascii; min = 1 char; max = 150 chars
• Example:

Plane Handling c/o Virgin Atlantic 
CARGO POINT 1-BEDFONT RD-STANWELL
HEATHROW AIRPORT - GB 

• NOTE: 4 lines with 15 -20 words.

[edit] Agent's IATA code

• meaning: Sequence of figures from 10 to 13 digits with minus and slash authorized:
• type/format: Alphanumeric#ascii; min = 10 digits; max = 13 digits
• example: 20-405035/9510

[edit] Carrier's account number

• meaning: Account number unique Code
• type/format: Datatypes#positive integer; min = 12 digits; max = 15 digits
• example: 122333444455555