mogak

Tables (17)

badge

  • badge_id — BIGINT — Primary key — NOT NULL
  • condition_value — INT
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(200) — NOT NULL
  • icon_url — VARCHAR(255) — NOT NULL
  • badge_type — ENUM('COUNT', 'DURATION', 'OFFICIAL') — NOT NULL

challenge

  • challenge_id — BIGINT — Primary key — NOT NULL
  • end_date — DATE
  • official — BIT(1)
  • start_date — DATE
  • total_participants — INT
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • description — VARCHAR(255)
  • name — VARCHAR(255) — NOT NULL
  • status — ENUM('BEFORE', 'COMPLETED', 'ONGOING')
  • INDEX — `idx_challenge_name`
  • INDEX — `idx_challenge_official_status`
  • INDEX — `idx_challenge_created_at`

challenge_article

  • challenge_article_id — BIGINT — Primary key — NOT NULL
  • challenge_id — BIGINT — Foreign key → challenge.challenge_id
  • created_at — DATETIME(6)
  • member_id — BIGINT — Foreign key → member.member_id
  • modified_at — DATETIME(6)
  • thumbnail_url — VARCHAR(1000)
  • description — VARCHAR(255)
  • INDEX — `FKb8ney7mljfwjag2dl7q5m2rwj`
  • INDEX — `FKlho6675nlvlrb6rxso9bdssn7`

challenge_badge

  • id — BIGINT — Primary key — NOT NULL
  • badge_entity_badge_id — BIGINT — Foreign key → badge.badge_id
  • challenge_entity_challenge_id — BIGINT — Foreign key → challenge.challenge_id

challenge_image

  • challenge_image_id — BIGINT — Primary key — NOT NULL
  • challenge_article_id — BIGINT — Foreign key → challenge_article.challenge_article_id
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • image_url — VARCHAR(1000)
  • INDEX — `FKrvmu4psdhwan8btvabuh36a95`

challenge_member

  • challenge_member_id — BIGINT — Primary key — NOT NULL
  • survivor — BIT(1)
  • challenge_id — BIGINT — Foreign key → challenge.challenge_id
  • created_at — DATETIME(6)
  • member_id — BIGINT — Foreign key → member.member_id
  • modified_at — DATETIME(6)
  • INDEX — `idx_challenge_member_challenge_id`
  • INDEX — `idx_challenge_member_member_id`

challenge_owner

  • challenge_owner_id — BIGINT — Primary key — NOT NULL
  • challenge_id — BIGINT — Foreign key → challenge.challenge_id
  • created_at — DATETIME(6)
  • member_id — BIGINT — Foreign key → member.member_id
  • modified_at — DATETIME(6)
  • INDEX — `FK2ns9dbxvtqsapdaqcbrxqj62t`

chat

  • chat_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT
  • mogak_zone_id — BIGINT
  • save_time — DATETIME(6)
  • image_url — VARCHAR(255)
  • message — VARCHAR(255)
  • nickname — VARCHAR(255)

member

  • member_id — BIGINT — Primary key — NOT NULL
  • show_badge — BIT(1)
  • withdrawn — BIT(1)
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • image_path — VARCHAR(1024)
  • email — VARCHAR(255)
  • name — VARCHAR(255)
  • nickname — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • provider — VARCHAR(255) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • INDEX — `idx_provider_providerId`

member_badge

  • member_badge_id — BIGINT — Primary key — NOT NULL
  • badge_id — BIGINT — Foreign key → badge.badge_id — NOT NULL
  • challenge_id — BIGINT
  • created_at — DATETIME(6)
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • modified_at — DATETIME(6)
  • INDEX — `FK39altb7wsyx1gyx3m492wf2kb`
  • INDEX — `FKc9u2tetajy4dohtwi9dnpas07`

mogak_zone

  • zone_id — BIGINT — Primary key — NOT NULL
  • chat_enabled — BIT(1)
  • max_capacity — INT
  • participant_num — INT
  • password_required — BIT(1)
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • image_url — VARCHAR(1024)
  • name — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • INDEX — `idx_mogakzone_createdat`
  • INDEX — `idx_mogakzone_participantnum`
  • INDEX — `idx_zone_summary_covering`

tag

  • tag_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • name — VARCHAR(255)

zone_member

  • zone_member_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • member_id — BIGINT — Foreign key → member.member_id
  • modified_at — DATETIME(6)
  • zone_id — BIGINT — Foreign key → mogak_zone.zone_id
  • status — ENUM('OFFLINE', 'RESTING', 'STUDYING')
  • INDEX — `idx_zone_member_zoneid`
  • INDEX — `idx_zone_member_memberid`

zone_owner

  • zone_owner_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • member_id — BIGINT — Foreign key → member.member_id
  • modified_at — DATETIME(6)
  • zone_id — BIGINT — Foreign key → mogak_zone.zone_id
  • INDEX — `FK2oh834idtflvtx6fem0iy5wnr`

zone_summary

  • id — BIGINT — Primary key — NOT NULL
  • participant_num — INT — NOT NULL
  • password_required — BIT(1) — NOT NULL
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • mogak_zone_id — BIGINT
  • name — VARCHAR(255)
  • INDEX — `idx_zone_summary_created_at_id`
  • INDEX — `idx_zone_summary_participant_id`
  • INDEX — `idx_zone_summary_covering`

zone_summary_member_image

  • id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT
  • mogak_zone_id — BIGINT
  • image_url — VARCHAR(255)

zone_tag

  • zone_tag_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • tag_id — BIGINT — Foreign key → tag.tag_id
  • zone_id — BIGINT — Foreign key → mogak_zone.zone_id
  • INDEX — `idx_zone_tag_zoneid`
  • INDEX — `idx_zone_tag_tagid`