房产管理系统数据库表结构及示例数据
房产管理系统数据库表结构及示例数据
表结构
以下列出了房产管理系统中涉及的 14 张数据库表及其字段说明：
order_operate_history订单操作表
CREATE TABLE `order_operate_history` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`order_id` bigint(20) DEFAULT NULL COMMENT '订单id',
`operate_man` bigint(20) DEFAULT NULL COMMENT '经纪人id',
`status` int(3) NOT NULL DEFAULT '1' COMMENT '订单状态（1：未完成，2：已完成）',
`operate_time` datetime DEFAULT NULL COMMENT '操作时间',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单操作表';
sys_bridal_chamber新房表
CREATE TABLE `sys_bridal_chamber` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '新房id',
`comunity_id` bigint(20) DEFAULT NULL COMMENT '小区id',
`name` varchar(20) DEFAULT NULL COMMENT '房名',
`broker_id` bigint(20) DEFAULT NULL COMMENT '经纪人id',
`area_id` bigint(20) DEFAULT NULL COMMENT '面积id',
`status` int(3) NOT NULL DEFAULT '1' COMMENT '状态（0：在售，1：未开盘，2：售罄）',
`address` varchar(200) DEFAULT NULL COMMENT '地址',
`type_id` bigint(20) DEFAULT NULL COMMENT '户型id',
`property_id` bigint(20) DEFAULT NULL COMMENT '物业类型id',
`unit_price` float(10,0) DEFAULT NULL COMMENT '单价',
`total_price` float(10,0) DEFAULT NULL COMMENT '总价',
`fitment_id` bigint(20) DEFAULT NULL COMMENT '装修id',
`characteristic_id` bigint(20) DEFAULT NULL COMMENT '特色id',
`longitude` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '经度',
`latitude` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '纬度',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用，1：已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='新房表';
sys_broker经纪人表
CREATE TABLE `sys_broker` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '经纪人id',
`username` varchar(100) NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(100) NOT NULL DEFAULT '' COMMENT '密码',
`imageurl` varchar(100) DEFAULT NULL COMMENT '头像地址',
`postcard` varchar(200) DEFAULT NULL COMMENT '名片',
`phone` varchar(11) DEFAULT NULL COMMENT '手机号',
`bridal_chamber_id` bigint(20) DEFAULT NULL COMMENT '新房id',
`secondary_id` bigint(20) DEFAULT NULL COMMENT '二手房id',
`community_id` bigint(20) DEFAULT NULL COMMENT '小区id',
`status` int(3) DEFAULT '1' COMMENT '状态(1：正常，0：禁用)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_tiem` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='经纪人表';
sys_community小区表
CREATE TABLE `sys_community` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '小区id',
`name` varchar(200) NOT NULL DEFAULT '' COMMENT '小区名',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`province_id` bigint(20) DEFAULT NULL COMMENT '省id：（字典id） 预留字段',
`city_id` bigint(20) DEFAULT NULL COMMENT '城市id：（字典id）预留字段',
`area_id` bigint(20) DEFAULT NULL COMMENT '区域id：（字典id）',
`address` varchar(200) DEFAULT NULL COMMENT '详细地址',
`build_num` int(11) NOT NULL DEFAULT '0' COMMENT '套数',
`longitude` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '经度',
`latitute` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '纬度',
`average_price` decimal(10,2) DEFAULT '0.00' COMMENT '均价',
`hire` int(3) DEFAULT NULL COMMENT '出租(1是否可租，0：不可租)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='小区表';
sys_dict字典表
CREATE TABLE `sys_dict` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属上级',
`name` varchar(20) NOT NULL DEFAULT '' COMMENT '名称',
`conditions` varchar(100) NOT NULL DEFAULT '' COMMENT '类型(放户型之类的)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记(0：可用，1：已删除)',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='组织架构表';
sys_house_image房源图片表
CREATE TABLE `sys_house_image` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`bridal_chamber_id` bigint(20) DEFAULT NULL COMMENT '新房id',
`secondary_id` bigint(20) DEFAULT NULL COMMENT '二手房id',
`community_id` bigint(20) DEFAULT NULL COMMENT '小区id',
`image_name` varchar(100) NOT NULL DEFAULT '' COMMENT '图片名称',
`image_url` varchar(200) DEFAULT NULL COMMENT '图片地址',
`tyep` tinyint(3) DEFAULT NULL COMMENT '类型(1:房产图片,2：3D图)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房源图片';
sys_login_log系统访问记录表
CREATE TABLE `sys_login_log` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问id',
`username` varchar(50) DEFAULT '' COMMENT '用户账号',
`ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',
`status` tinyint(1) DEFAULT '0' COMMENT '登录状态（0：成功，1：失败）',
`msg` varchar(255) DEFAULT '' COMMENT '提示信息',
`access_time` datetime DEFAULT NULL COMMENT '访问时间',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统访问记录';
sys_menu权限菜单表
CREATE TABLE `sys_menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '所属上级',
`name` varchar(20) NOT NULL DEFAULT '' COMMENT ' 名称',
`type` varbinary(20) NOT NULL DEFAULT '0' COMMENT '类型(0:目录,1:菜单，2：按钮)',
`path` varbinary(100) DEFAULT NULL COMMENT '路由地址',
`component` varbinary(100) DEFAULT NULL COMMENT '组件路由',
`perms` varbinary(100) DEFAULT NULL COMMENT '权限标识',
`icon` varbinary(100) DEFAULT NULL COMMENT '图标',
`sort_value` int(11) DEFAULT NULL COMMENT '排序',
`status` tinyint(4) DEFAULT NULL COMMENT '状态(0:禁止，1：正常)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`),
KEY `idx_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='权限菜单表';
sys_order订单表
CREATE TABLE `sys_order` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
`order_sn` varchar(64) NOT NULL DEFAULT '' COMMENT '订单编号',
`broker_id` bigint(20) DEFAULT NULL COMMENT '经纪人id',
`community_id` bigint(20) DEFAULT NULL COMMENT '小区id',
`bridal_chamber_id` bigint(20) DEFAULT NULL COMMENT '新房id',
`secondary_id` bigint(20) DEFAULT NULL COMMENT '二手房id',
`pay_type` int(3) DEFAULT NULL COMMENT '支付方式(买：0：全款，1：按揭，2：分期；租：3：押一付三，4：半年一付，5：一年一付)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_order_id` (`order_sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单表';
sys_role角色表
CREATE TABLE `sys_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色编号',
`role_name` varchar(20) NOT NULL DEFAULT '' COMMENT '角色名称',
`role_code` varchar(20) DEFAULT NULL COMMENT '角色编码',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0:可用 1:已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色表';
sys_role_menu角色菜单表
CREATE TABLE `sys_role_menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` bigint(20) NOT NULL DEFAULT '0',
`menu_id` bigint(20) NOT NULL DEFAULT '0',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_menu_id` (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色菜单';
sys_secondary二手房表
CREATE TABLE `sys_secondary` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '二手房id',
`community_id` bigint(20) DEFAULT NULL COMMENT '小区id',
`name` varchar(100) NOT NULL DEFAULT '' COMMENT '房名',
`broker_id` bigint(20) DEFAULT NULL COMMENT '经纪人id',
`location_id` bigint(20) DEFAULT NULL COMMENT '位置id',
`towards_id` bigint(20) DEFAULT NULL COMMENT '朝向id',
`price` decimal(10,2) DEFAULT NULL COMMENT '售价',
`age_build_id` bigint(20) DEFAULT NULL COMMENT '楼龄id',
`publish_time` date DEFAULT NULL COMMENT '发布时间',
`floor_id` bigint(20) DEFAULT NULL COMMENT '楼层id',
`fitment_id` bigint(20) DEFAULT NULL COMMENT '装修id',
`lift_id` bigint(20) DEFAULT NULL COMMENT '电梯id',
`area_id` bigint(20) DEFAULT NULL COMMENT '面积id',
`use_id` bigint(20) DEFAULT NULL COMMENT '用途id',
`longitude` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '经度',
`latitude` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '纬度',
`status` int(3) NOT NULL DEFAULT '0' COMMENT '状态（0：在售，1：售罄）',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='二手房表';
sys_user用户表
CREATE TABLE `sys_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
`username` varchar(100) NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(100) NOT NULL DEFAULT '' COMMENT '密码',
`name` varchar(100) DEFAULT NULL COMMENT '姓名',
`postcard` varchar(200) DEFAULT NULL COMMENT '名片',
`imageurl` varchar(200) DEFAULT NULL COMMENT '头像地址',
`phone` varchar(11) DEFAULT NULL COMMENT '手机号',
`email` varchar(100) DEFAULT NULL COMMENT '邮箱',
`status` int(3) NOT NULL DEFAULT '1' COMMENT '状态（1：正常，0：停用）',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`is_deleted` tinyint(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`),
UNIQUE KEY `idx_username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';
sys_user_role用户角色表
CREATE TABLE `sys_user_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`role_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '角色id',
`user_di` bigint(20) NOT NULL DEFAULT '0' COMMENT '用户id',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`is_deleted` int(3) NOT NULL DEFAULT '0' COMMENT '删除标记（0：可用，1：已删除）',
PRIMARY KEY (`id`),
KEY `idx_role_id` (`role_id`),
KEY `idx_admin_id` (`user_di`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色';
示例数据
以下 5 条示例数据展示了各表之间的关联关系：
order_operate_history
INSERT INTO order_operate_history (order_id, operate_man, status, operate_time, create_time, update_time, is_deleted) VALUES (1, 1, 1, '2021-01-01 10:00:00', '2021-01-01 10:00:00', '2021-01-01 10:00:00', 0);
INSERT INTO order_operate_history (order_id, operate_man, status, operate_time, create_time, update_time, is_deleted) VALUES (2, 2, 2, '2021-02-01 10:00:00', '2021-02-01 10:00:00', '2021-02-01 10:00:00', 0);
INSERT INTO order_operate_history (order_id, operate_man, status, operate_time, create_time, update_time, is_deleted) VALUES (3, 3, 1, '2021-03-01 10:00:00', '2021-03-01 10:00:00', '2021-03-01 10:00:00', 0);
INSERT INTO order_operate_history (order_id, operate_man, status, operate_time, create_time, update_time, is_deleted) VALUES (4, 4, 2, '2021-04-01 10:00:00', '2021-04-01 10:00:00', '2021-04-01 10:00:00', 0);
INSERT INTO order_operate_history (order_id, operate_man, status, operate_time, create_time, update_time, is_deleted) VALUES (5, 5, 1, '2021-05-01 10:00:00', '2021-05-01 10:00:00', '2021-05-01 10:00:00', 0);
sys_bridal_chamber
INSERT INTO sys_bridal_chamber (comunity_id, name, broker_id, area_id, status, address, type_id, property_id, unit_price, total_price, fitment_id, characteristic_id, longitude, latitude, create_time, update_time, is_deleted) VALUES (1, '房名1', 1, 1, 0, '地址1', 1, 1, 10000, 1000000, 1, 1, 0.00, 0.00, '2021-01-01 10:00:00', '2021-01-01 10:00:00', 0);
INSERT INTO sys_bridal_chamber (comunity_id, name, broker_id, area_id, status, address, type_id, property_id, unit_price, total_price, fitment_id, characteristic_id, longitude, latitude, create_time, update_time, is_deleted) VALUES (2, '房名2', 2, 2, 1, '地址2', 2, 2, 20000, 2000000, 2, 2, 0.00, 0.00, '2021-02-01 10:00:00', '2021-02-01 10:00:00', 0);
INSERT INTO sys_bridal_chamber (comunity_id, name, broker_id, area_id, status, address, type_id, property_id, unit_price, total_price, fitment_id, characteristic_id, longitude, latitude, create_time, update_time, is_deleted) VALUES (3, '房名3', 3, 3, 2, '地址3', 3, 3, 30000, 3000000, 3, 3, 0.00, 0.00, '2021-03-01 10:00:00', '2021-03-01 10:00:00', 0);
INSERT INTO sys_bridal_chamber (comunity_id, name, broker_id, area_id, status, address, type_id, property_id, unit_price, total_price, fitment_id, characteristic_id, longitude, latitude, create_time, update_time, is_deleted) VALUES (4, '房名4', 4, 4, 0, '地址4', 4, 4, 40000, 4000000, 4, 4, 0.00, 0.00, '2021-04-01 10:00:00', '2021-04-01 10:00:00', 0);
INSERT INTO sys_bridal_chamber (comunity_id, name, broker_id, area_id, status, address, type_id, property_id, unit_price, total_price, fitment_id, characteristic_id, longitude, latitude, create_time, update_time, is_deleted) VALUES (5, '房名5', 5, 5, 1, '地址5', 5, 5, 50000, 5000000, 5, 5, 0.00, 0.00, '2021-05-01 10:00:00', '2021-05-01 10:00:00', 0);
sys_broker
INSERT INTO sys_broker (username, password, imageurl, postcard, phone, bridal_chamber_id, secondary_id, community_id, status, create_time, update_tiem, is_deleted) VALUES ('经纪人1', '123456', '头像地址1', '名片1', '13800000001', 1, 1, 1, 1, '2021-01-01 10:00:00', '2021-01-01 10:00:00', 0);
INSERT INTO sys_broker (username, password, imageurl, postcard, phone, bridal_chamber_id, secondary_id, community_id, status, create_time, update_tiem, is_deleted) VALUES ('经纪人2', '123456', '头像地址2', '名片2', '13800000002', 2, 2, 2, 0, '2021-02-01 10:00:00', '2021-02-01 10:00:00', 0);
INSERT INTO sys_broker (username, password, imageurl, postcard, phone, bridal_chamber_id, secondary_id, community_id, status, create_time, update_tiem, is_deleted) VALUES ('经纪人3', '123456', '头像地址3', '名片3', '13800000003', 3, 3, 3, 1, '2021-03-01 10:00:00', '2021-03-01 10:00:00', 0);
INSERT INTO sys_broker (username, password, imageurl, postcard, phone, bridal_chamber_id, secondary_id, community_id, status, create_time, update_tiem, is_deleted) VALUES ('经纪人4', '123456', '头像地址4', '名片4', '13800000004', 4, 4, 4, 0, '2021-04-01 10:00:00', '2021-04-01 10:00:00', 0);
INSERT INTO sys_broker (username, password, imageurl, postcard, phone, bridal_chamber_id, secondary_id, community_id, status, create_time, update_tiem, is_deleted) VALUES ('经纪人5', '123456', '头像地址5', '名片5', '13800000005', 5, 5, 5, 1, '2021-05-01 10:00:00', '2021-05-01 10:00:00', 0);
sys_community
INSERT INTO sys_community (name, description, area_id, address, build_num, longitude, latitute, average_price, hire, create_time, update_time, is_deleted) VALUES ('小区名1', '描述1', 1, '地址1', 100, 0.00, 0.00, 10000, 1, '2021-01-01 10:00:00', '2021-01-01 10:00:00', 0);
INSERT INTO sys_community (name, description, area_id, address, build_num, longitude, latitute, average_price, hire, create_time, update_time, is_deleted) VALUES ('小区名2', '描述2', 2, '地址2', 200, 0.00, 0.00, 20000, 0, '2021-02-01 10:00:00', '2021-02-01 10:00:00', 0);
INSERT INTO sys_community (name, description, area_id, address, build_num, longitude, latitute, average_price, hire, create_time, update_time, is_deleted) VALUES ('小区名3', '描述3', 3, '地址3', 300, 0.00, 0.00, 30000, 1, '2021-03-01 10:00:00', '2021-03-01 10:00:00', 0);
INSERT INTO sys_community (name, description, area_id, address, build_num, longitude, latitute, average_price, hire, create_time, update_time, is_deleted) VALUES ('小区名4', '描述4', 4, '地址4', 400, 0.00, 0.00, 40000, 0, '2021-04-01 10:00:00', '2021-04-01 10:00:00', 0);
INSERT INTO sys_community (name, description, area_id, address, build_num, longitude, latitute, average_price, hire, create_time, update_time, is_deleted) VALUES ('小区名5', '描述5', 5, '地址5', 500, 0.00, 0.00, 50000, 1, '2021-05-01 10:00:00', '2021-05-01 10:00:00', 0);
sys_order
INSERT INTO sys_order (user_id, order_sn, broker_id, community_id, bridal_chamber_id, secondary_id, pay_type, create_time, update_time, is_deleted) VALUES (1, '订单号1', 1, 1, 1, NULL, 0, '2021-01-01 10:00:00', '2021-01-01 10:00:00', 0);
INSERT INTO sys_order (user_id, order_sn, broker_id, community_id, bridal_chamber_id, secondary_id, pay_type, create_time, update_time, is_deleted) VALUES (2, '订单号2', 2, 2, NULL, 2, 1, '2021-02-01 10:00:00', '2021-02-01 10:00:00', 0);
INSERT INTO sys_order (user_id, order_sn, broker_id, community_id, bridal_chamber_id, secondary_id, pay_type, create_time, update_time, is_deleted) VALUES (3, '订单号3', 3, 3, 3, NULL, 2, '2021-03-01 10:00:00', '2021-03-01 10:00:00', 0);
INSERT INTO sys_order (user_id, order_sn, broker_id, community_id, bridal_chamber_id, secondary_id, pay_type, create_time, update_time, is_deleted) VALUES (4, '订单号4', 4, 4, NULL, 4, 3, '2021-04-01 10:00:00', '2021-04-01 10:00:00', 0);
INSERT INTO sys_order (user_id, order_sn, broker_id, community_id, bridal_chamber_id, secondary_id, pay_type, create_time, update_time, is_deleted) VALUES (5, '订单号5', 5, 5, 5, NULL, 4, '2021-05-01 10:00:00', '2021-05-01 10:00:00', 0);
这些示例数据展示了订单操作历史、经纪人、新房、小区与订单之间的关系。
注意：
- 以上示例数据仅供参考，实际数据需要根据具体需求进行设计和填充。
- 表结构中未列出的字段，需要根据实际需求进行添加。
- 为了更好的维护和管理数据库，建议使用数据库设计规范和命名规范。
- 在实际开发过程中，还需要考虑数据安全、性能优化等问题。
原文地址: https://www.cveoy.top/t/topic/bBL6 著作权归作者所有。请勿转载和采集!