my-home-dashboard
water_monthly_usages
Description
月間水道使用状況
Table Definition
```sql CREATE TABLE `water_monthly_usages` ( `water_fetch_setting_id` bigint(20) unsigned NOT NULL COMMENT '水道料金取得設定ID', `usage_year` int(10) unsigned NOT NULL COMMENT '年', `usage_month` int(10) unsigned NOT NULL COMMENT '月', `usage_begin_at` date NOT NULL COMMENT '開始日', `usage_end_at` date NOT NULL COMMENT '終了日', `usage_amount` decimal(15,5) unsigned NOT NULL COMMENT '使用量(m^3)', `usage_yen` int(10) unsigned NOT NULL COMMENT '料金(円)', `created_at` datetime NOT NULL DEFAULT current_timestamp() COMMENT '作成日時', `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT '更新日時', PRIMARY KEY (`water_fetch_setting_id`,`usage_year`,`usage_month`), CONSTRAINT `fk_water_monthly_usages_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 |
|---|---|---|---|---|---|---|---|
| water_fetch_setting_id | bigint(20) unsigned | false | water_fetch_settings | 水道料金取得設定ID | |||
| usage_year | int(10) unsigned | false | 年 | ||||
| usage_month | int(10) unsigned | false | 月 | ||||
| usage_begin_at | date | false | 開始日 | ||||
| usage_end_at | date | false | 終了日 | ||||
| usage_amount | decimal(15,5) unsigned | false | 使用量(m^3) | ||||
| usage_yen | int(10) unsigned | false | 料金(円) | ||||
| created_at | datetime | current_timestamp() | false | 作成日時 | |||
| updated_at | datetime | current_timestamp() | false | on update current_timestamp() | 更新日時 |
Constraints
| Name | Type | Definition |
|---|---|---|
| fk_water_monthly_usages_water_fetch_setting_id | FOREIGN KEY | FOREIGN KEY (water_fetch_setting_id) REFERENCES water_fetch_settings (id) |
| PRIMARY | PRIMARY KEY | PRIMARY KEY (water_fetch_setting_id, usage_year, usage_month) |
Indexes
| Name | Definition |
|---|---|
| PRIMARY | PRIMARY KEY (water_fetch_setting_id, usage_year, usage_month) USING BTREE |
Relations
Generated by tbls