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