Block
Tables (4)
boards (Untitled2)
- board_id — NUMBER — Primary key — NOT NULL
- board_name — VARCHAR2(100) — NOT NULL
- description — VARCHAR2(255)
- created_at — DATE — NOT NULL
comments (Untitled4)
- comment_id (coment_id) — NUMBER — Primary key — NOT NULL
- content — VARCHAR2(500) — NOT NULL
- created_at — DATE — NOT NULL
- board_id — NUMBER — Foreign key → boards.board_id — NOT NULL
- user_id — NUMBER — Foreign key → users.user_id — NOT NULL
posts (Untitled3)
- post_id — NUMBER — Primary key — NOT NULL
- title — VARCHAR2(200) — NOT NULL
- content — CLOB — NOT NULL
- view_countN (view_count) — NUMBER
- created_at — DATE — NOT NULL
- updated_at (update_at) — DATE — NOT NULL
- user_id — NUMBER — Foreign key → users.user_id — NOT NULL
- board_id — NUMBER — Foreign key → boards.board_id — NOT NULL
users (Untitled)
- user_id — NUMBER — Primary key — NOT NULL
- username — VARCHAR2(50) — NOT NULL
- email — VARCHAR2(100) — NOT NULL
- password — VARCHAR2(255) — NOT NULL
- created_at — DATE — NOT NULL