AEWOL Database ERD

Tables (45)

account_verification

  • transaction_id — VARCHAR(50) — Primary key — NOT NULL — 앱에서 생성하는 형식 그대로 유지 (예: TX20260722001)
  • 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 — CODEF inPrintType=1 랜덤 한글 4자
  • status — VARCHAR(10) — NOT NULL — PENDING / VERIFIED / USED
  • requested_at — DATETIME — NOT NULL
  • verified_at — DATETIME

activity_log

  • log_id — VARCHAR(36) — Primary key — NOT NULL
  • wallet_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

care_diary

  • diary_id — BIGINT — Primary key — NOT NULL
  • pet_id — BIGINT — Foreign key → pet.pet_id — NOT NULL
  • author_member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 작성자 (소유자 또는 공동육아 구성원)
  • diary_date — DATE — NOT NULL — 기록 대상 날짜
  • content — VARCHAR(500) — 토막글
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

care_diary_image

  • image_id — BIGINT — Primary key — NOT NULL
  • diary_id — BIGINT — Foreign key → care_diary.diary_id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

diary_report

  • report_id — BIGINT — Primary key — NOT NULL
  • diary_id — BIGINT — Foreign key → care_diary.diary_id — NOT NULL
  • reporter_id — BIGINT — Foreign key → member.member_id — NOT NULL — 신고한 회원
  • inquiry_id — BIGINT — 연결된 고객센터 문의
  • reason — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL

donation_campaign

  • campaign_id — BIGINT — Primary key — NOT NULL
  • organization_id — BIGINT — Foreign key → donation_organization.organization_id — NOT NULL
  • channel_id — BIGINT — Foreign key → donation_channel.channel_id
  • title — VARCHAR(200) — NOT NULL
  • category — VARCHAR(30) — 유기동물 / 환경 / 기타
  • description — TEXT
  • image_url — VARCHAR(500)
  • target_amount — DECIMAL(15, 2)
  • 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 — Primary key — NOT NULL
  • organization_id — BIGINT — Foreign key → donation_organization.organization_id — NOT NULL
  • channel_type — VARCHAR(20) — NOT NULL — EXTERNAL_LINK / IN_APP
  • donation_type — VARCHAR(20) — NOT NULL — REGULAR / ONE_TIME / GOODS
  • channel_name — VARCHAR(100) — NOT NULL
  • donation_url — VARCHAR(1000) — EXTERNAL_LINK일 때 외부 기부 페이지
  • 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 — VARCHAR(36) — Primary key — NOT NULL
  • wallet_id — VARCHAR(36) — Foreign key → wallet.wallet_id — NOT NULL — 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)
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME — 상태가 COMPLETED로 바뀐 실제 완료 시각

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

