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