애월

테이블 (45)

account_verification

  • transaction_id — VARCHAR(50) — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • bank_code — VARCHAR(10) — 외래 키 → bank_master.bank_code — NOT NULL
  • account_number — VARCHAR(100) — NOT NULL
  • verification_code — VARCHAR(10) — NOT NULL
  • attempt_count — INT — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • requested_at — DATETIME
  • verified_at — DATETIME

activity_log

  • log_id — BIGINT — 기본 키 — NOT NULL
  • wallet_id — BIGINT
  • pet_id — BIGINT — 외래 키 → pet.pet_id
  • action_type — VARCHAR(20) — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • description — VARCHAR(300)
  • metadata — JSON
  • created_at — DATETIME — NOT NULL

bank_master

  • bank_code — VARCHAR(10) — 기본 키 — NOT NULL
  • bank_name — VARCHAR(30) — NOT NULL

care_diary

  • diary_id — BIGINT — 기본 키 — NOT NULL
  • pet_id — BIGINT — 외래 키 → pet.pet_id — NOT NULL
  • author_member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • diary_date — DATE — NOT NULL
  • content — VARCHAR(500)
  • version — BIGINT — NOT NULL
  • visibility — VARCHAR(10) — NOT NULL
  • hidden_by_report_at — DATETIME
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

care_diary_image

  • image_id — BIGINT — 기본 키 — NOT NULL
  • diary_id — BIGINT — 외래 키 → care_diary.diary_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • public_image_key — VARCHAR(500)
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

diary_report

  • report_id — BIGINT — 기본 키 — NOT NULL
  • diary_id — BIGINT — 외래 키 → care_diary.diary_id — NOT NULL
  • reporter_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • inquiry_id — BIGINT
  • reason — VARCHAR(30) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • resolution — VARCHAR(20)
  • admin_note — VARCHAR(500)
  • resolved_by — BIGINT — 외래 키 → member.member_id
  • resolved_at — DATETIME
  • created_at — DATETIME — NOT NULL

donation_campaign

  • campaign_id — BIGINT — 기본 키 — NOT NULL
  • organization_id — BIGINT — 외래 키 → donation_organization.organization_id — NOT NULL
  • channel_id — BIGINT — 외래 키 → donation_channel.channel_id
  • title — VARCHAR(200) — NOT NULL
  • category — VARCHAR(50)
  • description — TEXT
  • image_url — VARCHAR(500)
  • target_amount — DECIMAL(15,2) — NOT NULL
  • raised_amount — DECIMAL(15,2) — NOT NULL
  • participant_count — INT — NOT NULL
  • starts_at — DATETIME
  • ends_at — DATETIME
  • is_recommended — TINYINT(1) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

donation_channel

  • channel_id — BIGINT — 기본 키 — NOT NULL
  • organization_id — BIGINT — 외래 키 → donation_organization.organization_id — NOT NULL
  • channel_type — VARCHAR(20) — NOT NULL
  • donation_type — VARCHAR(20) — NOT NULL
  • channel_name — VARCHAR(100)
  • donation_url — VARCHAR(500)
  • is_active — TINYINT(1) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

