| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- -- ----------------------------
- -- Table structure for jm_buy
- -- ----------------------------
- drop table if exists jm_buy;
- create table jm_buy (
- buy_id bigint(20) NOT NULL DEFAULT 0 COMMENT '购买流水id',
- jm_id bigint(20) NOT NULL DEFAULT 0 COMMENT '团购参团id',
- user_id bigint(20) NOT NULL DEFAULT 0 COMMENT '居民id',
- buy_count int(11) NOT NULL DEFAULT 0 COMMENT '购买数量',
- buy_money varchar(20) NOT NULL DEFAULT 0 COMMENT '购买金额',
- phone varchar(20) NOT NULL DEFAULT '' COMMENT '联系电话',
- buy_status int(11) NOT NULL DEFAULT 1 COMMENT '状态 1 在团 2 撤单',
- my_remark varchar(200) NOT NULL DEFAULT '' COMMENT '备注',
- user_create bigint(20) NOT NULL DEFAULT 0 COMMENT '新增人',
- time_create datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '新增时间(订单提交时间)',
- PRIMARY KEY (buy_id) USING BTREE,
- INDEX user_id(user_id) USING BTREE
- )
- ENGINE = InnoDB
- DEFAULT CHARSET = utf8mb4
- COMMENT = '居民团购表'
- ;
- drop table if exists jm_tuangou;
- create table jm_tuangou (
- jm_id bigint(20) NOT NULL DEFAULT 0 COMMENT '团购id',
- user_id bigint(20) NOT NULL DEFAULT 0 COMMENT '用户id',
- uptown_id bigint(20) NOT NULL DEFAULT 0 COMMENT '小区ID',
- tg_title varchar(50) NOT NULL DEFAULT '' COMMENT '团购标题',
- tg_supplier varchar(50) NOT NULL DEFAULT '' COMMENT '团购供应商',
- tg_goods varchar(500) NOT NULL DEFAULT '' COMMENT '团购物资（套餐）',
- tg_price varchar(20) NOT NULL DEFAULT '' COMMENT '价格',
- tg_min_num int(11) NOT NULL DEFAULT 0 COMMENT '最低起送',
- tg_end_time datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '团购截止时间',
- tg_deliver_time datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '预计送货时间',
- tg_phone_number varchar(20) NOT NULL DEFAULT '' COMMENT '联系人电话',
- remark varchar(500) NOT NULL DEFAULT '' COMMENT '增补修订',
- tg_status int(11) NOT NULL DEFAULT 0 COMMENT '团购状态：1在团，2发货，3完成，4取消',
- PRIMARY KEY (jm_id) USING BTREE,
- INDEX user_id(user_id) USING BTREE,
- INDEX uptown_id(uptown_id) USING BTREE
- )
- ENGINE = InnoDB
- DEFAULT CHARSET = utf8mb4
- COMMENT = '团购表'
- ;
- ALTER TABLE jm_tuangou
- ADD tg_max_num int(11) NOT NULL DEFAULT 0 COMMENT '最大订量' AFTER tg_min_num;
- ALTER TABLE jm_tuangou
- ADD tg_type int(11) NOT NULL DEFAULT 0 COMMENT '团购类型' AFTER tg_title,
- ADD user_create bigint(20) NOT NULL DEFAULT 0 COMMENT '新增人',
- ADD time_create datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '新增时间',
- ADD user_update bigint(20) NOT NULL DEFAULT 0 COMMENT '修改人',
- ADD time_update datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间';
- ADD role_type int(11) NOT NULL DEFAULT 0 COMMENT '角色类型 0 业委会角色 1 指挥部' AFTER tg_min_num;
- ALTER TABLE jm_tuangou
- ADD tg_item_num int(11) NOT NULL DEFAULT 0 COMMENT '个人限额' after tg_max_num;
|
