表结构和测试数据如下:
create table house_mgr(
id number(15),
parent_id number(15),
house_name varchar2(255),
house_type number(1),
house_status varchar2(20) default '未租'
);
comment on column house_mgr.id
is '主键';
comment on column house_mgr.parent_id
is '父id';
comment on column house_mgr.house_name
is '房产名称';
comment on column house_mgr.house_type
is '房产类型:0楼栋,1房屋,2房间';
comment on column house_mgr.house_status
is '房产状态:已租,未租';
insert into house_mgr values(1,0,'楼栋1',0,'未租');
insert into house_mgr values(2,1,'楼栋1房屋1',1,'已租');
insert into house_mgr values(3,1,'楼栋1房屋2',1,'未租');
insert into house_mgr values(4,2,'楼栋1房屋1房间1',2,'未租');
insert into house_mgr values(5,3,'楼栋1房屋2房间1',2,'已租');
insert into house_mgr values(6,3,'楼栋1房屋2房间2',2,'已租');