test

Tables (6)

COUNTRY (국가정보)

  • COUNTRY_ID (국가코드) — CHAR(2) — Primary key — NOT NULL
  • COUNTRY_NAME (국가이름) — VARCHAR2(30)

DEPARTMENT (부서정보)

  • DEPT_ID (부서코드) — CHAR(2) — Primary key — NOT NULL
  • LOC_ID (지역코드) — CHAR(2) — Foreign key → LOCATION.LOCATION_ID — NOT NULL
  • DEPT_NAME (부서이름) — VARCHAR2(30)

EMPLOYEE (사원정보)

  • 11 (사번) — CHAR(3) — Primary key — NOT NULL
  • EMP_NO (주민번호) — VARCHAR2(20)
  • EMAIL (e-Mail) — VARCHAR2(25)
  • PHONE (전화번호) — VARCHAR2(12)
  • HIRE_DATE (입사일) — DATE
  • SALARY (급여) — NUMBER
  • BONUS_PCT (보너스지급율) — NUMBER
  • MARRIAGE (결혼여부) — CHAR(1)
  • JOB_ID (직급코드) — CHAR(2) — Foreign key → JOB.JOB_ID — NOT NULL
  • MGR_ID (관리자 사번) — CHAR(3) — Foreign key → EMPLOYEE.11 — NOT NULL
  • DEPT_ID (부서코드) — CHAR(3) — Foreign key → DEPARTMENT.DEPT_ID — NOT NULL
  • EMP_NAME (사원명) — VARCHAR2(20)

JOB (직급정보)

  • JOB_ID (직급코드) — CHAR(2) — Primary key — NOT NULL
  • JOB_TITLE (직급이름) — VARCHAR2(35)
  • MIN_SAL (최소급여) — NUMBER
  • MAX_SAL (최대급여) — NUMBER

LOCATION (근무처)

  • LOCATION_ID (지역 코드) — CHAR(2) — Primary key — NOT NULL
  • COUNTRY_ID (국가코드) — CHAR(2) — Foreign key → COUNTRY.COUNTRY_ID — NOT NULL
  • LOC_DESCRIBE (지역설명) — VARCHAR2(40)

SAL_GRADE (Untitled6)

  • SLEVEL (급여레벨) — CHAR(1) — Primary key — NOT NULL
  • LOWEST (하한값) — NUMBER
  • HIGHEST (상한값) — NUMBER