donation_history

  • donation_id — BIGINT — 기본 키 — NOT NULL
  • wallet_id — BIGINT — 외래 키 → wallet.wallet_id — NOT NULL
  • organization_id — BIGINT — 외래 키 → donation_organization.organization_id
  • campaign_id — BIGINT — 외래 키 → donation_campaign.campaign_id
  • channel_id — BIGINT — 외래 키 → donation_channel.channel_id
  • txn_id — BIGINT — 외래 키 → transaction.txn_id
  • amount — DECIMAL(15,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • recipient_name — VARCHAR(100)
  • receipt_url — VARCHAR(500)
  • idempotency_key — VARCHAR(64)
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME

donation_organization

  • organization_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • logo_url — VARCHAR(500)
  • category — VARCHAR(30)
  • total_donation_amount — DECIMAL(15,2) — NOT NULL
  • homepage_url — VARCHAR(500)
  • region — VARCHAR(100)
  • target_species — VARCHAR(20) — NOT NULL
  • activity_tags — JSON
  • is_active — TINYINT(1) — NOT NULL
  • display_order — INT — NOT NULL
  • verified_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

donation_roundup

  • roundup_id — BIGINT — 기본 키 — NOT NULL
  • source_txn_id — BIGINT — 외래 키 → transaction.txn_id — NOT NULL
  • wallet_id — BIGINT — 외래 키 → wallet.wallet_id — NOT NULL
  • saving_unit — DECIMAL(15,2) — NOT NULL
  • roundup_amount — DECIMAL(15,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • failure_reason — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME

donation_setting

  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • piggy_bank_enabled — TINYINT(1) — NOT NULL
  • saving_unit — DECIMAL(15,2) — NOT NULL
  • auto_donate_enabled — TINYINT(1) — NOT NULL
  • auto_donate_organization_id — BIGINT — 외래 키 → donation_organization.organization_id
  • auto_donate_campaign_id — BIGINT — 외래 키 → donation_campaign.campaign_id
  • last_auto_donated_year_month — CHAR(7)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

emergency_hospital

  • hospital_id — BIGINT — 기본 키 — NOT NULL
  • external_mng_no — VARCHAR(30)
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • phone — VARCHAR(50)
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)
  • is_24h — TINYINT(1) — NOT NULL
  • is_holiday_open — TINYINT(1)
  • avg_wait_minutes — INT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

faq

  • faq_id — BIGINT — 기본 키 — NOT NULL
  • category — VARCHAR(30)
  • question — VARCHAR(300) — NOT NULL
  • answer — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

gov24_public_service

  • service_id — VARCHAR(20) — 기본 키 — NOT NULL
  • service_name — VARCHAR(255) — NOT NULL
  • support_type — VARCHAR(50)
  • service_purpose_summary — TEXT
  • support_target — TEXT
  • selection_criteria — TEXT
  • support_content — TEXT
  • application_method — TEXT
  • application_deadline — VARCHAR(100)
  • detail_url — VARCHAR(500)
  • organization_code — VARCHAR(20)
  • organization_name — VARCHAR(100)
  • department_name — VARCHAR(100)
  • organization_type — VARCHAR(50)
  • user_type — VARCHAR(50)
  • service_category — VARCHAR(50)
  • reception_agency — VARCHAR(100)
  • view_count — INT
  • contact_phone — TEXT
  • source_registered_at — DATETIME
  • source_updated_at — DATETIME
  • synced_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

gov24_public_service_detail

  • service_id — VARCHAR(20) — 외래 키 → gov24_public_service.service_id — NOT NULL
  • service_purpose — LONGTEXT
  • required_documents — LONGTEXT
  • official_verified_documents — LONGTEXT
  • identity_verified_documents — LONGTEXT
  • contact_information — LONGTEXT
  • administrative_rules — LONGTEXT
  • local_regulations — LONGTEXT
  • laws — LONGTEXT
  • reception_agency_name — VARCHAR(300)
  • online_application_url — VARCHAR(1000)
  • source_updated_at — DATETIME
  • synced_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

gov24_public_service_support_condition

  • condition_code — VARCHAR(20) — 기본 키 — NOT NULL
  • service_id — VARCHAR(20) — 외래 키 → gov24_public_service.service_id — NOT NULL
  • condition_value — VARCHAR(255)
  • synced_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

group_purchase

  • gp_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • category — VARCHAR(50)
  • image — VARCHAR(500)
  • unit_price — DECIMAL(15,2)
  • group_price — DECIMAL(15,2)
  • delivery_method — VARCHAR(50)
  • delivery_fee — DECIMAL(15,2)
  • delivery_date — DATE
  • delivery_estimate_days — INT
  • description — TEXT
  • target_quantity — INT — NOT NULL
  • current_quantity — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • deadline — DATETIME
  • is_urgent_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

group_purchase_participant

  • participant_id — BIGINT — 기본 키 — NOT NULL
  • gp_id — BIGINT — 외래 키 → group_purchase.gp_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • purchase_quantity — INT — NOT NULL
  • recipient_name — VARCHAR(50)
  • recipient_phone — VARCHAR(20)
  • zip_code — VARCHAR(10)
  • address — VARCHAR(300)
  • address_detail — VARCHAR(300)
  • payment_status — VARCHAR(10) — NOT NULL
  • paid_amount — DECIMAL(15,2)
  • paid_at — DATETIME
  • txn_id — BIGINT — 외래 키 → transaction.txn_id
  • canceled_at — DATETIME
  • active_member_id — BIGINT
  • created_at — DATETIME — NOT NULL

home_insight

  • insight_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — NOT NULL
  • card_type — VARCHAR(20) — NOT NULL
  • headline — VARCHAR(255) — NOT NULL
  • body — TEXT — NOT NULL
  • cta_label — VARCHAR(50)
  • cta_path — VARCHAR(255)
  • source_digest — CHAR(64) — NOT NULL
  • fallback — CHAR(1) — NOT NULL
  • generated_at — DATETIME — NOT NULL
  • expires_at — DATETIME — NOT NULL

inquiry

  • inquiry_id — BIGINT — 기본 키 — NOT NULL
  • inquiry_number — VARCHAR(20)
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • category — VARCHAR(30)
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • reply_email — VARCHAR(100)
  • status — VARCHAR(10) — NOT NULL
  • answer — TEXT
  • created_at — DATETIME
  • answered_at — DATETIME
  • updated_at — DATETIME

inquiry_attachment

  • attachment_id — BIGINT — 기본 키 — NOT NULL
  • inquiry_id — BIGINT — 외래 키 → inquiry.inquiry_id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • file_size — BIGINT
  • created_at — DATETIME — NOT NULL

insurance_claim

  • claim_id — BIGINT — 기본 키 — NOT NULL
  • pet_id — BIGINT — 외래 키 → pet.pet_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • receipt_image_url — VARCHAR(500)
  • extracted_data — JSON
  • hospital_name — VARCHAR(100)
  • treatment_date — DATE
  • total_amount — DECIMAL(15,2)
  • claim_status — VARCHAR(20) — NOT NULL
  • claim_document_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

insurance_product

  • product_id — BIGINT — 기본 키 — NOT NULL
  • company_name — VARCHAR(50) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • premium_monthly_equiv — DECIMAL(15,2) — NOT NULL
  • premium_period — VARCHAR(10) — NOT NULL
  • join_age_min — INT
  • join_age_max — INT
  • age_basis — VARCHAR(10)
  • product_url — VARCHAR(500)
  • phone — VARCHAR(20)
  • reimbursement_structure — VARCHAR(30)
  • product_category — VARCHAR(20)
  • reimbursement_rate_note — VARCHAR(200)
  • deductible_order — VARCHAR(20)
  • created_at — DATETIME — NOT NULL

insurance_product_coverage

  • coverage_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → insurance_product.product_id — NOT NULL
  • coverage_name — VARCHAR(200) — NOT NULL
  • coverage_amount — VARCHAR(50)
  • medical_category — VARCHAR(20)

insurance_product_plan_tiers

  • tier_id — BIGINT — 기본 키 — NOT NULL
  • product_id — BIGINT — 외래 키 → insurance_product.product_id — NOT NULL
  • tier_name — VARCHAR(50) — NOT NULL
  • reimbursement_rate_pct — INT
  • is_reference_tier — TINYINT(1) — NOT NULL
  • premium_krw — DECIMAL(15,2)
  • deductible_krw — DECIMAL(15,2)
  • annual_limit_krw — DECIMAL(15,2)
  • deductible_basis — VARCHAR(20)
  • reimbursement_source_url — VARCHAR(500)
  • reimbursement_confidence — VARCHAR(30)
  • reference_tier_product_id — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

insurance_simulation

  • sim_id — BIGINT — 기본 키 — NOT NULL
  • pet_id — BIGINT — 외래 키 → pet.pet_id — NOT NULL
  • medical_history_codes — JSON
  • verdict — VARCHAR(20)
  • message — TEXT
  • assumed_annual_medical_cost_krw — DECIMAL(15,2)
  • assumption_source — VARCHAR(200)
  • representative_product_id — BIGINT
  • representative_product_label — VARCHAR(250)
  • is_user_adjusted — TINYINT(1)
  • created_at — DATETIME — NOT NULL

linked_account

  • account_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • bank_code — VARCHAR(10) — 외래 키 → bank_master.bank_code — NOT NULL
  • account_number — VARCHAR(100) — NOT NULL
  • account_number_hash — CHAR(64) — NOT NULL
  • is_primary — TINYINT(1) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

local_support_program

  • program_id — BIGINT — 기본 키 — NOT NULL
  • source_service_id — VARCHAR(20) — 외래 키 → gov24_public_service.service_id
  • source_type — VARCHAR(20) — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • program_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • summary — VARCHAR(500)
  • agency_name — VARCHAR(100)
  • benefit_summary — VARCHAR(500)
  • eligibility — JSON
  • target_species — VARCHAR(20) — NOT NULL
  • apply_url — VARCHAR(500)
  • period_text — VARCHAR(100)
  • application_method — VARCHAR(200)
  • start_date — DATE
  • end_date — DATE
  • is_active — TINYINT(1) — NOT NULL
  • source_updated_at — DATETIME
  • synced_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

local_support_program_condition

  • program_condition_id — BIGINT — 기본 키 — NOT NULL
  • program_id — BIGINT — 외래 키 → local_support_program.program_id — NOT NULL
  • condition_type — VARCHAR(30) — NOT NULL
  • operator — VARCHAR(10) — NOT NULL
  • condition_value — VARCHAR(500)
  • title — VARCHAR(200)
  • description — TEXT
  • is_required — TINYINT(1) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255)
  • simple_password — VARCHAR(255)
  • name — VARCHAR(20) — NOT NULL
  • phone — VARCHAR(20)
  • profile_img — VARCHAR(500)
  • provider — VARCHAR(10) — NOT NULL
  • provider_id — VARCHAR(100)
  • email_verified — CHAR(1) — NOT NULL
  • role — VARCHAR(10) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • withdrawn_at — DATETIME
  • zip_code — VARCHAR(10) — NOT NULL
  • address — VARCHAR(300) — NOT NULL
  • address_detail — VARCHAR(300)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member_donation_preference

  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • organization_id — BIGINT — 외래 키 → donation_organization.organization_id — NOT NULL
  • created_at — DATETIME — NOT NULL

