-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.txt
41 lines (36 loc) · 667 Bytes
/
schema.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
departments
-
dept_no varchar pk
dept_name varchar
dept_emp
-
emp_no int pk fk >- employees.emp_no
dept_no varchar pk fk >- departments.dept_no
from_date date
to_date date
dept_manager
-
dept_no varchar pk fk - departments.dept_no
emp_no int pk fk - employees.emp_no
from_date date
to_date date
employees
-
emp_no int pk
birth_date date
first_name varchar
last_name varchar
gender varchar
hire_date date
salaries
-
emp_no int fk >- employees.emp_no
salary int
from_date date
to_date date
titles
-
emp_no int pk fk -< employees.emp_no
title varchar
from_date date
to_date date