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

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