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`