Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
|||
| roomno | varchar | 5 | null |
|
|
|||
| statusno | bpchar | 3 | null |
|
|
|||
| maidstatus | bpchar | 2 | √ | null |
|
|
||
| dateref | date | 13 | null |
|
|
|||
| qty | int2 | 5 | √ | 0 |
|
|
||
| pax | int2 | 5 | √ | 0 |
|
|
||
| room | numeric | 10,2 | √ | 0 |
|
|
||
| service | numeric | 10,2 | √ | 0 |
|
|
||
| tax | numeric | 10,2 | √ | 0 |
|
|
||
| arrqty | int2 | 5 | √ | 0 |
|
|
||
| arrpax | int2 | 5 | √ | 0 |
|
|
||
| roomtypeno | bpchar | 5 | √ | null |
|
|
||
| orino | bpchar | 3 | √ | null |
|
|
||
| natno | bpchar | 5 | √ | null |
|
|
||
| agentno | int4 | 10 | √ | null |
|
|
||
| saleno | bpchar | 3 | √ | null |
|
|
||
| rsvtypeno | bpchar | 3 | √ | null |
|
|
||
| rateno | bpchar | 3 | √ | null |
|
|
||
| condno | bpchar | 3 | √ | null |
|
|
||
| comp | bpchar | 1 | √ | 'N'::bpchar |
|
|
||
| hsu | bpchar | 1 | √ | 'N'::bpchar |
|
|
||
| walkin | bpchar | 1 | √ | 'N'::bpchar |
|
|
||
| groupflag | bpchar | 1 | √ | 'N'::bpchar |
|
|
||
| dayused | int2 | 5 | √ | null |
|
|
||
| dau_pax | int2 | 5 | √ | null |
|
|
||
| dau_room | numeric | 10,2 | √ | null |
|
|
||
| stattype | bpchar | 2 | √ | null |
|
|
||
| startdate | date | 13 | √ | null |
|
|
||
| enddate | date | 13 | √ | null |
|
|
||
| bedtypeno | bpchar | 3 | √ | null |
|
|
||
| bldgno | bpchar | 3 | √ | null |
|
|
||
| memberno | varchar | 20 | √ | null |
|
|
||
| ctno | bpchar | 3 | √ | null |
|
|
||
| lang_id | int4 | 10 | √ | null |
|
|
||
| mktno | bpchar | 3 | √ | null |
|
|
||
| gsttype | bpchar | 1 | √ | null |
|
|
||
| vipno | bpchar | 3 | √ | null |
|
|
||
| accno | int4 | 10 | √ | null |
|
|
||
| guestno | int4 | 10 | √ | null |
|
|
||
| adult | int2 | 5 | √ | null |
|
|
||
| child | int2 | 5 | √ | null |
|
|
||
| dau_adult | int2 | 5 | √ | null |
|
|
||
| dau_child | int2 | 5 | √ | null |
|
|
||
| arp | int2 | 5 | √ | null |
|
|
||
| age | int2 | 5 | √ | null |
|
|
||
| sex | bpchar | 1 | √ | null |
|
|
||
| name | varchar | 125 | √ | null |
|
|
||
| bpchar | 1 | √ | 'N'::bpchar |
|
|
|||
| crno | bpchar | 3 | √ | null |
|
|
||
| abf | numeric | 10,2 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
