test

Tables (6)

Emoji

  • id — BIGINT — NOT NULL
  • content — VARCHAR(255)

Post

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • status — ENUM('active', 'closed')
  • image_url — VARCHAR(255)
  • deadline — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • view_count — INT

Reaction

  • id — BIGINT — Primary key — NOT NULL
  • emoji — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP

User

  • id — BIGINT — Primary key — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • user_id — VARCHAR(255) — NOT NULL

Vote

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • vote_option_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

VoteOption

  • id — BIGINT — NOT NULL
  • option_text — VARCHAR(255) — NOT NULL
  • vote_count — INT
  • created_at — TIMESTAMP
  • post_id — BIGINT — NOT NULL