34,593
社区成员
发帖
与我相关
我的任务
分享
create table dd_addition (
catagoryid int,
id int,
context varchar(64)
)
insert into dd_addition values (0,1,'目前工作区域')
insert into dd_addition values (0,2,'从事行业')
insert into dd_addition values (0,3,'家庭年收入')
insert into dd_addition values (0,4,'目前住宅性质')
insert into dd_addition values (0,5,'您购房的主要目的')
insert into dd_addition values (0,6,'希望的楼型')
insert into dd_addition values (0,7,'欲购房总价(万元)')
insert into addition values (2,1,'IT行业')
insert into addition values (2,2,'保险业')
insert into addition values (2,3,'广告业')
insert into addition values (2,4,'电信业')
..
insert into addition values (6,1,'板式公寓')
insert into addition values (6,2,'电梯公寓')
..
insert into addition values (7,1,'50~80万')
insert into addition values (7,2,'80~100万')
insert into addition values (7,3,'100~120万')
insert into addition values (7,4,'>120万')
..
create table users (
id int
,chinesename varchar(32)
,...
)
create table users_addition (
userid int
,catagoryid int
,additionid int
)