TEST

Tables (5)

COUNTRIES (나라정보)

  • COUNTRY_ID (Key) — VARCHAR2 — Primary key — NOT NULL
  • REGION_ID (Key2) — NUMBER — Foreign key → REGIONS.REGION_ID — NOT NULL
  • COUNTRY_NAME (Field) — VARCHAR2
  • REGION_ID (Field2) — NUMBER

DEPARTMENTS (부서정보)

  • DEPARTMENT_ID (Key) — NUMBER — Primary key — NOT NULL
  • LOCATION_ID (Key2) — NUMBER — Foreign key → LOCATIONS.LOCATION_ID — NOT NULL
  • DEPARTMEN_NAME (Field) — VARCHAR2
  • MANAGER_ID (Field2) — NUMBER

EMPLOYEES (사원 정보)

  • EMPLOYEE_ID (Key) — NUMBER — Primary key — NOT NULL
  • DEPARTMENT_ID (Key2) — NUMBER — Foreign key → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
  • FIRST_NAME (Field) — VARCHAR2
  • LAST_NAME (Field2) — VARCHAR2
  • EMAIL (Field3) — VARCHAR2
  • PHONE_NUMBER (Field4) — VARCHAR2
  • HIRE_DATE (Field5) — DATE
  • SALARY (Field6) — NUMBER
  • MANAGER_ID (Field7) — NUMBER
  • DEPARTMENT_ID (Field8) — NUMBER

LOCATIONS (지역정보)

  • LOCATION_ID (Key) — NUMBER — Primary key — NOT NULL
  • COUNTRY_ID (Key2) — VARCHAR2 — Foreign key → COUNTRIES.COUNTRY_ID — NOT NULL
  • STREET_ADDRESS (Field) — VARCHAR2
  • POSTAL_CODE (Field2) — VARCHAR2
  • CITY (Field3) — VARCHAR2
  • STATE_PROVINCE (Field4) — VARCHAR2

REGIONS (대륙정보)

  • REGION_ID (Key) — NUMBER — Primary key — NOT NULL
  • REGION_NAME (Field) — VARCHAR2