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