java110-db/db/CommunityService/create_room.sql · javaalpha/MicroCommunity

Fetch the repository succeeded.

Scan WeChat QR to Pay

Cancel

Complete

richgiteeai

Watch

Unwatch Watching Releases Only Ignoring

1 Star 0 Fork 4.3K

javaalpha/MicroCommunity

forked from java110/MicroCommunity

Code Issues 0 Pull Requests 0 Wiki Insights Pipelines

Service

Tencent Cloud Serverless

Create your Gitee Account

Explore and code with more than 14 million developers,Free private repositories !:)

Already have an account? Sign in

文件

master

Branches (15)

Tags (8)

Manage

master

shiyj01

duckweed

jonas

spring-cloud-1.4

shareDb

shiyj

dyaoming

wuxw

product

v0.3

v20190322

test

v0.2

add-license-1

v0.0.8

v0.0.7

v0.0.6

v0.0.5

v0.0.4

v0.0.3

v0.0.2

v0.0.1

Clone or Download

Clone/Download

HTTPS SSH SVN SVN+SSH Download ZIP

Prompt

To download the code, please copy the following command and execute it in the terminal

To ensure that your submitted code identity is correctly recognized by Gitee, please execute the following command.

git config --global user.name userName 
git config --global user.email userEmail

When using the SSH protocol for the first time to clone or push code, follow the prompts below to complete the SSH configuration.

1 Generate RSA keys.

2 Obtain the content of the RSA public key and configure it in SSH Public Keys

To use SVN on Gitee, please visit the usage guide

When using the HTTPS protocol, the command line will prompt for account and password verification as follows. For security reasons, Gitee recommends configure and use personal access tokens instead of login passwords for cloning, pushing, and other operations.

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # Private Token

Branches 15

Tags 8

MicroCommunity

java110-db

CommunityService

create_room.sql

create_room.sql 6.00 KB

-- 楼信息
CREATE TABLE business_floor(
 floor_id VARCHAR(30) NOT NULL COMMENT '楼ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 floor_num VARCHAR(12) NOT NULL COMMENT '楼编号',
 `name` VARCHAR(100) NOT NULL COMMENT '小区楼名称',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(300) NOT NULL COMMENT '用户ID',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 operate VARCHAR(4) NOT NULL COMMENT '数据状态,添加ADD,修改MOD 删除DEL'
);

CREATE INDEX idx_business_floor_id ON business_floor(floor_id);
CREATE INDEX idx_business_floor_b_id ON business_floor(b_id);

CREATE TABLE f_floor(
 floor_id VARCHAR(30) NOT NULL COMMENT '楼ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 floor_num VARCHAR(12) NOT NULL COMMENT '楼编号',
 `name` VARCHAR(100) NOT NULL COMMENT '小区楼名称',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(300) NOT NULL COMMENT '用户ID',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,S 保存,0, 在用 1失效',
 UNIQUE KEY (floor_id)
);
CREATE INDEX idx_floor_b_id ON f_floor(b_id);
CREATE UNIQUE INDEX idx_floor_id ON f_floor(floor_id);

-- 单元信息 building 楼宇管理
CREATE TABLE business_building_unit(
 unit_id VARCHAR(30) NOT NULL COMMENT '单元ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 unit_num VARCHAR(12) NOT NULL COMMENT '单元编号',
 floor_id VARCHAR(30) NOT NULL COMMENT '楼ID',
 layer_count int NOT NULL COMMENT '总层数',
 lift varchar(4) NOT NULL COMMENT '是否有电梯 1010有 2020 无',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(200) NOT NULL COMMENT '备注',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 operate VARCHAR(4) NOT NULL COMMENT '数据状态,添加ADD,修改MOD 删除DEL'
);

CREATE INDEX idx_business_unit_id ON business_building_unit(unit_id);
CREATE INDEX idx_business_unit_b_id ON business_building_unit(b_id);

CREATE TABLE building_unit(
 unit_id VARCHAR(30) NOT NULL COMMENT '单元ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 unit_num VARCHAR(12) NOT NULL COMMENT '单元编号',
 floor_id VARCHAR(30) NOT NULL COMMENT '楼ID',
 layer_count int NOT NULL COMMENT '总层数',
 lift varchar(4) NOT NULL COMMENT '是否有电梯 1010有 2020 无',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(200) NOT NULL COMMENT '备注',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,S 保存,0, 在用 1失效',
 UNIQUE KEY (unit_id)
);
CREATE INDEX idx_unit_b_id ON building_unit(b_id);
CREATE UNIQUE INDEX idx_unit_id ON building_unit(unit_id);

