Test
Tables (6)
COUNTRY (Untitled3)
- COUNTRY_ID (PK_CTRID) — Primary_Key — Primary key — NOT NULL — 국가 코드
- COUNTRY_NAME (SYS_C007303) — Check — NOT NULL — 국가 이름
DEPARTMENT (CopyOfUntitled)
- DEPT_ID (PK_DEPTID) — Primary_Key — Primary key — NOT NULL — 부서 코드
- DEPT_NAME (Field4) — NOT NULL — 부서 이름
- LOC_ID (NN_LOCID) — Check — Foreign key → LOCATION.LOCATION_ID — NOT NULL — 지역 코드
EMPLOYEE (Untitled)
- EMP_ID (Field) — Primary key — 사번
- EMP_NAME (NN_ENAME) — Check — 이름
- EMP_NO (NN_EMPNO) — Check
- EMAIL (Field4) — NOT NULL — e-Mail
- PHONE (Field6) — NOT NULL — 전화번호
- HIRE_DATE (Field5) — NOT NULL — 입사일
- JOB_ID (FK_JOBID) — Foreign_Key — Foreign key → JOB.JOB_ID — NOT NULL — 직급코드
- SALARY (Field7) — NOT NULL — 급여
- BONUS_PCT (Field8) — NOT NULL — 보너스 지급율
- MARRIAGE (CHK_MRIG) — Check — NOT NULL — 결혼여부
- MGR_ID (FK_MGRID) — Foreign_Key — Foreign key → EMPLOYEE.EMP_ID — NOT NULL — 관리자사번
- DEPT_ID (FK_DEPTID) — Foreign_Key — Foreign key → DEPARTMENT.DEPT_ID — NOT NULL — 부서코드
JOB (Untitled4)
- JOB_ID (PK_JOBID) — Primary_Key — Primary key — NOT NULL — 직급코드
- JOB_TITLE (Field) — NOT NULL — 직급이름
- MIN_SAL (Field2) — NOT NULL — 최소급여
- MAX_SAL (Field3) — NOT NULL — 최대급여
LOCATION (Untitled2)
- LOCATION_ID (PK_LOCID) — Primary_Key — Primary key — 지역코드
- COUNTRY_ID (FK_CTRID) — Foreign_Key — Foreign key → COUNTRY.COUNTRY_ID — NOT NULL — 국가코드
- LOC_DESCRIBE (Field3) — NOT NULL — 지역설명
SAL_GRADE (Untitled5)
- SLEVEL (SYS_C007311) — Primary_Key — Primary key — NOT NULL — 급여레벨
- LOWEST (Field) — NOT NULL — 하한값
- HIGHEST (Field2) — NOT NULL — 상한값