ERD (Entity Relationship Diagram)

핵심 도메인 관계

erDiagram
    Member ||--o{ Membership : has
    Member ||--o| PointBalance : has
    Member ||--o{ Reservation : makes
    Member ||--o{ FixedSlot : owns
    Member ||--o{ Payment : pays
    Member ||--o{ Rating : gives

    Mentor ||--o{ MentorBlock : opens
    Mentor ||--o{ Reservation : assigned
    Mentor ||--o| MentorBankAccount : has
    Mentor ||--o{ MentorPayout : earns
    Mentor ||--o{ MentorRateChange : history
    Mentor ||--o{ MentorComplaint : received

    Store ||--o{ Room : contains
    Store ||--o{ CardioSeat : contains
    Room ||--o{ RoomSlot : provides
    CardioSeat ||--o{ CardioSlot : provides

    Reservation }o--|| Session : creates
    Reservation }o--|| RoomSlot : occupies
    Reservation }o--|| CardioSlot : occupies
    Reservation }o--o| MentorBlock : matches

    Session ||--o| SessionRecord : has
    Session ||--o| Rating : rated
    Session ||--o| AIRecommendation : recommended

    Member ||--o{ DayPass : holds
    Member ||--o{ BonusCredit : holds

    Payment ||--o| Refund : refunded
    PaymentLedger ||--o{ DistributionEntry : splits

그룹별 미니 ERD

예약 흐름

flowchart LR
    Member --예약--> Reservation
    Reservation --점유--> CardioSlot
    Reservation --점유--> RoomSlot
    Reservation --매칭--> MentorBlock
    MentorBlock --소속--> Mentor
    Reservation --생성--> Session
    Session --기록--> SessionRecord
    Session --평가--> Rating
    Session --추천--> AIRecommendation

결제·분배 흐름

flowchart LR
    Member --결제--> Payment
    Payment --원장--> PaymentLedger
    PaymentLedger --escrow 7일--> Releasable
    Releasable --분배--> DistributionEntry
    DistributionEntry --멘토--> MentorPayout
    DistributionEntry --본사--> HQ
    DistributionEntry --가맹점주--> FranchiseePayout

멘토 등급·심사 흐름

stateDiagram-v2
    [*] --> 검증코스: 가입
    검증코스 --> Verified: 통과
    검증코스 --> 재시도: 불합격
    Verified --> Application: Pro 신청 (자격 충족 시)
    Application --> VideoReview: 영상 평가
    VideoReview --> Interview: 통과
    Interview --> Written: 통과
    Written --> ProCertified: 통과
    Written --> Verified: 보류
    ProCertified --> Verified: 컴플레인 3차
    Verified --> Suspended: 자격 정지

인덱스 추천

인덱스	이유
`RoomSlot(roomId, startAt)`	슬롯 조회
`MentorBlock(mentorId, startAt)`	멘토 슬롯 조회
`MentorBlock(startAt, status)`	매칭 가능 슬롯 검색
`Reservation(memberId, startAt)`	회원 예약 리스트
`Reservation(mentorId, startAt)`	멘토 일정
`Payment(memberId, paidAt)`	결제 내역
`Membership(memberId, status)`	활성 멤버십 조회
`Rating(mentorId)`	멘토 평점
`MentorPayout(mentorId, periodId)`	정산 조회

2026-05-13

초안 — 핵심 관계 + 그룹별 + 인덱스 추천