return7

Tables (6)

board

  • id — bigint — Primary key — NOT NULL
  • titlet (title) — varchar — NOT NULL
  • content — varchar — NOT NULL
  • view_count — int
  • up_count — int
  • down_count — int
  • selected — boolean — NOT NULL
  • selected_reply — id
  • created_at — localdatetime — NOT NULL
  • id (id2) — bigint — Foreign key → user.id

board_vote

  • id — bigint — Primary key — NOT NULL
  • votetype — varchar — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • board_id (id2) — bigint — Foreign key → board.id — NOT NULL

password_reset_token

  • id — bigint — Primary key — NOT NULL
  • experation_minutes — bigint — NOT NULL
  • token — varchar — NOT NULL
  • expired_at — localdatetime — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL

reply

  • id — bigint — Primary key — NOT NULL
  • content (conten) — varchar — NOT NULL
  • is_selected — boolean — NOT NULL
  • recommendation — int — NOT NULL
  • disrecommendation — int — NOT NULL
  • created_at — localdatetime — NOT NULL
  • board_id — bigint — Foreign key → board.id — NOT NULL
  • user_id — bigint — Foreign key → user.id
  • parent_id — bigint — Foreign key → reply.id

reply_vote

  • id — bigint — Primary key — NOT NULL
  • votedv (oted) — boolean
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • reply_id — bigint — Foreign key → reply.id — NOT NULL

user

  • id — bigint — Primary key — NOT NULL
  • loginid — varchar — NOT NULL
  • password — varchar — NOT NULL
  • authority — varchar — NOT NULL
  • created_at — localdatetime — NOT NULL
  • email — varchar