KH_PROJECT1 - 2025-07-01 08:35:12

Tables (5)

Boards

  • board_id — NUMBER
  • user_id — VARCHAR2(30) — NOT NULL
  • title — VARCHAR2(100) — NOT NULL
  • content — CLOB — NOT NULL

Comments

  • comment_id — NUMBER
  • board_id — NUMBER — NOT NULL
  • user_id — VARCHAR2(30) — NOT NULL
  • comment — CLOB — NOT NULL — LOB NOT NUL

Movie_Comments

  • movie_comment_id — NUMBER
  • movie_id — NUMBER — NOT NULL
  • user_id — VARCHAR2(30) — NOT NULL
  • comment — CLOB — NOT NULL — LOB NOT NUL

Movies

  • movie_id — NUMBER
  • title — VARCHAR2(100) — NOT NULL
  • description — CLOB
  • director — VARCHAR2(50)
  • open_date — DATE

Users

  • user_id — VARCHAR2(30)
  • password — VARCHAR2(16) — NOT NULL
  • username — VARCHAR2(50) — NOT NULL
  • nickname — VARCHAR2(10) — NOT NULL