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