アドバイザー
Name | Type | Default | Nullable | Extra Definition | Children | Parents | Comment |
---|---|---|---|---|---|---|---|
id | bigint(20) unsigned | false | auto_increment | electricity_notify_settings | アドバイザーID | ||
advisor_type_id | tinyint(3) unsigned | false | advisor_types | アドバイザー種別ID | |||
encrypted_apikey | varchar(512) | false | 暗号化済APIキー | ||||
memo | text | NULL | true | メモ | |||
created_at | datetime | current_timestamp() | false | 作成日時(UTC) | |||
updated_at | datetime | current_timestamp() | false | on update current_timestamp() | 更新日時(UTC) |
Name | Type | Definition |
---|---|---|
fk_advisors_advisor_type_id | FOREIGN KEY | FOREIGN KEY (advisor_type_id) REFERENCES advisor_types (id) |
id | UNIQUE | UNIQUE KEY id (id) |
PRIMARY | PRIMARY KEY | PRIMARY KEY (id) |
Name | Definition |
---|---|
fk_advisors_advisor_type_id | KEY fk_advisors_advisor_type_id (advisor_type_id) USING BTREE |
PRIMARY | PRIMARY KEY (id) USING BTREE |
id | UNIQUE KEY id (id) USING BTREE |
Generated by tbls