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