MySQL Create Table SQL
Table Structure: okayapi_cmdb_django_admin_log:/tablelist/okayapi_cmdb_django_admin_log.html
-- MySQL Table okayapi_cmdb_django_admin_log
-- From: OkayAPI.com
CREATE TABLE `okayapi_cmdb_django_admin_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`action_time` datetime(6) NOT NULL COMMENT '',
`object_id` longtext NOT NULL COMMENT '',
`object_repr` varchar(200) NOT NULL COMMENT '',
`action_flag` smallint(5) NOT NULL COMMENT '',
`change_message` longtext NOT NULL COMMENT '',
`content_type_id` int(11) NOT NULL COMMENT '',
`user_id` int(11) NOT NULL COMMENT '',
KEY `action_time` (`action_time`),
KEY `object_id` (`object_id`),
KEY `object_repr` (`object_repr`),
KEY `action_flag` (`action_flag`),
KEY `change_message` (`change_message`),
KEY `content_type_id` (`content_type_id`),
KEY `user_id` (`user_id`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'CMDB管理-管理日志';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-7 of 7 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
action_time | datetime(6) | 否 | ||||
object_id | longtext | 是 | ||||
object_repr | varchar(200) | 否 | ||||
action_flag | smallint(5) | 否 | ||||
change_message | longtext | 否 | ||||
content_type_id | int(11) | 是 | ||||
user_id | int(11) | 否 |