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