HGG_HGG

Tables (7)

group

  • id — int — Primary key — NOT NULL
  • round_id — int — Foreign key → group_round.id — NOT NULL
  • leader_id — int

group_member

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • group_id — int — Foreign key → group.id — NOT NULL

group_round

  • id — int — Primary key — NOT NULL
  • created_at — date
  • open_at — date
  • close_at — date

post

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • title — varchar(300)
  • content — text
  • status — enum('open', 'close', 'done')
  • views — int
  • meeting_date — date
  • created_at — date
  • updated_at — date
  • deleted_at — date

post_image

  • id — int — Primary key — NOT NULL
  • post_id — int — Foreign key → post.id — NOT NULL
  • image_url — varchar(300)

post_like

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL
  • post_id — int — Foreign key → post.id — NOT NULL

user

  • id — int — Primary key — NOT NULL
  • email — varchar(200)
  • password — varchar(200)
  • name — varchar(100)
  • nickname — varchar(200)
  • kakao_id — varchar(200)
  • provider — varchar(200)
  • profile_image — varchar(200)
  • created_at — date — NOT NULL
  • updated_at — date
  • deleted_at — date