donation_roundup

  • roundup_id — BIGINT — Primary key — NOT NULL
  • source_txn_id — BIGINT — Foreign key → transaction.txn_id — NOT NULL — 적립을 발생시킨 원본 결제 거래
  • wallet_id — BIGINT — Foreign key → wallet.wallet_id — NOT NULL — 적립 대상 DONATION 지갑
  • saving_unit — DECIMAL(15, 2) — NOT NULL
  • roundup_amount — DECIMAL(15, 2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING / COMPLETED / FAILED / SKIPPED
  • failure_reason — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • completed_at — DATETIME

donation_setting

  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • piggy_bank_enabled — TINYINT(1) — NOT NULL — 잔돈 적립 사용 여부
  • saving_unit — DECIMAL(15, 2) — NOT NULL — 올림 단위 (10 / 100 / 1000)
  • auto_donate_enabled — TINYINT(1) — NOT NULL — 월말 자동 기부
  • auto_donate_organization_id — BIGINT — Foreign key → donation_organization.organization_id
  • auto_donate_campaign_id — BIGINT — Foreign key → donation_campaign.campaign_id
  • last_auto_donated_year_month — CHAR(7) — YYYY-MM. 월 1회 배치 멱등성 보장용
  • created_at — DATETIME — NOT NULL
  • updated_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
  • created_at — DATETIME — NOT NULL
  • 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

gov24_public_service

  • service_id — VARCHAR(20) — Primary key — NOT NULL — 정부24 공공서비스 ID (외부 자연키)
  • support_type — VARCHAR(100) — 지원유형
  • service_name — VARCHAR(300) — NOT NULL — 서비스명
  • service_purpose_summary — TEXT — 서비스목적요약
  • support_target — TEXT — 지원대상
  • selection_criteria — TEXT — 선정기준
  • support_content — TEXT — 지원내용
  • application_method — TEXT — 신청방법
  • application_deadline — VARCHAR(500) — 신청기한 원문
  • detail_url — VARCHAR(1000) — 상세조회URL
  • organization_code — VARCHAR(30) — 소관기관코드
  • organization_name — VARCHAR(200) — 소관기관명
  • department_name — VARCHAR(200) — 부서명
  • view_count — INT — 조회수
  • organization_type — VARCHAR(100) — 소관기관유형
  • user_type — VARCHAR(100) — 사용자구분
  • service_category — VARCHAR(100) — 서비스분야
  • reception_agency — VARCHAR(200) — 접수기관
  • contact_phone — VARCHAR(200) — 전화문의
  • source_registered_at — DATETIME — 공공데이터 등록일시
  • source_updated_at — DATETIME — 공공데이터 수정일시
  • synced_at — DATETIME — NOT NULL — 마지막 API 동기화 시각
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

gov24_public_service_detail

  • service_id — VARCHAR(20) — Foreign key → gov24_public_service.service_id — NOT NULL — 정부24 공공서비스 ID
  • service_purpose — LONGTEXT — 서비스목적
  • required_documents — LONGTEXT — 구비서류
  • official_verified_documents — LONGTEXT — 공무원확인 구비서류
  • identity_verified_documents — LONGTEXT — 본인확인 필요 구비서류
  • reception_agency_name — VARCHAR(300) — 접수기관명
  • contact_information — LONGTEXT — 문의처
  • online_application_url — VARCHAR(1000) — 온라인신청사이트URL
  • administrative_rules — LONGTEXT — 행정규칙
  • local_regulations — LONGTEXT — 자치법규
  • laws — LONGTEXT — 법령
  • source_updated_at — DATETIME — 공공데이터 수정일시
  • synced_at — DATETIME — NOT NULL — 마지막 API 동기화 시각
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

gov24_public_service_support_condition

  • condition_code — VARCHAR(20) — Primary key — NOT NULL — 지원조건 코드
  • service_id — VARCHAR(20) — Foreign key → gov24_public_service.service_id — NOT NULL — 정부24 공공서비스 ID
  • condition_value — VARCHAR(255) — NOT NULL — 지원조건 값
  • synced_at — DATETIME — NOT NULL — 마지막 API 동기화 시각
  • 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
  • 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 — PENDING / PAID / CANCELLED
  • paid_amount — DECIMAL(15, 2)
  • paid_at — DATETIME
  • txn_id — VARCHAR(36) — Foreign key → transaction.txn_id — 이 참여자의 결제가 만든 실제 자금 이동 거래
  • created_at — DATETIME — NOT NULL

home_insight

  • insight_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — NOT NULL
  • card_type — VARCHAR(20) — NOT NULL — SUPPORT / SPENDING / CARE / DONATION
  • headline — VARCHAR(100) — NOT NULL — 숫자가 들어가는 제목. 데이터로 직접 만든다
  • body — VARCHAR(300) — NOT NULL — LLM이 생성한 2문장
  • cta_label — VARCHAR(30)
  • cta_path — VARCHAR(100)
  • source_digest — VARCHAR(64)
  • fallback — CHAR(1) — NOT NULL
  • generated_at — DATETIME — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_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 — 청구서 작성자. 공동양육 시 pet.member_id(소유자)와 다를 수 있어 유지
  • 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_product

  • product_id — VARCHAR(36) — Primary key — NOT NULL
  • species — VARCHAR(10) — NOT NULL — DOG / CAT
  • 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 — MONTHLY / ANNUAL / UNKNOWN
  • join_age_min — INT
  • join_age_max — INT
  • age_basis — VARCHAR(10) — NOT NULL — PET / OWNER
  • age_subject_confidence — VARCHAR(20) — CONFIRMED / ASSUMED / UNKNOWN_DEFAULT
  • join_type — VARCHAR(20)
  • product_url — VARCHAR(500)
  • phone — VARCHAR(30)
  • reimbursement_structure — VARCHAR(30) — FIXED / BUNDLED_TIER / INDEPENDENT_SELECTABLE / UNKNOWN
  • reimbursement_rate_pct — INT
  • reimbursement_confidence — VARCHAR(30) — CONFIRMED_OWN_COVERAGE_NAME / ASSUMED_FROM_RESEARCH / UNVERIFIED
  • regulatory_cap_warning — TEXT
  • remark — TEXT
  • created_at — DATETIME — NOT NULL

insurance_product_coverage

  • coverage_id — VARCHAR(36) — Primary key — NOT NULL
  • product_id — VARCHAR(36) — Foreign key → insurance_product.product_id — NOT NULL
  • coverage_name — VARCHAR(200) — NOT NULL
  • coverage_amount — VARCHAR(50)
  • medical_category — VARCHAR(20) — DENTAL / URINARY / FOREIGN_BODY / JOINT / SKIN / DIGESTIVE / OTHER / NONE

insurance_product_plan_tiers

  • tier_id — VARCHAR(36) — Primary key — NOT NULL
  • product_id — VARCHAR(36) — 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 — 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
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

local_support_program_condition

  • program_condition_id — BIGINT — Primary key — NOT NULL
  • program_id — BIGINT — Foreign key → local_support_program.program_id — NOT NULL
  • condition_type — VARCHAR(30) — NOT NULL — REGION / PET_SPECIES / PET_AGE_MONTHS / NEUTERED / PET_REGISTERED / MANUAL
  • operator — VARCHAR(10) — NOT NULL — EQ / IN / LTE / GTE / BETWEEN / MANUAL
  • condition_value — VARCHAR(500)
  • title — VARCHAR(200) — NOT NULL — 화면 표시용 조건명
  • description — VARCHAR(1000) — 화면 표시용 설명
  • is_required — TINYINT(1) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • 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) — 활성 회원만 유일 — 탈퇴 후 동일 이메일 재가입 허용용
  • zip_code — VARCHAR(10)
  • address — VARCHAR(300)
  • address_detail — VARCHAR(100) — 상세주소
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member_donation_preference

  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • organization_id — BIGINT — Foreign key → donation_organization.organization_id — NOT NULL
  • created_at — DATETIME — NOT NULL

