my-home-dashboard
water_fetch_statuses
Description
水道料金取得ステータス
Table Definition
```sql CREATE TABLE `water_fetch_statuses` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '水道料金取得ステータスID', `water_fetch_setting_id` bigint(20) unsigned NOT NULL COMMENT '取得設定ID', `status_type_id` tinyint(3) unsigned NOT NULL COMMENT 'ステータス種別ID', `last_successful_at` datetime DEFAULT NULL COMMENT '最終成功日時(UTC)', `last_failure_at` datetime DEFAULT NULL COMMENT '最終失敗日時(UTC)', `created_at` datetime NOT NULL DEFAULT current_timestamp() COMMENT '作成日時(UTC)', `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT '更新日時(UTC)', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `uk_water_fetch_statuses_water_fetch_setting_id` (`water_fetch_setting_id`), KEY `fk_water_fetch_statuses_status_type_id` (`status_type_id`), CONSTRAINT `fk_water_fetch_statuses_status_type_id` FOREIGN KEY (`status_type_id`) REFERENCES `fetch_status_types` (`id`), CONSTRAINT `fk_water_fetch_statuses_water_fetch_setting_id` FOREIGN KEY (`water_fetch_setting_id`) REFERENCES `water_fetch_settings` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='水道料金取得ステータス' ```Columns
| Name | Type | Default | Nullable | Extra Definition | Children | Parents | Comment |
|---|---|---|---|---|---|---|---|
| id | bigint(20) unsigned | false | auto_increment | 水道料金取得ステータスID | |||
| water_fetch_setting_id | bigint(20) unsigned | false | water_fetch_settings | 取得設定ID | |||
| status_type_id | tinyint(3) unsigned | false | fetch_status_types | ステータス種別ID | |||
| last_successful_at | datetime | NULL | true | 最終成功日時(UTC) | |||
| last_failure_at | datetime | NULL | true | 最終失敗日時(UTC) | |||
| created_at | datetime | current_timestamp() | false | 作成日時(UTC) | |||
| updated_at | datetime | current_timestamp() | false | on update current_timestamp() | 更新日時(UTC) |
Constraints
| Name | Type | Definition |
|---|---|---|
| fk_water_fetch_statuses_status_type_id | FOREIGN KEY | FOREIGN KEY (status_type_id) REFERENCES fetch_status_types (id) |
| fk_water_fetch_statuses_water_fetch_setting_id | FOREIGN KEY | FOREIGN KEY (water_fetch_setting_id) REFERENCES water_fetch_settings (id) |
| id | UNIQUE | UNIQUE KEY id (id) |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (id) |
| uk_water_fetch_statuses_water_fetch_setting_id | UNIQUE | UNIQUE KEY uk_water_fetch_statuses_water_fetch_setting_id (water_fetch_setting_id) |
Indexes
| Name | Definition |
|---|---|
| fk_water_fetch_statuses_status_type_id | KEY fk_water_fetch_statuses_status_type_id (status_type_id) USING BTREE |
| PRIMARY | PRIMARY KEY (id) USING BTREE |
| id | UNIQUE KEY id (id) USING BTREE |
| uk_water_fetch_statuses_water_fetch_setting_id | UNIQUE KEY uk_water_fetch_statuses_water_fetch_setting_id (water_fetch_setting_id) USING BTREE |
Relations
Generated by tbls