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)