notification

  • notification_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → 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 — 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 — 마케팅 정보 수신
  • created_at — DATETIME — 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

pet_registration

  • doc_id — BIGINT — Foreign key → pet_document.doc_id — NOT NULL — pet_document.doc_id 1:1 참조
  • pet_id — BIGINT — Foreign key → pet.pet_id — NOT NULL
  • reg_number — VARCHAR(30) — pet.reg_number와 동일명 <- dogRegNo
  • name — VARCHAR(50) — pet.name과 동일명 <- dogNm
  • breed — VARCHAR(50) — pet.breed와 동일명 <- kindNm
  • gender — VARCHAR(10) — pet.gender와 동일명 <- sexNm
  • neutered — CHAR(1) — pet.neutered와 동일명 <- neuterYn
  • birth_date — VARCHAR(20) — pet.birth_date와 동일명, 포맷 미확정이라 String 유지 <- birthDt
  • rfid_cd — VARCHAR(30) — pet에 없음 <- rfidCd
  • rfid_gubun — CHAR(1) — 등록칩 구분 Y:내장 M:외장 N:인식표 <- rfidGubun
  • org_nm — VARCHAR(50) — 관할기관 <- orgNm
  • office_tel — VARCHAR(20) — 관할기관 연락처 <- officeTel
  • apr_gbn_nm — VARCHAR(10) — 승인여부 <- aprGbnNm
  • reg_tm — DATETIME — 등록일시 <- regTm
  • apr_tm — DATETIME — 승인일시 <- aprTm
  • last_synced_at — DATETIME — 자체 재동기화 시각

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

shared_access

  • access_id — BIGINT — Primary key — NOT NULL
  • wallet_id — BIGINT — Foreign key → wallet.wallet_id — NOT NULL — 공동육아 대상 지갑 (소유자의 MAIN 지갑)
  • pet_id — BIGINT — Foreign key → pet.pet_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — 초대 수락 전 NULL, 수락 후 회원 ID
  • invited_by — BIGINT — Foreign key → member.member_id — NOT NULL
  • invite_code — VARCHAR(36) — NOT NULL — 초대 링크/코드 (앱 생성 UUID)
  • recipient_type — VARCHAR(10) — EMAIL / PHONE / LINK
  • recipient_value — VARCHAR(255) — 정규화한 이메일 또는 전화번호. LINK 초대는 NULL
  • role — VARCHAR(10) — NOT NULL — VIEWER / MANAGER / ADMIN
  • status — VARCHAR(10) — NOT NULL — PENDING / ACCEPTED / REJECTED / EXPIRED / REVOKED
  • 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 — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • program_id — BIGINT — Foreign key → local_support_program.program_id — NOT NULL
  • pet_id — BIGINT — Foreign key → pet.pet_id
  • status — VARCHAR(30) — NOT NULL — INTERESTED / APPLY_PAGE_OPENED / DISMISSED
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

toss_charge_order

  • order_id — VARCHAR(64) — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • amount — DECIMAL(15, 2) — NOT NULL
  • status — VARCHAR(10) — NOT NULL — PENDING / APPROVED
  • 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

wallet_withdrawal_request

  • withdrawal_request_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • idempotency_key — VARCHAR(64) — NOT NULL
  • request_hash — CHAR(64) — NOT NULL
  • status — VARCHAR(20) — NOT NULL — PENDING / COMPLETED
  • account_id — BIGINT — Foreign key → linked_account.account_id — NOT NULL
  • transaction_id — BIGINT — Foreign key → transaction.txn_id
  • 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