Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
ポイント付与連携ID |
||||
| nk_stay_information_id | BIGINT UNSIGNED | 20 | null |
|
|
宿泊情報テーブルID |
|||||
| nk_point_of_sales_information_id | BIGINT UNSIGNED | 20 | null |
|
|
POS情報テーブルID |
|||||
| kmc_id | INT | 10 | null |
|
|
KMCID |
|||||
| transaction_date | VARCHAR | 8 | null |
|
|
取引日付 |
|||||
| transaction_time | VARCHAR | 6 | null |
|
|
取引時間 |
|||||
| gave_point | INT | 10 | null |
|
|
付与ポイント数 |
|||||
| gave_reason | VARCHAR | 120 | null |
|
|
付与理由 |
|||||
| expiration_date_from | VARCHAR | 8 | √ | null |
|
|
有効期限from |
||||
| expiration_date_to | VARCHAR | 8 | √ | null |
|
|
有効期限to |
||||
| affiliated_store_id | VARCHAR | 8 | null |
|
|
加盟店ID |
|||||
| affiliated_store_group_id_first | VARCHAR | 8 | null |
|
|
加盟店グループID |
|||||
| affiliated_store_group_id_second | VARCHAR | 8 | null |
|
|
加盟店グループID2 |
|||||
| affiliated_store_group_id_third | VARCHAR | 8 | null |
|
|
加盟店グループID3 |
|||||
| csv_created_at | DATETIME | 19 | √ | null |
|
|
CSV作成日時 |
||||
| 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_linkages_kmc_id_index | Performance | Asc | kmc_id |
| nk_point_linkages_nk_point_of_sales_information_id_index | Performance | Asc | nk_point_of_sales_information_id |
| nk_point_linkages_nk_stay_information_id_index | Performance | Asc | nk_stay_information_id |
| nk_point_linkages_transaction_date_index | Performance | Asc | transaction_date |