aewol_4

Tables (22)

activity_log

  • log_id — VARCHAR(36) — Primary key — NOT NULL
  • wallet_id — VARCHAR(36) — NOT NULL
  • member_id — VARCHAR(36) — NOT NULL
  • action_type — VARCHAR(20) — NOT NULL — CREATE / UPDATE / DELETE / PAYMENT / CLAIM
  • target_type — VARCHAR(20) — NOT NULL — TRANSACTION / CLAIM / PET
  • target_id — VARCHAR(36)
  • 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 — VARCHAR(36) — Primary key — NOT NULL
  • wallet_id — VARCHAR(36) — Foreign key → wallet.wallet_id — NOT NULL — 기존 pot_id. DONATION 타입 지갑 참조
  • organization_id — VARCHAR(36) — Foreign key → donation_organization.organization_id — NOT NULL
  • txn_id — VARCHAR(36) — Foreign key → transaction.txn_id — 이 기부가 만든 실제 자금 이동 거래
  • amount — DECIMAL(15, 2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — DRAFT / CONFIRMED / COMPLETED
  • receipt_url — VARCHAR(500)
  • donated_at — DATETIME — NOT NULL

donation_organization

  • organization_id — VARCHAR(36) — 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 — VARCHAR(36) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(300) — NOT NULL
  • phone — VARCHAR(20)
  • latitude — DECIMAL(10,7) — NOT NULL
  • longitude — DECIMAL(10,7) — NOT NULL
  • location — POINT — NOT NULL
  • is_24h — TINYINT(1) — NOT NULL
  • is_holiday_open — TINYINT(1) — NOT NULL
  • avg_wait_minutes — INT
  • updated_at — DATETIME — NOT NULL

faq

  • faq_id — VARCHAR(36) — 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 — VARCHAR(36) — Primary key — NOT NULL
  • member_id — VARCHAR(36) — Foreign key → member.member_id — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • category — VARCHAR(20) — 사료 / 간식 / 용품 / 기타
  • image — VARCHAR(500) — 상품 이미지 URL
  • 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 — OPEN / CLOSED / COMPLETED / CANCELLED
  • deadline — DATETIME
  • created_at — DATETIME — NOT NULL

group_purchase_participant

  • participant_id — VARCHAR(36) — Primary key — NOT NULL
  • gp_id — VARCHAR(36) — Foreign key → group_purchase.gp_id — NOT NULL
  • member_id — VARCHAR(36) — Foreign key → member.member_id — NOT NULL
  • purchase_quantity — INT — NOT NULL
  • payment_status — VARCHAR(10) — NOT NULL — PENDING / PAID / CANCELLED
  • paid_amount — DECIMAL(15, 2)
  • paid_at — DATETIME
  • joined_at — DATETIME — NOT NULL

inquiry

  • inquiry_id — VARCHAR(36) — Primary key — NOT NULL
  • member_id — VARCHAR(36) — 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 — WAITING / ANSWERED
  • answer — TEXT
  • created_at — DATETIME — NOT NULL
  • answered_at — DATETIME
  • updated_at — DATETIME — NOT NULL

inquiry_attachment

  • attachment_id — VARCHAR(36) — Primary key — NOT NULL
  • inquiry_id — VARCHAR(36) — 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 — VARCHAR(36) — Primary key — NOT NULL
  • pet_id — VARCHAR(36) — Foreign key → pet.pet_id — NOT NULL
  • member_id — VARCHAR(36) — Foreign key → member.member_id — NOT NULL
  • receipt_image_url — VARCHAR(500)
  • extracted_data — JSON — Gemini Vision 추출 결과
  • hospital_name — VARCHAR(100)
  • treatment_date — DATE
  • total_amount — DECIMAL(15, 2)
  • claim_status — VARCHAR(20) — NOT NULL — DRAFT / SUBMITTED / APPROVED / REJECTED
  • claim_document_url — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

insurance_simulation

  • sim_id — VARCHAR(36) — Primary key — NOT NULL
  • pet_id — VARCHAR(36) — Foreign key → pet.pet_id — NOT NULL
  • breed — VARCHAR(50)
  • age — INT
  • medical_history — JSON
  • estimated_annual_cost — DECIMAL(15, 2)
  • premium — DECIMAL(15, 2)
  • deductible — DECIMAL(15, 2)
  • break_even_year — INT
  • recommendation — VARCHAR(20) — RECOMMENDED / NOT_RECOMMENDED / NEUTRAL
  • created_at — DATETIME — NOT NULL

linked_account

  • account_id — VARCHAR(36) — Primary key — NOT NULL
  • member_id — VARCHAR(36) — 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) — CODEF Connected ID
  • is_primary — TINYINT(1) — NOT NULL
  • status — VARCHAR(10) — NOT NULL — ACTIVE / INACTIVE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