notification

  • notification_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • message — VARCHAR(500) — NOT NULL
  • target_path — VARCHAR(500)
  • read_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

notification_setting

  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • payment_enabled — TINYINT(1) — NOT NULL
  • recurring_payment_enabled — TINYINT(1) — NOT NULL
  • family_share_enabled — TINYINT(1) — NOT NULL
  • community_enabled — TINYINT(1) — NOT NULL
  • marketing_enabled — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

pet

  • pet_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • species — VARCHAR(10) — NOT NULL
  • breed — VARCHAR(50)
  • birth_date — DATE
  • gender — VARCHAR(10)
  • weight — DECIMAL(5,2)
  • neutered — CHAR(1)
  • reg_number — VARCHAR(30)
  • medical_history — VARCHAR(500)
  • profile_img — VARCHAR(500)
  • character_img — VARCHAR(500)
  • instagram_id — VARCHAR(30)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

pet_document

  • doc_id — BIGINT — 기본 키 — NOT NULL
  • pet_id — BIGINT — 외래 키 → pet.pet_id — NOT NULL
  • doc_name — VARCHAR(100)
  • doc_type — VARCHAR(30) — NOT NULL
  • file_url — VARCHAR(255)
  • issued_date — DATE
  • created_at — DATETIME — NOT NULL

