DDL_PRACTICE

Tables (3)

OUR_EMP (CLOUD_EMP)

  • Key (EMP_ID) — NUMBER — Primary key — NOT NULL — 사번
  • Field (EMP_NAME) — VARCHAR(50 CHAR) — NOT NULL — 이름
  • Field2 (PHONE) — CHAR(13 CHAR) — NOT NULL — 휴대폰번호
  • Field (HIRE_DATE) — DATE — 입사일
  • Key (DEPT_CODE) — NUMBER — Foreign key → Untitled.Key — NOT NULL — 부서번호

Untitled (CLOUD_DEPT)

  • Key (DEPT_CODE) — NUMBER — Primary key — NOT NULL — 부서번호
  • Field (DEPT_TITLE) — VARCHAR2(50 CHAR) — NOT NULL — 부서명

board (Untitled)

  • Key (NO) — number — Primary key — NOT NULL — 글번호
  • Field (status) — varchar2