SCOTT

Tables (3)

DEPT (Untitled)

  • 부서번호 (DEPTNO) — NUMBER(10) — Primary key — NOT NULL
  • 부서명 (DNAME) — VARCHAR2(10)
  • Field2 (LOC) — VARCHAR2(10)
  • Field3
  • Field4
  • Field5
  • Field6

TEMP (Untitled2)

  • Key (TEMPNO) — NUMBER(10) — Primary key — NOT NULL
  • (TEMPNAME) — VARCHAR2(20)
  • 부서번호 (DEPTNO) — NUMBER(10) — Foreign key → DEPT.부서번호 — NOT NULL

Untitled3

  • Key (TEMPNO) — NUMBER(10) — Foreign key → TEMP.Key — NOT NULL
  • 부서번호 (DEPTNO) — NUMBER(10) — Foreign key → DEPT.부서번호 — NOT NULL