ome_operation_log
操作员记录表
所属应用: ome
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| log_id | log_id | int(10) unsigned | N | Y | |
| obj_id | 操作对象主键 | varchar(50) | Y | N | |
| obj_name | 操作对象含义字段(dbschema中的is_title=true字段值) | varchar(200) | N | N | |
| obj_type | obj_type | varchar(50) | Y | N | |
| operation | 操作名 | varchar(50) | Y | N | |
| op_id | op_id | mediumint(8) unsigned | Y | N | |
| op_name | op_name | varchar(30) | N | N | |
| operate_time | operate_time | int(10) unsigned | Y | N | |
| memo | memo | text | N | N | |
| ip | ip | varchar(15) | N | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | log_id | Y | |
| ind_obj_id | obj_id | N | |
| ind_obj_type | obj_type | N | |
| ind_op_name | op_name | N | |
| ind_operate_time | operate_time | N | |
| idx_c_op_id | op_id | N |
