SQL学习笔记0——表关系

locations表：
location_id NUMBER(4)
street_address VARCHAR2(12)Y
postal_code VARCHAR2(12)Y
city VARCHAR2(30)
state_province VARCHAR2(25)Y
country_id CHAR(2)Y

jobs表：
job_id VARCHAR2(10)
job_title VARCHAR2(35)
min_salary NUMBER(6)Y
max_salary NUMBER(6)Y

department表：
department_id NUMBER(4)
department_name VARCHAR2(30)
manager_id NUMBER(6)Y
location_id NUMBER(4)Y

job_grages表：
grade_level VARCHAR2(3)Y
lowest_sal NUMBER Y
highest_sal NUMBER Y

employees表：
employee_id NUMBER(6)
first_name VARCHAR2(20)Y
last_name VARCHAR2(25)
email VARCHAR2(25)
phone_number VARCHAR2(20)Y
hire_date DATE 
job_id VARCHAR2(10)
salary NUMBER(8,2)Y
commission_pct NUMBER(2,2)Y
manager_id NUMBER(6)Y
department_id NUMBER(4)Y