-- 单元信息 building 楼宇管理
CREATE TABLE business_building_room(
 room_id VARCHAR(30) NOT NULL COMMENT '房屋ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 room_num VARCHAR(12) NOT NULL COMMENT '房屋编号',
 unit_id VARCHAR(30) NOT NULL COMMENT '单元ID',
 layer int NOT NULL COMMENT '层数',
 section int NOT NULL COMMENT '室',
 apartment varchar(4) NOT NULL COMMENT '户型',
 built_up_area decimal(6,2) NOT NULL COMMENT '建筑面积',
 unit_price DECIMAL(12,2) NOT NULL COMMENT '每平米单价',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(200) NOT NULL COMMENT '备注',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 operate VARCHAR(4) NOT NULL COMMENT '数据状态,添加ADD,修改MOD 删除DEL'
);

CREATE INDEX idx_business_room_id ON business_building_room(room_id);
CREATE INDEX idx_business_room_b_id ON business_building_room(b_id);

CREATE TABLE building_room(
 room_id VARCHAR(30) NOT NULL COMMENT '房屋ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 room_num VARCHAR(12) NOT NULL COMMENT '房屋编号',
 unit_id VARCHAR(30) NOT NULL COMMENT '单元ID',
 layer int NOT NULL COMMENT '层数',
 section int NOT NULL COMMENT '室',
 apartment varchar(4) NOT NULL COMMENT '户型',
 built_up_area decimal(6,2) NOT NULL COMMENT '建筑面积',
 unit_price DECIMAL(12,2) NOT NULL COMMENT '每平米单价',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(200) NOT NULL COMMENT '备注',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,S 保存,0, 在用 1失效',
 UNIQUE KEY (room_id)
);
CREATE INDEX idx_room_b_id ON building_room(b_id);
CREATE UNIQUE INDEX idx_room_id ON building_room(room_id);

create table business_building_room_attr(
 b_id VARCHAR(30) NOT NULL COMMENT '订单ID',
 attr_id VARCHAR(30) NOT NULL COMMENT '属性id',
 room_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 spec_cd VARCHAR(12) NOT NULL COMMENT '规格id,参考spec表',
 `value` VARCHAR(50) NOT NULL COMMENT '属性值',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 operate VARCHAR(3) NOT NULL COMMENT '数据状态,添加ADD,修改MOD 删除DEL'
);

CREATE INDEX idx_business_b_room_attr ON business_building_room_attr(room_id);
CREATE INDEX idx_business_b_room_attr_b_id ON business_building_room_attr(b_id);

CREATE TABLE building_room_attr(
 b_id VARCHAR(30) NOT NULL COMMENT '订单ID',
 attr_id VARCHAR(30) NOT NULL COMMENT '属性id',
 room_id VARCHAR(30) NOT NULL COMMENT '房屋ID',
 spec_cd VARCHAR(12) NOT NULL COMMENT '规格id,参考spec表',
 `value` VARCHAR(50) NOT NULL COMMENT '属性值',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,S 保存,0, 在用 1失效',
 UNIQUE KEY (attr_id)
);
CREATE INDEX idx_b_attr_b_id ON building_room_attr(b_id);
CREATE INDEX idx_attr_room_id ON building_room_attr(room_id);

Copy Edit Raw Blame History

java110 authored 2019年05月13日 18:01 +08:00 . 加入分片功能呢

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136

-- 楼信息
CREATE TABLE business_floor(
 floor_id VARCHAR(30) NOT NULL COMMENT '楼ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 floor_num VARCHAR(12) NOT NULL COMMENT '楼编号',
 `name` VARCHAR(100) NOT NULL COMMENT '小区楼名称',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(300) NOT NULL COMMENT '用户ID',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 operate VARCHAR(4) NOT NULL COMMENT '数据状态,添加ADD,修改MOD 删除DEL'
);


CREATE INDEX idx_business_floor_id ON business_floor(floor_id);
CREATE INDEX idx_business_floor_b_id ON business_floor(b_id);


CREATE TABLE f_floor(
 floor_id VARCHAR(30) NOT NULL COMMENT '楼ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 floor_num VARCHAR(12) NOT NULL COMMENT '楼编号',
 `name` VARCHAR(100) NOT NULL COMMENT '小区楼名称',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(300) NOT NULL COMMENT '用户ID',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,S 保存,0, 在用 1失效',
 UNIQUE KEY (floor_id)
);
CREATE INDEX idx_floor_b_id ON f_floor(b_id);
CREATE UNIQUE INDEX idx_floor_id ON f_floor(floor_id);


