portFolio

Tables (4)

DEPT

  • DEPT_ID — varchar2(4) — Primary key — NOT NULL
  • DEPT_NAME_KOR — varchar2(6)
  • DEPT_NAME_EN — varchar2(6)

JOB

  • JOB_ID — varhchar2(4) — Primary key — NOT NULL
  • JOB_NAME_KOR — varchar2(6)
  • JOB_NAME_EN — varchar2(10)

PF_USER (User)

  • EPID — varchar2(10) — Primary key — NOT NULL
  • NAME_KOR — varchar2(30)
  • NAME_EN — varchar2(30)
  • EMAIL — varchar2(50)
  • ID — varchar2(15)
  • PASSWORD — varchar2(64)
  • DEPT_ID — varchar2(4) — Foreign key → DEPT.DEPT_ID — NOT NULL
  • JOB_ID — varhchar2(4) — Foreign key → JOB.JOB_ID — NOT NULL
  • ROLE_ID — varchar2(4) — Foreign key → ROLE.ROLE_ID — NOT NULL

ROLE

  • ROLE_ID — varchar2(4) — Primary key — NOT NULL
  • ROLE_NAME — varchar2(10)