local_support_program

  • program_id — VARCHAR(36) — 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
  • updated_at — DATETIME — NOT NULL

member

  • member_id — VARCHAR(36) — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — 소셜 로그인 시 null
  • name — VARCHAR(20) — NOT NULL
  • phone — VARCHAR(20)
  • profile_img — VARCHAR(500)
  • provider — VARCHAR(10) — NOT NULL — KAKAO / LOCAL
  • provider_id — VARCHAR(100)
  • email_verified — CHAR(1) — NOT NULL — Y/N
  • role — VARCHAR(10) — NOT NULL — USER / ADMIN
  • is_active — TINYINT(1) — NOT NULL — 탈퇴 시 0
  • withdrawn_at — DATETIME
  • email_active — VARCHAR(100) — 활성 회원만 유일 — 탈퇴 후 동일 이메일 재가입 허용용
  • region — VARCHAR(50) — 시/군/구
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

notification_setting

  • member_id — VARCHAR(36) — 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 — 마케팅 정보 수신
  • updated_at — DATETIME — NOT NULL

pet

  • pet_id — VARCHAR(36) — Primary key — NOT NULL
  • member_id — VARCHAR(36) — Foreign key → member.member_id — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • species — VARCHAR(10) — NOT NULL — DOG / CAT / ETC
  • breed — VARCHAR(50)
  • birth_date — DATE
  • gender — VARCHAR(10)
  • weight — DECIMAL(5, 2)
  • neutered — CHAR(1) — Y/N
  • reg_number — VARCHAR(30) — 동물등록번호
  • medical_history — CHAR(1) — Y/N
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

pet_document

  • doc_id — VARCHAR(36) — Primary key — NOT NULL
  • pet_id — VARCHAR(36) — Foreign key → pet.pet_id — NOT NULL
  • doc_name — VARCHAR(100) — 문서명
  • doc_type — VARCHAR(20) — NOT NULL — REG_CERT / VACCINE / MEDICAL
  • file_url — VARCHAR(500) — NOT NULL
  • issued_date — DATE
  • created_at — DATETIME — NOT NULL

pet_group_member

  • pet_group_member_id — VARCHAR(36) — Primary key — NOT NULL
  • pet_id — VARCHAR(36) — Foreign key → pet.pet_id — NOT NULL — 공동양육 대상 반려동물
  • member_id — VARCHAR(36) — Foreign key → member.member_id — 초대받은 사용자. 초대 발송 시점엔 NULL, accept 시점에 채워짐
  • invited_by — VARCHAR(36) — Foreign key → member.member_id — NOT NULL — 초대한 사용자
  • invite_code — VARCHAR(20) — 초대 링크용 코드
  • role — VARCHAR(10) — NOT NULL — VIEWER / MANAGER / ADMIN
  • status — VARCHAR(10) — NOT NULL — PENDING / ACCEPTED / REJECTED
  • accepted_at — DATETIME
  • created_at — DATETIME — NOT NULL

recurring_payment

  • recurring_id — VARCHAR(36) — Primary key — NOT NULL
  • wallet_id — VARCHAR(36) — Foreign key → wallet.wallet_id — NOT NULL
  • pet_id — VARCHAR(36) — Foreign key → pet.pet_id
  • product_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(20) — HOSPITAL / FOOD / GROOMING / TOY / SOS / ETC
  • 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 — VARCHAR(36) — Primary key — NOT NULL
  • wallet_id — VARCHAR(36) — Foreign key → wallet.wallet_id — NOT NULL
  • counter_wallet_id — VARCHAR(36) — Foreign key → wallet.wallet_id — 내부 이체 시 상대 지갑 (TRANSFER 전용)
  • pet_id — VARCHAR(36) — Foreign key → pet.pet_id — null이면 공통 지출
  • recurring_id — VARCHAR(36) — Foreign key → recurring_payment.recurring_id — 정기결제 실행분인 경우 원본 스케줄 참조
  • txn_type — VARCHAR(20) — NOT NULL — DEPOSIT / WITHDRAW / TRANSFER / PAYMENT
  • price — DECIMAL(15, 2) — NOT NULL
  • category — VARCHAR(20) — HOSPITAL / FOOD / GROOMING / TOY / SOS / ETC
  • merchant_name — VARCHAR(100)
  • merchant_category_code — VARCHAR(20)
  • memo — VARCHAR(200)
  • auto_tagged — CHAR(1) — Y/N
  • txn_date — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

wallet

  • wallet_id — VARCHAR(36) — Primary key — NOT NULL
  • member_id — VARCHAR(36) — Foreign key → member.member_id — NOT NULL
  • wallet_type — VARCHAR(20) — NOT NULL — MAIN / DONATION
  • balance — DECIMAL(15, 2) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL