KH_PROJECT1

Tables (5)

Board

  • board_id — NUMBER — Primary key — NOT NULL
  • user_id — VARCHAR(30) — Foreign key → User.user_id — NOT NULL
  • title — VARCHAR(30) — NOT NULL
  • content — CLOB — NOT NULL

Comment

  • comment_id — NUMBER — Primary key — NOT NULL
  • board_id — NUMBER — Foreign key → Board.board_id — NOT NULL
  • user_id — VARCHAR(30) — Foreign key → Board.user_id — NOT NULL
  • comment_text — CLOB — NOT NULL

Movie

  • movie_id — NUMBER — Primary key — NOT NULL
  • title — VARCHAR(30) — NOT NULL
  • discription — CLOB — NOT NULL
  • director — VARCHAR(30) — NOT NULL

Movie_comment

  • movie_comment_id — NUMBER — Primary key — NOT NULL
  • movie_id — NUMBER — Foreign key → Movie.movie_id — NOT NULL
  • user_id — VARCHAR(30) — Foreign key → User.user_id — NOT NULL
  • comment_text — CLOB — NOT NULL

User

  • user_id — VARCHAR(30) — Primary key — NOT NULL
  • password — VARCHAR(16) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(10) — NOT NULL