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