+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_hc_group_buy:/tablelist/okayapi_hc_group_buy.html


-- MySQL Table okayapi_hc_group_buy
-- From: OkayAPI.com
CREATE TABLE `okayapi_hc_group_buy` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `buy_id` varchar(30) NOT NULL COMMENT '团购购买ID',
    `batch_id` varchar(30) NOT NULL COMMENT '批次ID',
    `store_id` varchar(30) NOT NULL COMMENT '商户ID,分片ID',
    `product_id` varchar(30) NOT NULL COMMENT '产品ID',
    `spec_id` varchar(30) NOT NULL COMMENT '产品规格ID',
    `group_id` varchar(30) NOT NULL COMMENT '团购ID',
    `persion_id` varchar(30) NOT NULL COMMENT '用户ID',
    `persion_name` varchar(256) NOT NULL COMMENT '用户名称',
    `buy_count` int(11) NOT NULL COMMENT '购买数量',
    `group_price` decimal(8,2) NOT NULL COMMENT '团购时单价',
    `amount` int(11) NOT NULL COMMENT '付款金额',
    `state` varchar(12) NOT NULL DEFAULT '1001' COMMENT '1001 拼团中,2002 拼团成功 3003 拼团失败',
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `status_cd` varchar(2) NOT NULL DEFAULT '0' COMMENT '数据状态',
    KEY `buy_id` (`buy_id`),
    KEY `batch_id` (`batch_id`),
    KEY `store_id` (`store_id`),
    KEY `product_id` (`product_id`),
    KEY `spec_id` (`spec_id`),
    KEY `group_id` (`group_id`),
    KEY `persion_id` (`persion_id`),
    KEY `persion_name` (`persion_name`),
    KEY `buy_count` (`buy_count`),
    KEY `group_price` (`group_price`),
    KEY `amount` (`amount`),
    KEY `state` (`state`),
    KEY `create_time` (`create_time`),
    KEY `status_cd` (`status_cd`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '小区物业管理系统-团购';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-14 of 14 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
buy_idvarchar(30)团购购买ID
batch_idvarchar(30)批次ID
store_idvarchar(30)商户ID,分片ID
product_idvarchar(30)产品ID
spec_idvarchar(30)产品规格ID
group_idvarchar(30)团购ID
persion_idvarchar(30)用户ID
persion_namevarchar(256)用户名称
buy_countint(11)购买数量
group_pricedecimal(8,2)团购时单价
amountint(11)付款金额
statevarchar(12)10011001 拼团中,2002 拼团成功 3003 拼团失败1001
create_timetimestampCURRENT_TIMESTAMP创建时间CURRENT_TIMESTAMP
status_cdvarchar(2)0数据状态0

Guess You Like

MySQL Table Design okayapi_mall_ums_member_receive_address

MySQL Table Design okayapi_mall_ums_member_rule_setting

MySQL Table Design okayapi_mall_ums_member_statistics_info

MySQL Table Design okayapi_mall_ums_role_permission_relation

MySQL Table Design okayapi_cloud_image_sync

MySQL Table Design okayapi_hc_act_re_model

TOP ↑