Test
테이블 (6)
Untitled (부서)
- Key (부서번호) — 기본 키 — NOT NULL
- Field (부서명)
- Field2 (부서위치)
comments
- comment_id — NUMBER
- review_id — NUMBER — 외래 키 → reviews.review_id — NOT NULL
- user_id — NUMBER — 외래 키 → users.user_id — NOT NULL
- content — CLOB — NOT NULL
- created_at — DATE
- updated_at — DATE
review_reactions
- review_id — NUMBER — 외래 키 → reviews.review_id — NOT NULL
- user_id — NUMBER — 외래 키 → users.user_id — NOT NULL
- reaction_type — VARCHAR2(10) — NOT NULL
- created_at — DATE
reviews
- review_id — NUMBER
- user_id — NUMBER — 외래 키 → users.user_id — NOT NULL
- drama_title — VARCHAR2(100) — NOT NULL
- title — VARCHAR2(255) — NOT NULL
- content — CLOB — NOT NULL
- created_at — DATE
- updated_at — DATE
users
- user_id — NUMBER
- username — VARCHAR2(50) — NOT NULL
- email — VARCHAR2(100) — NOT NULL
- password_hash — VARCHAR2(255) — NOT NULL
- created_at — DATE
사원 (EMP)
- Key (사원번호) — 기본 키 — NOT NULL
- Field (사원명)
- Field2 (담당업무)
- Field3 (입사일자)
- Field4 (급여)
- Field (보너스)
- Key (부서번호) — 외래 키 → Untitled.Key — NOT NULL
- Key (사원번호2) — 외래 키 → 사원.Key — NOT NULL