MOA

Tables (21)

interests

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME

maker_keyword_links

  • maker_id — VARCHAR(64) — Primary key — NOT NULL
  • keyword_id — INT — Primary key — NOT NULL
  • created_at — DATETIME

maker_keywords

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME

maker_settlement_profiles

  • id — INT
  • maker_id — VARCHAR(64) — NOT NULL
  • bank_name — VARCHAR(100)
  • account_number — VARCHAR(64)
  • account_holder — VARCHAR(100)
  • created_at — DATETIME
  • updated_at — DATETIME

maker_wallets

  • id — BIGINT
  • maker_id — VARCHAR(64) — NOT NULL
  • available_balance — BIGINT — NOT NULL
  • pending_balance — BIGINT — NOT NULL
  • total_earned — BIGINT — NOT NULL
  • total_withdrawn — BIGINT — NOT NULL
  • updated_at — DATETIME

makers

  • id — VARCHAR(64)
  • owner_user_id — VARCHAR(64) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • business_number — VARCHAR(50)
  • business_name — VARCHAR(255)
  • established_at — DATE
  • industry_type — VARCHAR(100)
  • representative — VARCHAR(100)
  • location — VARCHAR(255)
  • product_intro — TEXT
  • core_competencies — TEXT
  • image_url — VARCHAR(255)
  • contact_email — VARCHAR(255)
  • contact_phone — VARCHAR(50)
  • tech_stack_json — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

order_items

  • id — BIGINT
  • order_id — BIGINT — NOT NULL
  • reward_id — BIGINT — NOT NULL
  • reward_name — VARCHAR(255)
  • reward_price — BIGINT
  • quantity — INT
  • subtotal — BIGINT

orders

  • id — BIGINT
  • order_id — VARCHAR(64) — NOT NULL
  • user_id — VARCHAR(64)
  • project_id — BIGINT
  • total_amount — BIGINT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • order_name — VARCHAR(255)
  • delivery_status — VARCHAR(30)
  • delivery_started_at — DATETIME
  • delivery_completed_at — DATETIME
  • confirmed_at — DATETIME
  • created_at — DATETIME

payments

  • id — BIGINT
  • order_id — BIGINT — NOT NULL
  • payment_key — VARCHAR(64) — NOT NULL
  • amount — BIGINT — NOT NULL
  • method — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • approved_at — DATETIME
  • card_masked — VARCHAR(64)
  • receipt_url — VARCHAR(255)

platform_wallet_transactions

  • id — BIGINT
  • wallet_id — BIGINT — NOT NULL
  • type — VARCHAR(40) — NOT NULL
  • amount — BIGINT — NOT NULL
  • balance_after — BIGINT — NOT NULL
  • related_project_id — BIGINT
  • related_settlement_id — BIGINT
  • description — VARCHAR(255)
  • created_at — DATETIME

platform_wallets

  • id — BIGINT
  • total_balance — BIGINT — NOT NULL
  • total_project_deposit — BIGINT — NOT NULL
  • total_maker_payout — BIGINT — NOT NULL
  • total_platform_fee — BIGINT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

project_wallet_transactions

  • id — BIGINT
  • project_wallet_id — BIGINT — NOT NULL
  • type — VARCHAR(40) — NOT NULL
  • amount — BIGINT — NOT NULL
  • balance_after — BIGINT — NOT NULL
  • order_id — BIGINT
  • settlement_id — BIGINT
  • description — VARCHAR(255)
  • created_at — DATETIME

project_wallets

  • id — BIGINT
  • project_id — BIGINT — NOT NULL
  • escrow_balance — BIGINT — NOT NULL
  • pending_release — BIGINT — NOT NULL
  • released_total — BIGINT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • updated_at — DATETIME

projects

  • id — BIGINT
  • maker_id — VARCHAR(64) — NOT NULL
  • title — VARCHAR(255)
  • summary — TEXT
  • category — VARCHAR(100)
  • story_markdown — TEXT
  • cover_image_url — VARCHAR(255)
  • cover_gallery_json — TEXT
  • goal_amount — DECIMAL(18,2)
  • start_date — DATE
  • end_date — DATE
  • project_lifecycle_status — VARCHAR(30) — NOT NULL
  • project_review_status — VARCHAR(30) — NOT NULL
  • tags_json — TEXT
  • created_at — DATETIME
  • request_at — DATETIME
  • updated_at — DATETIME
  • approved_at — DATETIME
  • rejected_at — DATETIME
  • rejected_reason — TEXT
  • live_started_at — DATETIME
  • live_ended_at — DATETIME

refunds

  • id — BIGINT
  • payment_id — BIGINT — NOT NULL
  • amount — BIGINT — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • reason — VARCHAR(255)
  • created_at — DATETIME

rewards

  • id — BIGINT
  • project_id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT
  • price — DECIMAL(18,2) — NOT NULL
  • limit_qty — INT
  • est_shipping_month — VARCHAR(20)
  • available — TINYINT(1) — NOT NULL
  • option_config_json — TEXT
  • display_order — INT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

settlements

  • id — BIGINT
  • project_id — BIGINT — NOT NULL
  • maker_id — VARCHAR(64) — NOT NULL
  • total_order_amount — BIGINT — NOT NULL
  • toss_fee_amount — BIGINT — NOT NULL
  • platform_fee_amount — BIGINT — NOT NULL
  • net_amount — BIGINT — NOT NULL
  • first_payment_amount — BIGINT — NOT NULL
  • first_payment_status — VARCHAR(30) — NOT NULL
  • first_payment_at — DATETIME
  • final_payment_amount — BIGINT — NOT NULL
  • final_payment_status — VARCHAR(30) — NOT NULL
  • final_payment_at — DATETIME
  • status — VARCHAR(30) — NOT NULL
  • retry_count — INT
  • created_at — DATETIME

supporter_interests

  • supporter_user_id — VARCHAR(64) — Primary key — NOT NULL
  • interest_id — INT — Primary key — NOT NULL
  • created_at — DATETIME

supporter_profiles

  • user_id — VARCHAR(64)
  • display_name — VARCHAR(100)
  • bio — TEXT
  • image_url — VARCHAR(255)
  • phone — VARCHAR(30)
  • address — VARCHAR(255)
  • postal_code — VARCHAR(20)
  • created_at — DATETIME
  • updated_at — DATETIME

users

  • id — VARCHAR(64)
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(255)
  • image_url — VARCHAR(255)
  • provider — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • created_at — DATETIME

wallet_transactions

  • id — BIGINT
  • wallet_id — BIGINT — NOT NULL
  • type — VARCHAR(40) — NOT NULL
  • amount — BIGINT — NOT NULL
  • balance_after — BIGINT — NOT NULL
  • settlement_id — BIGINT
  • description — VARCHAR(255)
  • created_at — DATETIME