Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT UNSIGNED | 20 | √ | null |
|
|
||||
| inquiry_definition_id | BIGINT UNSIGNED | 20 | null |
|
|
反響取込定義ID |
||||
| preg_pattern | VARCHAR | 255 | null |
|
|
正規表現パターン |
||||
| replace | VARCHAR | 255 | null |
|
|
取込み値 |
||||
| field | enum('customer__name', 'customer__name_kana', 'customer__email', 'customer__tel', 'customer__fax', 'customer__gender', 'customer__zip', 'customer__address', 'inquiry__items', 'inquiry__text', 'inquiry__preferred_contact_time', 'inquiry__preferred_rent_fee', 'inquiry__preferred_floor_plan', 'inquiry__move_in_date', 'inquiry__inquired_at', 'inquiry__memo', 'rental__rental_id', 'rental__media_rental_id', 'rental__name', 'rental__rental_type', 'rental__railway', 'rental__station', 'rental__address', 'rental__fee', 'rental__floor_plan', 'rental__occupied_area', 'rental__url') | 31 | null |
|
|
取込項目 |
||||
| convert_type | enum('none', 'multiplied_10', 'multiplied_100', 'multiplied_1000', 'multiplied_10000', 'divided_10', 'divided_100', 'divided_1000', 'divided_10000', 'line_split') | 16 | none |
|
|
変換種別 |
||||
| empty_string | VARCHAR | 255 | null |
|
|
空判定文字列 |
||||
| created_at | TIMESTAMP | 26 | √ | null |
|
|
||||
| updated_at | TIMESTAMP | 26 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| inquiry_definition_items_inquiry_definition_id_foreign | Performance | Asc | inquiry_definition_id |
Relationships
Close relationships within degrees of separation
