cost-gateway
cost_types
Description
コスト種別
Table Definition
```sql CREATE TABLE `cost_types` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'コスト種別ID', `type_name` varchar(255) NOT NULL 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_cost_types_type_name` (`type_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci COMMENT='コスト種別' ```Columns
| Name | Type | Default | Nullable | Extra Definition | Children | Parents | Comment |
|---|---|---|---|---|---|---|---|
| id | bigint(20) unsigned | false | auto_increment | monthly_costs | コスト種別ID | ||
| type_name | varchar(255) | 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_cost_types_type_name | UNIQUE | UNIQUE KEY uk_cost_types_type_name (type_name) |
Indexes
| Name | Definition |
|---|---|
| PRIMARY | PRIMARY KEY (id) USING BTREE |
| id | UNIQUE KEY id (id) USING BTREE |
| uk_cost_types_type_name | UNIQUE KEY uk_cost_types_type_name (type_name) USING BTREE |
Relations
Generated by tbls