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