+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
versionint(11)0版本号0
editorvarchar(100)修改者
creatervarchar(100)创建者
edit_timedatetime最后修改时间
create_timedatetime创建时间
message_idvarchar(50)消息IDNormal Index
message_bodylongtext消息内容
message_data_typevarchar(50)消息数据类型
consumer_queuevarchar(100)消费队列
message_send_timessmallint(6)0消息重发次数0
areadly_deadvarchar(20)是否死亡
okayapi_xbinstore_tb_transaction_message_statusvarchar(20)状态
remarkvarchar(200)备注
field1varchar(200)扩展字段1
field2varchar(200)扩展字段2
field3varchar(200)扩展字段3

Guess You Like

MySQL Table Design okayapi_xbinstore_tb_category

MySQL Table Design okayapi_xbinstore_tb_category_image

MySQL Table Design okayapi_xbinstore_tb_category_secondary

MySQL Table Design okayapi_xbinstore_tb_hot_words

MySQL Table Design okayapi_xbinstore_tb_index_slide_ad

MySQL Table Design okayapi_xbinstore_tb_item

MySQL Table Design okayapi_xbinstore_tb_item_desc

MySQL Table Design okayapi_xbinstore_tb_item_param

MySQL Table Design okayapi_xbinstore_tb_item_param_item

MySQL Table Design okayapi_xbinstore_tb_manage_user

MySQL Table Design okayapi_xbinstore_tb_order

MySQL Table Design okayapi_xbinstore_tb_order_item

MySQL Table Design okayapi_xbinstore_tb_user

MySQL Table Design okayapi_xbinstore_tb_user_addr

TOP ↑