aewol_
Tables (24)
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
breed_medical_stats
- stat_id — VARCHAR(36) — Primary key — NOT NULL
- species — VARCHAR(10) — NOT NULL — DOG / CAT
- breed — VARCHAR(50) — NOT NULL
- age_group — VARCHAR(10) — NOT NULL — PUPPY / ADULT / SENIOR
- common_diseases — JSON
- avg_annual_cost — DECIMAL(15, 2)
- source — VARCHAR(100)
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
gp_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
- 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
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
- 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 — NOT NULL
- member_id — VARCHAR(36) — Foreign key — 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_id (pet_id2) — Foreign key → pet_group_member.pet_id — 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_id — Primary key — 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이면 공통 지출
- 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 / SOS / DONATION
- balance — DECIMAL(15, 2) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL