my-home-dashboard
gas_fetch_settings
Description
ガス料金の取得設定
Table Definition
```sql CREATE TABLE `gas_fetch_settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', `setting_name` varchar(255) NOT NULL DEFAULT '取得設定' COMMENT '設定名', `gas_site_id` bigint(20) unsigned NOT NULL COMMENT 'ガス料金サイトID', `user_name` varchar(255) NOT NULL COMMENT 'ユーザー名', `encrypted_password` varchar(512) NOT NULL COMMENT '暗号化済パスワード', `fetch_enable` tinyint(1) NOT NULL DEFAULT 1 COMMENT '取得処理の有効化', `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_gas_fetch_settings_gas_site_id_user_name` (`gas_site_id`,`user_name`) ) 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 | gas_fetch_statuses gas_monthly_usages | ID | ||
| setting_name | varchar(255) | ‘取得設定’ | false | 設定名 | |||
| gas_site_id | bigint(20) unsigned | false | ガス料金サイトID | ||||
| user_name | varchar(255) | false | ユーザー名 | ||||
| encrypted_password | varchar(512) | false | 暗号化済パスワード | ||||
| fetch_enable | tinyint(1) | 1 | false | 取得処理の有効化 | |||
| created_at | datetime | current_timestamp() | false | 作成日時(UTC) | |||
| updated_at | datetime | current_timestamp() | false | on update current_timestamp() | 更新日時(UTC) |
Constraints
| Name | Type | Definition |
|---|---|---|
| id | UNIQUE | UNIQUE KEY id (id) |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (id) |
| uk_gas_fetch_settings_gas_site_id_user_name | UNIQUE | UNIQUE KEY uk_gas_fetch_settings_gas_site_id_user_name (gas_site_id, user_name) |
Indexes
| Name | Definition |
|---|---|
| PRIMARY | PRIMARY KEY (id) USING BTREE |
| id | UNIQUE KEY id (id) USING BTREE |
| uk_gas_fetch_settings_gas_site_id_user_name | UNIQUE KEY uk_gas_fetch_settings_gas_site_id_user_name (gas_site_id, user_name) USING BTREE |
Relations
Generated by tbls