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