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)