schema.sql.1
1.09 KB
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
--用户信息
create table users(
id SERIAL8 PRIMARY KEY ,
name VARCHAR,
password VARCHAR,
level INTEGER,
belong_id VARCHAR
)
--分公司
create table belongs(
id SERIAL8 PRIMARY KEY ,
name VARCHAR
)
--项目
create table projects(
id SERIAL8 PRIMARY KEY ,
name VARCHAR,
remark VARCHAR,
users_id INTEGER
)
--项目关联销售
create table sales_man(
users_id INTEGER,
projects_id INTEGER,
state VARCHAR
)
--项目对接人员
create table docking_man(
id SERIAL8 PRIMARY KEY ,
name VARCHAR,
position VARCHAR,
mobile VARCHAR,
projects_id INTEGER,
corporate_name VARCHAR,
industry VARCHAR
)
--跟踪记录
create table tracking_record(
id SERIAL8 PRIMARY KEY ,
users_id INTEGER,
projects_id INTEGER,
content VARCHAR,
remark VARCHAR,
start_time TIMESTAMP,
target_time TIMESTAMP,
relation INTEGER,
state VARCHAR
)
--项目内容信息表
create TABLE projects_value(
cillection_point_num INTEGER,
scene_name VARCHAR,
enviroment VARCHAR,
present_situation VARCHAR,
planning_intention VARCHAR,
planned_implementation_time TIMESTAMP,
project_id INTEGER,
survey_category VARCHAR
)