aewol0804

Tables (27)

account_verification

  • transaction_id — VARCHAR(50) — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • bank_code — VARCHAR(10) — Foreign key → bank_master.bank_code — NOT NULL
  • account_number — VARCHAR(100) — NOT NULL
  • account_holder — VARCHAR(30) — NOT NULL
  • verification_code — VARCHAR(10) — NOT NULL
  • status — VARCHAR(10) — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • verified_at — DATETIME

activity_log

  • log_id — BIGINT — Primary key — NOT NULL
  • wallet_id — BIGINT — NOT NULL
  • action_type — VARCHAR(20) — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT
  • description — VARCHAR(300)
  • created_at — DATETIME — NOT NULL

bank_master

  • bank_code — VARCHAR(10) — Primary key — NOT NULL
  • bank_name — VARCHAR(30) — NOT NULL

donation_history

  • donation_id — BIGINT — Primary key — NOT NULL
  • wallet_id — BIGINT — Foreign key → wallet.wallet_id — NOT NULL
  • organization_id — BIGINT — Foreign key → donation_organization.organization_id — NOT NULL
  • txn_id — BIGINT — Foreign key → transaction.txn_id
  • amount — DECIMAL(15,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • receipt_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME

donation_organization

  • organization_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • logo_url — VARCHAR(500)
  • category — VARCHAR(30)
  • total_donation_amount — DECIMAL(15,2) — NOT NULL
  • created_at — DATETIME — NOT NULL

emergency_hospital

  • hospital_id — BIGINT — Primary key — NOT NULL
  • external_mng_no — VARCHAR(30)
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(300) — NOT NULL
  • phone — VARCHAR(20)
  • 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
  • location — POINT

faq

  • faq_id — BIGINT — Primary key — NOT NULL
  • category — VARCHAR(30)
  • title — VARCHAR(300) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

group_purchase

  • gp_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • category — VARCHAR(20)
  • image — VARCHAR(500)
  • unit_price — DECIMAL(15,2)
  • group_price — DECIMAL(15,2)
  • delivery_method — VARCHAR(30)
  • delivery_fee — DECIMAL(15,2)
  • delivery_date — DATE
  • description — TEXT
  • target_quantity — INT — NOT NULL
  • current_quantity — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • deadline — DATETIME
  • created_at — DATETIME — NOT NULL

group_purchase_participant

  • participant_id — BIGINT — Primary key — NOT NULL
  • gp_id — BIGINT — Foreign key → group_purchase.gp_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • purchase_quantity — INT — NOT NULL
  • recipient_name — VARCHAR(30)
  • recipient_phone — VARCHAR(20)
  • zip_code — VARCHAR(10)
  • address — VARCHAR(300)
  • address_detail — VARCHAR(100)
  • payment_status — VARCHAR(10) — NOT NULL
  • paid_amount — DECIMAL(15,2)
  • paid_at — DATETIME
  • txn_id — BIGINT — Foreign key → transaction.txn_id
  • created_at — DATETIME — NOT NULL

inquiry

  • inquiry_id — BIGINT — Primary key — NOT NULL
  • inquiry_number — VARCHAR(20)
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • category — VARCHAR(30)
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • reply_email — VARCHAR(100)
  • status — VARCHAR(10) — NOT NULL
  • answer — TEXT
  • created_at — DATETIME — NOT NULL
  • answered_at — DATETIME
  • updated_at — DATETIME — NOT NULL

inquiry_attachment

  • attachment_id — BIGINT — Primary key — NOT NULL
  • inquiry_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL
  • pet_id — BIGINT — Foreign key → pet.pet_id — NOT NULL
  • member_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL
  • species — VARCHAR(10) — NOT NULL
  • company_name — VARCHAR(50) — NOT NULL
  • product_name — VARCHAR(200) — 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) — NOT NULL
  • age_subject_confidence — VARCHAR(20)
  • join_type — VARCHAR(20)
  • product_url — VARCHAR(500)
  • phone — VARCHAR(30)
  • reimbursement_structure — VARCHAR(30)
  • reimbursement_rate_pct — INT
  • reimbursement_confidence — VARCHAR(30)
  • regulatory_cap_warning — TEXT
  • remark — TEXT
  • created_at — DATETIME — NOT NULL

insurance_product_coverage

  • coverage_id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → 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)

insurance_simulation

  • sim_id — BIGINT — Primary key — NOT NULL
  • pet_id — BIGINT — Foreign key → pet.pet_id — NOT NULL
  • medical_history_codes — JSON
  • verdict — VARCHAR(20)
  • message — TEXT
  • created_at — DATETIME — NOT NULL

linked_account

  • account_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • bank_code — VARCHAR(10) — Foreign key → bank_master.bank_code — NOT NULL
  • account_number — VARCHAR(100) — NOT NULL
  • account_holder — VARCHAR(30) — NOT NULL
  • connected_id — VARCHAR(100)
  • 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 — Primary key — NOT NULL
  • region — VARCHAR(50) — NOT NULL
  • program_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • eligibility — JSON
  • apply_url — VARCHAR(500)
  • start_date — DATE
  • end_date — DATE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member

  • member_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • 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
  • email_active — VARCHAR(100)
  • zip_code — VARCHAR(10)
  • address — VARCHAR(300)
  • address_detail — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notification_setting

  • member_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → 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 — CHAR(1)
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

pet_document

  • doc_id — BIGINT — Primary key — NOT NULL
  • pet_id — BIGINT — Foreign key → 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 — Primary key — NOT NULL
  • pet_id — BIGINT — Foreign key → pet.pet_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id
  • invited_by — BIGINT — Foreign key → 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 — NOT NULL

pet_registration

  • doc_id — BIGINT — Foreign key → pet_document.doc_id — NOT NULL
  • pet_id — BIGINT — Foreign key → pet.pet_id — NOT NULL
  • reg_number — VARCHAR(30)
  • name — VARCHAR(50)
  • breed — VARCHAR(50)
  • gender — VARCHAR(10)
  • neutered — CHAR(1)
  • birth_date — VARCHAR(20)
  • rfid_cd — VARCHAR(30)
  • rfid_gubun — CHAR(1)
  • org_nm — VARCHAR(50)
  • office_tel — VARCHAR(20)
  • apr_gbn_nm — VARCHAR(10)
  • reg_tm — DATETIME
  • apr_tm — DATETIME
  • last_synced_at — DATETIME

recurring_payment

  • recurring_id — BIGINT — Primary key — NOT NULL
  • wallet_id — BIGINT — Foreign key → wallet.wallet_id — NOT NULL
  • pet_id — BIGINT — Foreign key → pet.pet_id
  • product_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(20)
  • price — DECIMAL(15,2) — NOT NULL
  • cycle_days — INT — NOT NULL
  • next_payment_date — DATE — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

transaction

  • txn_id — BIGINT — Primary key — NOT NULL
  • wallet_id — BIGINT — Foreign key → wallet.wallet_id — NOT NULL
  • counter_wallet_id — BIGINT — Foreign key → wallet.wallet_id
  • pet_id — BIGINT — Foreign key → pet.pet_id
  • recurring_id — BIGINT — Foreign key → recurring_payment.recurring_id
  • txn_type — VARCHAR(20) — NOT NULL
  • price — DECIMAL(15,2) — NOT NULL
  • category — VARCHAR(20)
  • merchant_name — VARCHAR(100)
  • merchant_category_code — VARCHAR(20)
  • memo — VARCHAR(200)
  • auto_tagged — CHAR(1)
  • txn_date — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

wallet

  • wallet_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → 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