pet_group_member

  • pet_group_member_id — BIGINT — 기본 키 — NOT NULL
  • pet_id — BIGINT — 외래 키 → pet.pet_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id
  • invited_by — BIGINT — 외래 키 → member.member_id — NOT NULL
  • invite_code — VARCHAR(20)
  • role — VARCHAR(10) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • accepted_at — DATETIME
  • created_at — DATETIME

pet_registration

  • doc_id — BIGINT — 외래 키 → pet_document.doc_id — NOT NULL
  • pet_id — BIGINT — 외래 키 → pet.pet_id — NOT NULL
  • reg_number — VARCHAR(30)
  • owner_name — VARCHAR(50)
  • owner_birth — VARCHAR(8)

recurring_payment

  • recurring_id — BIGINT — 기본 키 — NOT NULL
  • wallet_id — BIGINT — 외래 키 → wallet.wallet_id — NOT NULL
  • pet_id — BIGINT — 외래 키 → pet.pet_id
  • product_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(20)
  • price — DECIMAL(15,2) — NOT NULL
  • payment_day — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

shared_access

  • access_id — BIGINT — 기본 키 — NOT NULL
  • wallet_id — BIGINT — 외래 키 → wallet.wallet_id — NOT NULL
  • pet_id — BIGINT — 외래 키 → pet.pet_id — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id
  • invited_by — BIGINT — 외래 키 → member.member_id — NOT NULL
  • invite_code — VARCHAR(36) — NOT NULL
  • recipient_type — VARCHAR(10)
  • recipient_value — VARCHAR(255)
  • role — VARCHAR(10) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • accepted_at — DATETIME
  • expires_at — DATETIME
  • revoked_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

