SCOTT

Tables (5)

DEPARTMENT (DEPT)

  • DEPARTMENT NUMBER (DEPTNO) — Primary key — NOT NULL
  • DEPARTMENT NAME (DNAME)
  • LOCATIONL (LOC)

EMPLOYEES (EMP)

  • EMPLOYEE NUMBER (EMPNO) — Primary key — NOT NULL
  • DEPARTMENT NUMBER (DEPTNO) — Foreign key → DEPARTMENT.DEPARTMENT NUMBER — NOT NULL
  • EMPLOYEE'S NAME (ENAME)
  • JOB
  • MANAGER (MGR)
  • HIREDATE
  • SALARY (SAL)
  • COMMISION (COMM)

Untitled (회원)

  • Key (계정 ID) — Primary key — NOT NULL
  • Field (계정 비번)
  • Field2 (작성자명)

Untitled (게시글)

  • Key (게시글ID) — Primary key — NOT NULL
  • Field (제목)
  • Field2 (내용)
  • Key (계정 ID) — Foreign key → Untitled.Key — NOT NULL

Untitled (댓글)

  • Key (댓글ID) — Primary key — NOT NULL
  • Field (내용)
  • Key (게시글ID) — Foreign key → Untitled.Key — NOT NULL
  • Key (계정 ID) — Foreign key → Untitled.Key — NOT NULL