+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
useridvarchar(255)用户ID
usernamevarchar(50)兑换用户
realnamevarchar(50)真实姓名
zipcodevarchar(10)邮编
addressvarchar(100)住址
telint(15)电话
alipayvarchar(50)支付宝
gidvarchar(100)礼品名称
pricevarchar(255)0订单金额0
numint(10)1兑换数量1
finishint(2)1. 完成 2.未完成

Guess You Like

MySQL Table Design okayapi_srcms_blog

MySQL Table Design okayapi_srcms_category

MySQL Table Design okayapi_srcms_comment

MySQL Table Design okayapi_srcms_hall

MySQL Table Design okayapi_srcms_info

MySQL Table Design okayapi_srcms_links

MySQL Table Design okayapi_srcms_manager

MySQL Table Design okayapi_srcms_member

MySQL Table Design okayapi_srcms_notes

MySQL Table Design okayapi_srcms_page

MySQL Table Design okayapi_srcms_post

MySQL Table Design okayapi_srcms_record

MySQL Table Design okayapi_srcms_setting

TOP ↑