Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| dateref | date | 13 | null |
|
|
|||
| ttlrm | int2 | 5 | 0 |
|
|
|||
| ooorm | int2 | 5 | 0 |
|
|
|||
| oosrm | int2 | 5 | 0 |
|
|
|||
| ooirm | int2 | 5 | 0 |
|
|
|||
| occrm | int2 | 5 | null |
|
|
|||
| occpax | int2 | 5 | null |
|
|
|||
| hsurm | int2 | 5 | 0 |
|
|
|||
| hsupax | int2 | 5 | null |
|
|
|||
| comrm | int2 | 5 | 0 |
|
|
|||
| compax | int2 | 5 | null |
|
|
|||
| indqty | int2 | 5 | null |
|
|
|||
| indpax | int2 | 5 | null |
|
|
|||
| indrev | numeric | 10,2 | 0 |
|
|
|||
| indser | numeric | 10,2 | 0 |
|
|
|||
| indtax | numeric | 10,2 | 0 |
|
|
|||
| grpqty | int2 | 5 | null |
|
|
|||
| grppax | int2 | 5 | null |
|
|
|||
| grprev | numeric | 10,2 | 0 |
|
|
|||
| grpser | numeric | 10,2 | 0 |
|
|
|||
| grptax | numeric | 10,2 | 0 |
|
|
|||
| indextbed | numeric | 10,2 | 0 |
|
|
|||
| grpextbed | numeric | 10,2 | null |
|
|
|||
| arrqty | int2 | 5 | null |
|
|
|||
| arrpax | int2 | 5 | null |
|
|
|||
| depqty | int2 | 5 | null |
|
|
|||
| deppax | int2 | 5 | null |
|
|
|||
| dayuse | int2 | 5 | null |
|
|
|||
| bkkqty | int2 | 5 | 0 |
|
|
|||
| bkkpax | int2 | 5 | 0 |
|
|
|||
| wlkqty | int2 | 5 | 0 |
|
|
|||
| wlkpax | int2 | 5 | 0 |
|
|
|||
| ecoqty | int2 | 5 | null |
|
|
|||
| xciqty | int2 | 5 | null |
|
|
|||
| clxqty | int2 | 5 | 0 |
|
|
|||
| clxpax | int2 | 5 | 0 |
|
|
|||
| nosqty | int2 | 5 | 0 |
|
|
|||
| nospax | int2 | 5 | 0 |
|
|
|||
| exparr | int2 | 5 | 0 |
|
|
|||
| expdep | int2 | 5 | 0 |
|
|
Relationships
Close relationships within degrees of separation
