AEWOL Database ERD - Core Center
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