Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
宿泊情報ID |
||||
| import_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
|||||
| process_kind_id | VARCHAR | 1 | √ | null |
|
|
処理区分 |
||||
| user_id | VARCHAR | 20 | null |
|
|
Member#/ARNo |
|||||
| inside_user_id | VARCHAR | 20 | √ | null |
|
|
内部顧客番号 |
||||
| department_kind_id | VARCHAR | 3 | √ | null |
|
|
部門種別 |
||||
| hotel_code | VARCHAR | 10 | √ | null |
|
|
ホテルコード |
||||
| sub_department_kind_id | VARCHAR | 10 | √ | null |
|
|
サブ部門種別 |
||||
| checkin_date | VARCHAR | 10 | √ | null |
|
|
チェックイン日 |
||||
| checkout_date | VARCHAR | 10 | √ | null |
|
|
チェックアウト日 |
||||
| introduction_id | VARCHAR | 1 | √ | null |
|
|
紹介区分 |
||||
| total_amount | DECIMAL | 8,2 | √ | null |
|
|
利用額 |
||||
| number_of_guests | INT | 10 | √ | null |
|
|
一泊利用人数 |
||||
| discount_rate | DECIMAL | 8,2 | √ | null |
|
|
割引率 |
||||
| discount_kind_id | VARCHAR | 20 | √ | null |
|
|
割引区分 |
||||
| user_name | VARCHAR | 40 | √ | null |
|
|
利用者名 |
||||
| guest_number | VARCHAR | 20 | √ | null |
|
|
ゲスト一意番号 |
||||
| payment_methods | VARCHAR | 20 | √ | null |
|
|
支払方法 |
||||
| card_name | VARCHAR | 20 | √ | null |
|
|
カード名 |
||||
| reservation_number | VARCHAR | 20 | √ | null |
|
|
予約No |
||||
| company_name | VARCHAR | 40 | √ | null |
|
|
利用会社名 |
||||
| room_type | VARCHAR | 40 | √ | null |
|
|
部屋タイプ |
||||
| room_number | VARCHAR | 10 | √ | null |
|
|
部屋No |
||||
| rate_code | VARCHAR | 20 | √ | null |
|
|
レートコード |
||||
| room_charge | DECIMAL | 8,2 | √ | null |
|
|
室料 |
||||
| extension_room | DECIMAL | 8,2 | √ | null |
|
|
延室数 |
||||
| extension_fee | DECIMAL | 8,2 | √ | null |
|
|
延室料 |
||||
| food_total | DECIMAL | 8,2 | √ | null |
|
|
(POS宿掛)税サ込み:食事合計 |
||||
| beverage_total | DECIMAL | 8,2 | √ | null |
|
|
(POS宿掛)税サ込み:飲物合計 |
||||
| misc_total | DECIMAL | 8,2 | √ | null |
|
|
ミスク金額合計 |
||||
| total_number_of_guests | INT | 10 | √ | null |
|
|
延べ人数 |
||||
| segment | VARCHAR | 20 | √ | null |
|
|
SEGMENT |
||||
| route | VARCHAR | 20 | √ | null |
|
|
経路 |
||||
| corporation_number | VARCHAR | 40 | √ | null |
|
|
法人・代理店プロファイル番号 |
||||
| comment | VARCHAR | 60 | √ | null |
|
|
COMMENT |
||||
| remarks | VARCHAR | 1000 | √ | null |
|
|
REMARKS |
||||
| online_travel_agent | VARCHAR | 1 | √ | null |
|
|
OTA識別 |
||||
| created_by | VARCHAR | 8 | null |
|
|
作成者 |
|||||
| created_at | DATETIME | 19 | null |
|
|
作成日時 |
|||||
| updated_by | VARCHAR | 8 | null |
|
|
更新者 |
|||||
| updated_at | DATETIME | 19 | null |
|
|
更新日時 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| nk_stay_information_checkin_date_index | Performance | Asc | checkin_date |
| nk_stay_information_checkout_date_index | Performance | Asc | checkout_date |
| nk_stay_information_department_kind_id_index | Performance | Asc | department_kind_id |
| nk_stay_information_import_id_index | Performance | Asc | import_id |
| nk_stay_information_user_id_index | Performance | Asc | user_id |