support_program_interest

  • interest_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • program_id — BIGINT — 외래 키 → local_support_program.program_id — NOT NULL
  • pet_id — BIGINT — 외래 키 → pet.pet_id
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

toss_charge_order

  • order_id — VARCHAR(64) — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • created_at — DATETIME — NOT NULL

transaction

  • txn_id — BIGINT — 기본 키 — NOT NULL
  • wallet_id — BIGINT — 외래 키 → wallet.wallet_id — NOT NULL
  • counter_wallet_id — BIGINT — 외래 키 → wallet.wallet_id
  • pet_id — BIGINT — 외래 키 → pet.pet_id
  • recurring_id — BIGINT — 외래 키 → recurring_payment.recurring_id
  • txn_type — VARCHAR(20) — NOT NULL
  • price — DECIMAL(15,2) — NOT NULL
  • category — VARCHAR(20)
  • merchant_name — VARCHAR(100)
  • memo — VARCHAR(200)
  • auto_tagged — CHAR(1)
  • idempotency_key — VARCHAR(64)
  • payment_key — VARCHAR(200)
  • order_id — VARCHAR(200)
  • txn_date — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

wallet

  • wallet_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • wallet_type — VARCHAR(20) — NOT NULL
  • balance — DECIMAL(15,2) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

wallet_withdrawal_request

  • withdrawal_request_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
  • account_id — BIGINT — 외래 키 → linked_account.account_id — NOT NULL
  • transaction_id — BIGINT — 외래 키 → transaction.txn_id
  • idempotency_key — VARCHAR(64) — NOT NULL
  • request_hash — CHAR(64) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • wallet_balance_after — DECIMAL(15,2)
  • bank_name — VARCHAR(100)
  • account_number_masked — VARCHAR(100)
  • withdrawn_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL