MoEASY

Tables (37)

account_transactions

  • id — BIGINT
  • account_id — BIGINT — Foreign key → club_bank_accounts.id — NOT NULL
  • external_transaction_id — VARCHAR(100)
  • type — VARCHAR(20) — NOT NULL
  • amount — INT — NOT NULL
  • description — TEXT
  • transacted_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

album_photos

  • id — BIGINT
  • schedule_id — BIGINT — Foreign key → schedules.id — NOT NULL
  • uploaded_by — BIGINT — Foreign key → users.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • caption — TEXT
  • created_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

attendances

  • id — BIGINT
  • schedule_id — BIGINT — Foreign key → schedules.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • method — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • checked_at — DATETIME — NOT NULL

auth_tokens

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • refresh_token_hash — VARCHAR(255) — NOT NULL
  • revoked — BOOLEAN — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • revoked_at — DATETIME
  • created_at — DATETIME — NOT NULL

availability_votes

  • id — BIGINT
  • schedule_id — BIGINT — Foreign key → schedules.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • vote_date — DATE — NOT NULL
  • availability_bitmask — VARBINARY(64) — NOT NULL
  • submitted_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

blocks

  • id — BIGINT
  • blocker_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • blocked_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — DATETIME — NOT NULL

categories

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

chat_messages

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • sender_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • message_type — VARCHAR(30) — NOT NULL
  • content — TEXT
  • card_target_id — BIGINT
  • sent_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

club_bank_accounts

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • bank_name — VARCHAR(50) — NOT NULL
  • account_number_masked — VARCHAR(50) — NOT NULL
  • account_holder — VARCHAR(50) — NOT NULL
  • external_account_id — VARCHAR(100)
  • active — BOOLEAN — NOT NULL
  • linked_at — DATETIME — NOT NULL

club_invites

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • created_by — BIGINT — Foreign key → users.id — NOT NULL
  • invite_code — VARCHAR(100) — NOT NULL
  • invite_url — VARCHAR(500) — NOT NULL
  • expires_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • revoked_at — DATETIME

club_join_requests

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • message — TEXT
  • handled_by — BIGINT — Foreign key → users.id
  • requested_at — DATETIME — NOT NULL
  • handled_at — DATETIME
  • canceled_at — DATETIME

club_members

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • student_cohort — VARCHAR(30)
  • status — VARCHAR(20) — NOT NULL
  • joined_at — DATETIME — NOT NULL
  • left_at — DATETIME
  • removed_by — BIGINT — Foreign key → users.id

clubs

  • id — BIGINT
  • owner_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id
  • name — VARCHAR(100) — NOT NULL
  • topic — VARCHAR(100)
  • region — VARCHAR(100)
  • cover_image_url — VARCHAR(500)
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • closed_at — DATETIME

comments

  • id — BIGINT
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL
  • author_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → comments.id
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

faqs

  • id — BIGINT
  • question — VARCHAR(255) — NOT NULL
  • answer — TEXT — NOT NULL
  • sort_order — INT — NOT NULL
  • visible — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

fee_rules

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • fee_type — VARCHAR(30) — NOT NULL
  • amount — INT — NOT NULL
  • billing_cycle — VARCHAR(30)
  • due_day — INT
  • active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inquiries

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • content — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inquiry_replies

  • id — BIGINT
  • inquiry_id — BIGINT — Foreign key → inquiries.id — NOT NULL
  • responder_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

notification_settings

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • push_enabled — BOOLEAN — NOT NULL
  • notice_enabled — BOOLEAN — NOT NULL
  • schedule_enabled — BOOLEAN — NOT NULL
  • settlement_enabled — BOOLEAN — NOT NULL
  • quiet_start_time — TIME
  • quiet_end_time — TIME
  • updated_at — DATETIME — NOT NULL

notifications

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • body — TEXT
  • target_type — VARCHAR(30)
  • target_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • sent_at — DATETIME — NOT NULL
  • read_at — DATETIME

payments

  • id — BIGINT
  • settlement_item_id — BIGINT — Foreign key → settlement_items.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • amount — INT — NOT NULL
  • provider — VARCHAR(50)
  • external_payment_id — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • completed_at — DATETIME

poll_options

  • id — BIGINT
  • poll_id — BIGINT — Foreign key → polls.id — NOT NULL
  • option_text — VARCHAR(150) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

poll_votes

  • id — BIGINT
  • poll_id — BIGINT — Foreign key → polls.id — NOT NULL
  • option_id — BIGINT — Foreign key → poll_options.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • voted_at — DATETIME — NOT NULL
  • canceled_at — DATETIME

polls

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • post_id — BIGINT — Foreign key → posts.id
  • created_by — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • multiple_choice — BOOLEAN — NOT NULL
  • starts_at — DATETIME
  • ends_at — DATETIME
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

post_attachments

  • id — BIGINT
  • post_id — BIGINT — Foreign key → posts.id — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • file_type — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

posts

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • schedule_id — BIGINT — Foreign key → schedules.id
  • author_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • content — TEXT
  • pinned — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

receipts

  • id — BIGINT
  • settlement_id — BIGINT — Foreign key → settlements.id — NOT NULL
  • uploaded_by — BIGINT — Foreign key → users.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • store_name — VARCHAR(150)
  • amount — INT
  • paid_at — DATETIME
  • ocr_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

refunds

  • id — BIGINT
  • settlement_item_id — BIGINT — Foreign key → settlement_items.id — NOT NULL
  • requested_by — BIGINT — Foreign key → users.id — NOT NULL
  • amount — INT — NOT NULL
  • reason — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • refunded_at — DATETIME

reports

  • id — BIGINT
  • reporter_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • target_type — VARCHAR(30) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason — VARCHAR(100) — NOT NULL
  • detail — TEXT
  • status — VARCHAR(20) — NOT NULL
  • handled_by — BIGINT — Foreign key → users.id
  • created_at — DATETIME — NOT NULL
  • handled_at — DATETIME

reviews

  • id — BIGINT
  • schedule_id — BIGINT — Foreign key → schedules.id — NOT NULL
  • reviewer_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • target_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • rating — INT — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

role_transfer_logs

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • from_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • to_user_id — BIGINT — Foreign key → users.id — NOT NULL
  • transferred_at — DATETIME — NOT NULL

schedule_locations

  • id — BIGINT
  • schedule_id — BIGINT — Foreign key → schedules.id — NOT NULL
  • place_name — VARCHAR(150) — NOT NULL
  • address — VARCHAR(255)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • map_provider_place_id — VARCHAR(100)
  • is_confirmed — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

schedules

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • created_by — BIGINT — Foreign key → users.id — NOT NULL
  • title — VARCHAR(150) — NOT NULL
  • content — TEXT
  • notice — TEXT
  • starts_at — DATETIME
  • ends_at — DATETIME
  • status — VARCHAR(20) — NOT NULL
  • confirmed_location_id — BIGINT — Foreign key → schedule_locations.id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • canceled_at — DATETIME

settlement_items

  • id — BIGINT
  • settlement_id — BIGINT — Foreign key → settlements.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • amount — INT — NOT NULL
  • paid_amount — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • paid_at — DATETIME
  • created_at — DATETIME — NOT NULL

settlements

  • id — BIGINT
  • club_id — BIGINT — Foreign key → clubs.id — NOT NULL
  • schedule_id — BIGINT — Foreign key → schedules.id
  • created_by — BIGINT — Foreign key → users.id — NOT NULL
  • fee_rule_id — BIGINT — Foreign key → fee_rules.id
  • title — VARCHAR(150) — NOT NULL
  • settlement_type — VARCHAR(30) — NOT NULL
  • total_amount — INT — NOT NULL
  • due_at — DATETIME
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • canceled_at — DATETIME

user_categories

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • category_id — BIGINT — Foreign key → categories.id — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT
  • oauth_provider — VARCHAR(30) — NOT NULL
  • oauth_id — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • status_message — VARCHAR(255)
  • manner_score — DECIMAL(3,2)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME