Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
POS情報ID |
||||
| import_id | BIGINT UNSIGNED | 20 | √ | null |
|
|
|||||
| process_kind_id | VARCHAR | 1 | √ | null |
|
|
処理区分 |
||||
| user_id | VARCHAR | 20 | null |
|
|
Member#/法人統一番号 |
|||||
| department_kind_id | VARCHAR | 3 | √ | null |
|
|
部門種別 |
||||
| hotel_code | VARCHAR | 10 | √ | null |
|
|
ホテルコード |
||||
| store_code | VARCHAR | 10 | √ | null |
|
|
店舗コード |
||||
| used_at | 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 |
|
|
割引率 |
||||
| bill_number | VARCHAR | 20 | √ | null |
|
|
明細番号 |
||||
| payment_methods | VARCHAR | 20 | √ | null |
|
|
支払方法 |
||||
| timeframe | VARCHAR | 20 | √ | null |
|
|
時間帯 |
||||
| food_total | DECIMAL | 8,2 | √ | null |
|
|
FOOD合計 |
||||
| beverage_total | DECIMAL | 8,2 | √ | null |
|
|
BEVERAGE合計 |
||||
| misc_total | DECIMAL | 8,2 | √ | null |
|
|
ミスク合計 |
||||
| amount_eligible_for_points | DECIMAL | 8,2 | √ | null |
|
|
ポイント対象金額 |
||||
| amount_without_eligible_for_points | DECIMAL | 8,2 | √ | null |
|
|
ポイント対象外金額 |
||||
| 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_point_of_sales_information_import_id_index | Performance | Asc | import_id |
| nk_point_of_sales_information_used_at_index | Performance | Asc | used_at |
| nk_point_of_sales_information_user_id_index | Performance | Asc | user_id |