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