1차발표

테이블 (8)

COUNTRIES

  • COUNTRY_ID — CHAR(2 BYTE) — 기본 키 — NOT NULL
  • COUNTRY_NAME — VARCHAR2(40 BYTE)
  • REGION_ID — VARCHAR2(40 BYTE) — 외래 키 → REGIONS.REGION_ID — NOT NULL

Copy Of COUNTRIES (JOBS)

  • Key (JOB_ID) — NUMBER(4,0) — 기본 키 — NOT NULL
  • Field (JOB_TITLE) — NUMBER(4,0)
  • Field2 (MIN_SALARY) — VARCHAR2(40 BYTE)
  • Field3 (MAX_SALARY) — VARCHAR2(40 BYTE)

Copy Of COUNTRIES2 (EMPLOYEES)

  • Key (EMPLOYEE_ID) — NUMBER(4,0) — 기본 키 — NOT NULL
  • Field3 (FIRST_NAME) — VARCHAR2(40 BYTE)
  • Field (LAST_NAME) — NUMBER(4,0)
  • Field2 (EMAIL) — NUMBER(4,0)
  • Field4 (PHONE_NUMBER) — VARCHAR2(40 BYTE)
  • Field5 (HIRE_DATE) — NUMBER(4,0)
  • Field6 (JOB_ID) — NUMBER(4,0)
  • Field7 (SALARY) — VARCHAR2(40 BYTE)
  • Field8 (COMMISSION_PCT) — VARCHAR2(40 BYTE)
  • Key (MANAGER_ID) — VARCHAR2(40 BYTE) — 외래 키 → Copy Of COUNTRIES2.Key — NOT NULL
  • DEPARTMENT_ID — VARCHAR2(40 BYTE) — 외래 키 → DEPARTMENTS.DEPARTMENT_ID — NOT NULL

DEPARTMENTS

  • DEPARTMENT_ID — NUMBER(4,0) — 기본 키 — NOT NULL
  • DEPARTMENT_NAME — NUMBER(4,0)
  • MANAGER_ID — VARCHAR2(40 BYTE)
  • LOCATION_ID — VARCHAR2(40 BYTE) — 외래 키 → LOCATIONS.LOCATION_ID — NOT NULL

LOCATIONS

  • LOCATION_ID — NUMBER(4,0) — 기본 키 — NOT NULL
  • STREET_ADDRESS — VARCHAR2(40 BYTE)
  • POSTAL_CODE — VARCHAR2(12 BYTE)
  • CITY — VARCHAR2(30 BYTE)
  • STATE_PROVINCE — VARCHAR2(25 BYTE)
  • COUNTRY_ID — VARCHAR2(40 BYTE) — 외래 키 → COUNTRIES.COUNTRY_ID — NOT NULL

REGIONS

  • REGION_ID — NUMBER — 기본 키 — NOT NULL
  • REGION_NAME — VARCHAR2(40 BYTE)

Untitled (JOB_HISTORY)

  • Key (EMPLOYEE_ID) — NUMBER(4,0) — 외래 키 → Copy Of COUNTRIES2.Key — NOT NULL
  • Field (START_DATE) — NUMBER(4,0)
  • Field2 (END_DATE) — NUMBER(4,0)
  • Field3 (JOB_ID) — NUMBER(4,0)
  • Field4 (DEPARTMENT_ID) — VARCHAR2(40 BYTE)
  • Key (JOB_ID2) — NUMBER(4,0) — 외래 키 → Copy Of COUNTRIES.Key — NOT NULL

Untitled (JOB_GRADES)

  • Field2 (LOWEST_SAL) — VARCHAR2(40 BYTE)
  • Field3 (HIGHEST_SAL) — VARCHAR2(40 BYTE)
  • Field (GRADE_LEVEL) — VARCHAR2(40 BYTE)