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