news_peed

Tables (3)

board (Untitled3)

  • id — Int — Primary key — NOT NULL
  • board_title (title) — varchar
  • board_main_text (main_text) — varchar
  • board_created_at (created_at) — time_stamp
  • board_updated_at (update_at) — time_stamp
  • user_id — var_char — Foreign key → user.user_id — NOT NULL

comment (Untitled2)

  • id — Int — Primary key — NOT NULL
  • comment_text (text) — varchar
  • comment_created_at (created_at) — time_stamp
  • comment_update_at (updated_at) — time_stmap
  • board_id — Int — Foreign key → board.id — NOT NULL
  • user_id (writer) — var_char — Foreign key → user.user_id — NOT NULL

user (Untitled)

  • user_id (id) — var_char — Primary key — NOT NULL
  • user_name (name) — var_char
  • user_pw (pw) — var_char
  • user_hp (hp) — int
  • created_at — timestampz
  • updated_at — timestmapz