Airline bo
From UG
(Difference between revisions)
(Created page with 'Category:Admin Data Objects == Links == * ''CRUD:'' Airlines (component) * ''MySQL:'' Airlines tbl == Fields == === Two Letter Code === * ''meaning:'' Airline …') |
(→Fields) |
||
| (7 intermediate revisions not shown) | |||
| Line 1: | Line 1: | ||
| - | [[Category: | + | [[Category:Carriers]] |
== Links == | == Links == | ||
* ''CRUD:'' [[Airlines (component)]] | * ''CRUD:'' [[Airlines (component)]] | ||
| - | * ''MySQL:'' [[ | + | * ''MySQL:'' [[Airline tbl]] |
== Fields == | == Fields == | ||
| Line 26: | Line 26: | ||
* ''type/format:'' [[Datatypes#positive integer]]; exactly 3 digits | * ''type/format:'' [[Datatypes#positive integer]]; exactly 3 digits | ||
* ''example:'' 999 | * ''example:'' 999 | ||
| + | |||
| + | === 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. | ||
| + | |||
| + | === 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 | ||
| + | |||
| + | === Carrier's account number === | ||
| + | * ''meaning:'' Account number unique Code | ||
| + | * ''type/format:'' [[Datatypes#positive integer]]; min = 12 digits; max = 15 digits | ||
| + | * ''example:'' 122333444455555 | ||
Current revision as of 16:17, 23 March 2010
Contents |
[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