-- 单元信息 building 楼宇管理
CREATE TABLE business_building_unit(
 unit_id VARCHAR(30) NOT NULL COMMENT '单元ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 unit_num VARCHAR(12) NOT NULL COMMENT '单元编号',
 floor_id VARCHAR(30) NOT NULL COMMENT '楼ID',
 layer_count int NOT NULL COMMENT '总层数',
 lift varchar(4) NOT NULL COMMENT '是否有电梯 1010有 2020 无',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(200) NOT NULL COMMENT '备注',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 operate VARCHAR(4) NOT NULL COMMENT '数据状态,添加ADD,修改MOD 删除DEL'
);


CREATE INDEX idx_business_unit_id ON business_building_unit(unit_id);
CREATE INDEX idx_business_unit_b_id ON business_building_unit(b_id);


CREATE TABLE building_unit(
 unit_id VARCHAR(30) NOT NULL COMMENT '单元ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 unit_num VARCHAR(12) NOT NULL COMMENT '单元编号',
 floor_id VARCHAR(30) NOT NULL COMMENT '楼ID',
 layer_count int NOT NULL COMMENT '总层数',
 lift varchar(4) NOT NULL COMMENT '是否有电梯 1010有 2020 无',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(200) NOT NULL COMMENT '备注',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,S 保存,0, 在用 1失效',
 UNIQUE KEY (unit_id)
);
CREATE INDEX idx_unit_b_id ON building_unit(b_id);
CREATE UNIQUE INDEX idx_unit_id ON building_unit(unit_id);



-- 单元信息 building 楼宇管理
CREATE TABLE business_building_room(
 room_id VARCHAR(30) NOT NULL COMMENT '房屋ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 room_num VARCHAR(12) NOT NULL COMMENT '房屋编号',
 unit_id VARCHAR(30) NOT NULL COMMENT '单元ID',
 layer int NOT NULL COMMENT '层数',
 section int NOT NULL COMMENT '室',
 apartment varchar(4) NOT NULL COMMENT '户型',
 built_up_area decimal(6,2) NOT NULL COMMENT '建筑面积',
 unit_price DECIMAL(12,2) NOT NULL COMMENT '每平米单价',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(200) NOT NULL COMMENT '备注',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 operate VARCHAR(4) NOT NULL COMMENT '数据状态,添加ADD,修改MOD 删除DEL'
);


CREATE INDEX idx_business_room_id ON business_building_room(room_id);
CREATE INDEX idx_business_room_b_id ON business_building_room(b_id);


CREATE TABLE building_room(
 room_id VARCHAR(30) NOT NULL COMMENT '房屋ID',
 b_id VARCHAR(30) NOT NULL COMMENT '业务Id',
 room_num VARCHAR(12) NOT NULL COMMENT '房屋编号',
 unit_id VARCHAR(30) NOT NULL COMMENT '单元ID',
 layer int NOT NULL COMMENT '层数',
 section int NOT NULL COMMENT '室',
 apartment varchar(4) NOT NULL COMMENT '户型',
 built_up_area decimal(6,2) NOT NULL COMMENT '建筑面积',
 unit_price DECIMAL(12,2) NOT NULL COMMENT '每平米单价',
 user_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 remark VARCHAR(200) NOT NULL COMMENT '备注',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,S 保存,0, 在用 1失效',
 UNIQUE KEY (room_id)
);
CREATE INDEX idx_room_b_id ON building_room(b_id);
CREATE UNIQUE INDEX idx_room_id ON building_room(room_id);

create table business_building_room_attr(
 b_id VARCHAR(30) NOT NULL COMMENT '订单ID',
 attr_id VARCHAR(30) NOT NULL COMMENT '属性id',
 room_id VARCHAR(30) NOT NULL COMMENT '用户ID',
 spec_cd VARCHAR(12) NOT NULL COMMENT '规格id,参考spec表',
 `value` VARCHAR(50) NOT NULL COMMENT '属性值',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 operate VARCHAR(3) NOT NULL COMMENT '数据状态,添加ADD,修改MOD 删除DEL'
);

CREATE INDEX idx_business_b_room_attr ON business_building_room_attr(room_id);
CREATE INDEX idx_business_b_room_attr_b_id ON business_building_room_attr(b_id);


CREATE TABLE building_room_attr(
 b_id VARCHAR(30) NOT NULL COMMENT '订单ID',
 attr_id VARCHAR(30) NOT NULL COMMENT '属性id',
 room_id VARCHAR(30) NOT NULL COMMENT '房屋ID',
 spec_cd VARCHAR(12) NOT NULL COMMENT '规格id,参考spec表',
 `value` VARCHAR(50) NOT NULL COMMENT '属性值',
 create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '数据状态,详细参考c_status表,S 保存,0, 在用 1失效',
 UNIQUE KEY (attr_id)
);
CREATE INDEX idx_b_attr_b_id ON building_room_attr(b_id);
CREATE INDEX idx_attr_room_id ON building_room_attr(room_id);