customers - 会 員
説明
- xxxの会員
表領域(schema)
public
定義
| Physical name | Logical name | Type | Digit | Not null | Default value | Comment |
|---|---|---|---|---|---|---|
| id | ID | serial | - | ⭕ | ||
| login_id | ログインID | varchar | 255 | ⭕ | ||
| customer_number | 顧客番号 | varchar | 100 | ⭕ | ||
| password_encrypted | パスワード | varchar | 255 | ⭕ | ||
| is_enabled | is有効 | boolean | - | ⭕ | true | true:有効 false:無効 |
| is_withdrawn | is退会 | boolean | - | ⭕ | false | true:退会済 false:未退会 |
| withdrawn_at | 退会日時 | timestamp | - | - | ||
| created_id | 作成者ID | integer | - | - | ||
| created_at | 作成日時 | timestamp | - | ⭕ | current_timestamp | |
| last_modified_id | 更新者ID | integer | - | ⭕ | ||
| last_modified_at | 更新日時 | timestamp | - | ⭕ | current_timestamp |