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 — 상한값