BorrowMe

flowchart LR
    Client[React Client]
    subgraph Security[Security]
      JWT[JwtAuthenticationFilter]
    end
    subgraph App[Spring Boot Application]
      C[Controller]
      S[Service]
      R[Repository]
    end
    MySQL[(MySQL)]
    S3[AWS S3]
    Client --> JWT --> C --> S --> R --> MySQL
    S --> S3

erDiagram
    USER ||--o{ PRODUCT : "소유"
    USER ||--o{ RESERVATION : "신청"
    USER ||--o{ COMMENT : "작성"
    USER ||--o{ LIKES : "좋아요"
    USER ||--o{ FOLLOW : "팔로우"
    USER ||--o{ NOTIFICATION : "수신"
    USER ||--o{ REPLY : "작성"
    PRODUCT ||--o{ RESERVATION : "예약"
    PRODUCT ||--o{ COMMENT : "댓글"
    PRODUCT ||--o{ LIKES : "좋아요"
    PRODUCT ||--o{ NOTIFICATION : "알림"
    PRODUCT ||--o{ PRODUCT_HASHTAGS : "태깅"
    HASHTAG ||--o{ PRODUCT_HASHTAGS : "태깅"
    COMMENT ||--o{ REPLY : "답글"
    COMMENT ||--o{ NOTIFICATION : "알림"
    REPLY ||--o{ NOTIFICATION : "알림"

    USER {
      bigint id PK
      varchar username UK
      varchar email UK
      varchar password_hash
      boolean email_verified
      datetime created_at
    }
    PRODUCT {
      bigint id PK
      bigint user_id FK
      varchar title
      varchar image_url
      int total_quantity
      int available_quantity
      varchar reservation_status
      datetime created_at
    }
    RESERVATION {
      bigint id PK
      bigint product_id FK
      bigint user_id FK
      int quantity
      varchar status
      datetime rental_start_date
      datetime rental_end_date
    }
    COMMENT {
      bigint id PK
      bigint product_id FK
      bigint user_id FK
      text content
      int like_count
      datetime created_at
    }
    REPLY {
      bigint id PK
      bigint comment_id FK
      bigint user_id FK
      varchar content
      datetime created_at
    }
    HASHTAG {
      bigint id PK
      varchar name UK
    }
    NOTIFICATION {
      bigint id PK
      bigint user_id FK
      bigint product_id FK
      bigint comment_id FK
      bigint reply_id FK
      varchar type
      boolean is_read
      datetime created_at
    }

sequenceDiagram
    actor Client
    participant Filter as JwtAuthenticationFilter
    participant Provider as JwtTokenProvider
    participant Context as SecurityContext
    participant Controller
    Client->>Filter: HTTP Request (Bearer token)
    Filter->>Provider: validateToken(token)
    alt 유효한 토큰
      Provider-->>Filter: true
      Filter->>Context: setAuthentication(auth)
      Filter->>Controller: 요청 전달
      Controller-->>Client: 200 OK
    else 만료 또는 무효 토큰
      Provider-->>Filter: false
      Filter-->>Client: 401 Unauthorized
    end

sequenceDiagram
    participant C as Client
    participant PC as ProductController
    participant RS as ReservationService
    participant EM as EntityManager
    participant PR as ProductRepository
    participant DB as MySQL
    C->>PC: POST /api/products/{id}/reserve
    PC->>RS: reserve(product, user, quantity)
    RS->>EM: detach(product)
    RS->>PR: findByIdForUpdate(productId)
    PR->>DB: SELECT ... FOR UPDATE
    DB-->>PR: locked product
    alt 재고 충분
      RS->>DB: availableQuantity 감소
      RS->>DB: reservation 저장
      RS-->>PC: 예약 성공
    else 재고 부족
      RS-->>PC: 예외 반환
    end