FitLog
테이블 (8)
Rating (Untitled7)
- HIGH (Field)
- MEDIUM (Field2)
- LOW (Field3)
RefreshToken (Untitled8)
- member_id (Key2) — 외래 키 → 회원.member_id — NOT NULL
- refresh_token (Field)
- Field2
Role (Untitled3)
- ROLE_ADMIN (Field)
- ROLE_MEMBER (Field2)
Social_type (Untitled2)
- GOOGLE (Field)
- KAKAO (Field2)
- NAVER (Field3)
일기 (Untitled4)
- record_id (Key2) — 기본 키 — NOT NULL
- member_id (Key) — 외래 키 → 회원.member_id — NOT NULL
- category_id (Key3) — 외래 키 → 카테고리.category_id — NOT NULL
- title (Field)
- content (Field2)
- rating (Field5)
- record_time (Field4)
일기이미지 (Untitled6)
- image_id (Key) — 기본 키 — NOT NULL
- record_id (Key2) — 외래 키 → 일기.record_id — NOT NULL
- image_url (VARCHAR(255))
- create_time (DATETIME(6))
카테고리 (Untitled5)
- category_id (Key) — 기본 키 — NOT NULL
- title (Field)
- create_time (Field2)
- update_time (Field3)
회원 (Untitled)
- member_id (Key) — 기본 키 — NOT NULL
- email (Field2)
- nickname (VARCHAR(50))
- introduction (VARCHAR(255))
- image_url (Field4)
- role (Field5)
- social_type (Field)
- social_id (Field3)
- create_time (Field6)
- update_time (Field7)