DDL_PRACTICE
Tables (4)
Copy Of OUR_EMP (CopyOfOUR_EMP)
- EID — CHAR(3 CHAR) — Primary key — NOT NULL — 사번
- Field (PHONE) — VARCHAR2(13 CHAR) — 이름
- Field (HIRE_DATE) — DATE — 입사일
- Field (ENO) — CHAR(14 CHAR) — 주민번호
- Field (ENAME) — VARCHAR2(20 CHAR) — NOT NULL — 이름
- Field (MARRIAGE) — CHAR(1) — 혼인여부
- Field (AGE) — NUMBER — 나이
- Key (DEPT_CODE) — CHAR(3 CHAR) — Foreign key → Untitled.Key — NOT NULL — 부서번호
OUR_EMP
- EID — CHAR(3 CHAR) — Primary key — NOT NULL — 사번
- Field (PHONE) — VARCHAR2(13 CHAR) — 이름
- Field (HIRE_DATE) — DATE — 입사일
- Field (ENO) — CHAR(14 CHAR) — 주민번호
- Field (ENAME) — VARCHAR2(20 CHAR) — NOT NULL — 이름
- Field (MARRIAGE) — CHAR(1) — 혼인여부
- Field (AGE) — NUMBER — 나이
- Key (DEPT_CODE) — CHAR(3 CHAR) — Foreign key → Untitled.Key — NOT NULL — 부서번호
Untitled (OUR_DEPT)
- Key (DEPT_CODE) — CHAR(3 CHAR) — Primary key — NOT NULL — 부서번호
- Field (DEPT_TITLE) — VARCHAR2(30 CHAR) — 부서명
baseball_rank (Untitled)
- bd_idx (Key) — VARCHAR2(36CHAR) — Primary key — NOT NULL
- name (Field) — VARCHAR2(36CHAR)
- game (Field2) — Number
- win (Field3) — Number
- lose (Field4) — Number
- tie (Field5) — Number