schema.sql.1
849 Bytes
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
--用户信息
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,
start_time TIMESTAMP,
end_time TIMESTAMP
)
--项目关联销售
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
)
--跟踪记录
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
)