-
Notifications
You must be signed in to change notification settings - Fork 1
/
tables.txt
68 lines (61 loc) · 1.81 KB
/
tables.txt
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
68
CREATE TABLE Company (
company_id INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
company_name VARCHAR(100),
industry VARCHAR(100),
company_website_url VARCHAR(100)
);
CREATE TABLE Contacts (
contact_id INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
contact_first_name VARCHAR(100),
contact_last_name VARCHAR(100),
contact_email_address VARCHAR(100),
contact_company_id INTEGER REFERENCES Company,
contact_company_name VARCHAR(100)
contact_phone_number VARCHAR(50),
contact_linkedin_profile VARCHAR(100),
contact_type VARCHAR(100)
);
CREATE TABLE Position (
position_id INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(50),
position_summary VARCHAR(3000),
deadline_for_application_submission NULLABLE DATETIME,
company_name VARCHAR(100) REFERENCES Company,
location VARCHAR(50),
application_status VARCHAR(50),
position_url VARCHAR(100),
user_id INTEGER REFERENCES User
);
CREATE TABLE Interviews (
interview_id INTEGER AUTOINCREMENT NOT NULL PRIMARY KEY,
interview_date DATETIME,
position_summary VARCHAR(max),
interview_type VARCHAR(100),
interview_status VARCHAR(100),
position_id INTEGER FOREIGN KEY
);
CREATE TABLE Notes (
notes_id INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
note VARCHAR(3000),
position_id INTEGER REFERENCES Position
);
CREATE TABLE User(
user_id INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,
first_name VARCHAR(100),
last_name VARCHAR(100),
picture VARCHAR(100),
email_address VARCHAR(100),
last_login DATETIME,
user_LinkedIn_url VARCHAR(100),
user_Twitter_url VARCHAR(100),
user_Facebook_url VARCHAR(100),
user_website_url VARCHAR(100)
);
interview_id INTEGER REFERENCES Interviews
CREATE TABLE User_Assets (
user_asset_id AUTO_INCREMENT NOT NULL PRIMARY KEY,
asset_type VARCHAR(100),
asset_content VARCHAR(3000),
position_id INTEGER NULLABLE REFERENCES Position,
user_id INTEGER NULLABLE REFERENCES User
);