desktop_interfacefield_mapper
接口字段映射表
所属应用: desktop
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | 自增主键 | int(10) unsigned | Y | Y | |
| channel_id | 渠道ID | varchar(32) | Y | N | |
| channel_type | 渠道类型 | varchar(32) | Y | N | |
| scene | 场景 | varchar(32) | N | N | |
| content | 字段内容 | longtext | N | N | |
| at_time | 创建时间 | TIMESTAMP | N | CURRENT_TIMESTAMP | N |
| up_time | 更新时间 | TIMESTAMP | N | CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | id | Y | |
| idx_channel | channel_id, channel_type | N | |
| idx_scene | scene | N | |
| ind_at_time | at_time | N | |
| ind_up_time | up_time | N |
