DDL

Tables (3)

OUR_DEPT

  • DEPT_CODE — CHAR(30 — Primary key — NOT NULL — 부서번호
  • DEPT_TITLE — VARCHAR2(30 CHAR)

OUR_EMP

  • EID — CHAR(3 CHAR) — Primary key — NOT NULL — 사번
  • PHONE — VARCHAR2(13 CHAR) — 휴대폰번호
  • HIRE_DATE — DATE — 입사일
  • ENO — VARCHAR2(20 CHAR) — 주민번호
  • ENAME — VARCHAR2(20 CHAR) — NOT NULL — 이름
  • MARRIAGE — CHAR(1) — 혼인여부
  • AGE — NUMBER — 나이
  • DEPT_CODE — CHAR(30 — Foreign key → OUR_DEPT.DEPT_CODE — NOT NULL — 부서번호

baseball_rank

  • br_idx (rank) — VARCHAR2(36 CHAR) — Primary key — NOT NULL
  • name — VARCHAR2(36 CHAR)
  • Field2 (game) — NUMBER
  • Field3 (win) — NUMBER
  • Field4 (lose) — NUMBER
  • Field (tie) — NUMBER
  • Field (reg_date) — DATE