MySQL Create Table SQL
Table Structure: okayapi_srcms_order:/tablelist/okayapi_srcms_order.html
-- MySQL Table okayapi_srcms_order
-- From: OkayAPI.com
CREATE TABLE `okayapi_srcms_order` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`userid` varchar(255) NOT NULL COMMENT '用户ID',
`username` varchar(50) NOT NULL COMMENT '兑换用户',
`realname` varchar(50) NOT NULL COMMENT '真实姓名',
`zipcode` varchar(10) NOT NULL COMMENT '邮编',
`address` varchar(100) NOT NULL COMMENT '住址',
`tel` int(15) NOT NULL COMMENT '电话',
`alipay` varchar(50) NOT NULL COMMENT '支付宝',
`gid` varchar(100) NOT NULL COMMENT '礼品名称',
`price` varchar(255) NOT NULL DEFAULT '0' COMMENT '订单金额',
`num` int(10) NOT NULL DEFAULT '1' COMMENT '兑换数量',
`finish` int(2) NOT NULL COMMENT '1. 完成 2.未完成',
KEY `userid` (`userid`),
KEY `username` (`username`),
KEY `realname` (`realname`),
KEY `zipcode` (`zipcode`),
KEY `address` (`address`),
KEY `tel` (`tel`),
KEY `alipay` (`alipay`),
KEY `gid` (`gid`),
KEY `price` (`price`),
KEY `num` (`num`),
KEY `finish` (`finish`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'SRCMS-订单';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-11 of 11 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
userid | varchar(255) | 否 | 用户ID | |||
username | varchar(50) | 否 | 兑换用户 | |||
realname | varchar(50) | 否 | 真实姓名 | |||
zipcode | varchar(10) | 否 | 邮编 | |||
address | varchar(100) | 否 | 住址 | |||
tel | int(15) | 否 | 电话 | |||
alipay | varchar(50) | 否 | 支付宝 | |||
gid | varchar(100) | 否 | 礼品名称 | |||
price | varchar(255) | 0 | 否 | 订单金额 | 0 | |
num | int(10) | 1 | 否 | 兑换数量 | 1 | |
finish | int(2) | 否 | 1. 完成 2.未完成 |