Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| prop_id | int4 | 10 | null |
|
|
|||
| prop_code | text | 2147483647 | √ | null |
|
|
||
| name | text | 2147483647 | null |
|
|
|||
| company | text | 2147483647 | null |
|
|
|||
| logo | bytea | 2147483647 | √ | null |
|
|
||
| logo_type | text | 2147483647 | √ | null |
|
|
||
| address1 | text | 2147483647 | √ | null |
|
|
||
| address2 | text | 2147483647 | √ | null |
|
|
||
| address3 | text | 2147483647 | √ | null |
|
|
||
| address4 | text | 2147483647 | √ | null |
|
|
||
| text | 2147483647 | √ | null |
|
|
|||
| telephone | text | 2147483647 | √ | null |
|
|
||
| fax | text | 2147483647 | √ | null |
|
|
||
| website | text | 2147483647 | √ | null |
|
|
||
| system_params | jsonb | 2147483647 | √ | null |
|
|
BACKUP_DAYS = จำนวนวันที่เก็บข้อมูลไว้หลังจาก checkout ก่อนจะ move ไป archive CLEARING_DAYS = จำนวนวันที่เก็บข้อมูลไว้ใน archive ก่อนจะลบ |
|
| prop_key | text | 2147483647 | √ | null |
|
|
||
| tax_id | text | 2147483647 | √ | null |
|
|
||
| branch_no | text | 2147483647 | √ | null |
|
|
||
| logo_url | text | 2147483647 | √ | null |
|
|
||
| city | text | 2147483647 | √ | null |
|
|
Property city used by external listings such as Google Hotel Center. |
|
| province | text | 2147483647 | √ | null |
|
|
Property province or state used by external listings. |
|
| postal_code | text | 2147483647 | √ | null |
|
|
Property postal code used by external listings. |
|
| country_code | text | 2147483647 | √ | null |
|
|
ISO 3166-1 alpha-2 country code used by external listings. |
|
| latitude | numeric | 9,6 | √ | null |
|
|
Property latitude in decimal degrees. |
|
| longitude | numeric | 9,6 | √ | null |
|
|
Property longitude in decimal degrees. |
|
| category | text | 2147483647 | 'hotel'::text |
|
|
Property category used by external listings; defaults to hotel. |
||
| hotel_brand | text | 2147483647 | √ | null |
|
|
Optional hotel brand used by external listings. |
|
| star_rating | numeric | 2,1 | √ | null |
|
|
Optional property star rating from 1.0 to 5.0. |
|
| alternate_hotel_id | text | 2147483647 | √ | null |
|
|
Optional alternate property identifier used by external listings. |
|
| name2 | text | 2147483647 | √ | null |
|
|
Property name in the secondary language; null when not configured. |
|
| company2 | text | 2147483647 | √ | null |
|
|
Company name in the secondary language; null when not configured. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_property_info | Primary key | Asc | prop_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| property_info_country_code_check | ((country_code IS NULL) OR (country_code ~ '^[A-Z]{2}$'::text)) |
| property_info_latitude_check | ((latitude IS NULL) OR ((latitude >= ('-90'::integer)::numeric) AND (latitude <= (90)::numeric))) |
| property_info_star_rating_check | ((star_rating IS NULL) OR ((star_rating >= (1)::numeric) AND (star_rating <= (5)::numeric))) |
| property_info_longitude_check | ((longitude IS NULL) OR ((longitude >= ('-180'::integer)::numeric) AND (longitude <= (180)::numeric))) |
Relationships
Close relationships within degrees of separation
