MySQL Create Table SQL
Table Structure: okayapi_xbinstore_tb_transaction_message:/tablelist/okayapi_xbinstore_tb_transaction_message.html
-- MySQL Table okayapi_xbinstore_tb_transaction_message
-- From: OkayAPI.com
CREATE TABLE `okayapi_xbinstore_tb_transaction_message` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`version` int(11) NULL DEFAULT '0' COMMENT '版本号',
`editor` varchar(100) NULL COMMENT '修改者',
`creater` varchar(100) NULL COMMENT '创建者',
`edit_time` datetime NULL COMMENT '最后修改时间',
`create_time` datetime NULL COMMENT '创建时间',
`message_id` varchar(50) NULL COMMENT '消息ID',
`message_body` longtext NULL COMMENT '消息内容',
`message_data_type` varchar(50) NULL COMMENT '消息数据类型',
`consumer_queue` varchar(100) NULL COMMENT '消费队列',
`message_send_times` smallint(6) NULL DEFAULT '0' COMMENT '消息重发次数',
`areadly_dead` varchar(20) NULL COMMENT '是否死亡',
`okayapi_xbinstore_tb_transaction_message_status` varchar(20) NULL COMMENT '状态',
`remark` varchar(200) NULL COMMENT '备注',
`field1` varchar(200) NULL COMMENT '扩展字段1',
`field2` varchar(200) NULL COMMENT '扩展字段2',
`field3` varchar(200) NULL COMMENT '扩展字段3',
KEY `version` (`version`),
KEY `editor` (`editor`),
KEY `creater` (`creater`),
KEY `edit_time` (`edit_time`),
KEY `create_time` (`create_time`),
KEY `message_id` (`message_id`),
KEY `message_body` (`message_body`),
KEY `message_data_type` (`message_data_type`),
KEY `consumer_queue` (`consumer_queue`),
KEY `message_send_times` (`message_send_times`),
KEY `areadly_dead` (`areadly_dead`),
KEY `okayapi_xbinstore_tb_transaction_message_status` (`okayapi_xbinstore_tb_transaction_message_status`),
KEY `remark` (`remark`),
KEY `field1` (`field1`),
KEY `field2` (`field2`),
KEY `field3` (`field3`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'B2C商城-消息';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-16 of 16 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
version | int(11) | 0 | 否 | 版本号 | 0 | |
editor | varchar(100) | 是 | 修改者 | |||
creater | varchar(100) | 是 | 创建者 | |||
edit_time | datetime | 是 | 最后修改时间 | |||
create_time | datetime | 否 | 创建时间 | |||
message_id | varchar(50) | 否 | 消息ID | Normal Index | ||
message_body | longtext | 否 | 消息内容 | |||
message_data_type | varchar(50) | 是 | 消息数据类型 | |||
consumer_queue | varchar(100) | 否 | 消费队列 | |||
message_send_times | smallint(6) | 0 | 否 | 消息重发次数 | 0 | |
areadly_dead | varchar(20) | 否 | 是否死亡 | |||
okayapi_xbinstore_tb_transaction_message_status | varchar(20) | 否 | 状态 | |||
remark | varchar(200) | 是 | 备注 | |||
field1 | varchar(200) | 是 | 扩展字段1 | |||
field2 | varchar(200) | 是 | 扩展字段2 | |||
field3 | varchar(200) | 是 | 扩展字段3 |