test

테이블 (10)

COUNTRYS (국가의정보)

  • COUNTRY_ID (Key) — 기본 키 — NOT NULL
  • REGION_ID (Key2) — 외래 키 → RESIONS.REGION_ID — NOT NULL
  • COUNTRY_NAME (Field)

DEPARTMENTS (부서의정보)

  • DEPARTMENT_ID (Key) — 기본 키 — NOT NULL
  • LOCATION_ID (Key2) — 외래 키 → LOCATIONS.LOCATION_ID — NOT NULL
  • COUNTRY_ID (Key22) — 외래 키 → LOCATIONS.COUNTRY_ID — NOT NULL
  • REGION_ID (Key222) — 외래 키 → LOCATIONS.REGION_ID — NOT NULL
  • DEPARTMENT_NAME (Field)
  • MANAGER_ID (Field2)

EMPLOYEES (사원의정보)

  • EMPLOYEE_ID (Key) — 기본 키 — NOT NULL
  • DEPARTMENT_ID (Key2) — 외래 키 → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
  • LOCATION_ID (Key22) — 외래 키 → DEPARTMENTS.LOCATION_ID — NOT NULL
  • COUNTRY_ID (Key222) — 외래 키 → DEPARTMENTS.COUNTRY_ID — NOT NULL
  • REGION_ID (Key2222) — 외래 키 → DEPARTMENTS.REGION_ID — NOT NULL
  • FIRST_NAME (Field)
  • LAST_NAME (Field2)
  • EMAIL (Field3)
  • PHONE_NUMBER (Field4)
  • HIRE_DATE (Field5)
  • JOB_ID (Field6)
  • SALARY (Field7)
  • COMMISSION_PCT (Field8)

JOBS (직업)

  • JOB_ID (Key) — 기본 키 — NOT NULL
  • JOB_TITLE (Field)
  • MIN_SALARY (Field2)
  • MAX_SALARY (Field3)

JOB_HISTORY (직업정보?)

  • EMPLOYEE_ID (Key) — 기본 키 — NOT NULL
  • START_DATE (Field)
  • END_DATE (Field2)
  • JOB_ID (Field3)
  • DEPARTMENT_ID (Field4)

LOCATIONS (부서가 있는 지역정보)

  • LOCATION_ID (Key) — 기본 키 — NOT NULL
  • COUNTRY_ID (Key2) — 외래 키 → COUNTRYS.COUNTRY_ID — NOT NULL
  • REGION_ID (Key22) — 외래 키 → COUNTRYS.REGION_ID — NOT NULL
  • STREET_ADDRESS (Field)
  • POSTAL_CODE (Field2)
  • CITY (Field3)
  • STATE_PROVINCE (Field4)

RESIONS (대륙의정보)

  • REGION_ID (Key) — NUMBER — 기본 키 — NOT NULL
  • REGION_NAME (Field)

table_name (Untitled)

    대륙첨부파일 (REGIONFILES)

    • REGION_ID (Key) — NUMBER — 외래 키 → RESIONS.REGION_ID — NOT NULL
    • 파일 (FILENAME) — VARCHAR2(300)
    • 오리진파일 (ORINAME) — VARCHAR2(300)

    상품 (product)

    • 상품번호 (productnum) — number — 기본 키 — NOT NULL
    • 상품명 (productname) — varchar2(200)
    • 상품설명 (productcontents) — clob
    • 이자율 (productrate) — number(4,2)
    • 평점 (productjumsu) — number(2,1)