Doit

Tables (5)

Goal (Untitled3)

  • id — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → User.id — NOT NULL
  • emofi (이모지)
  • title (제목) — String
  • color (색상) — String

Photo_Calendar (Untitled4)

  • id — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → User.id — NOT NULL
  • img_url (이미지 경로) — String
  • date (캘린더날짜) — date

Todo (Untitled5)

  • id — Long — Primary key — NOT NULL
  • goal_id — Long — Foreign key → Goal.id — NOT NULL
  • user_id — Long — Foreign key → Goal.user_id — NOT NULL
  • status (완료여부) — boolean
  • date (투두날짜) — timestamp

Token (Untitled)

  • id — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → User.id — NOT NULL
  • toekn (토큰) — String

User

  • id — Long — Primary key — NOT NULL
  • nickname (닉네임) — String
  • join_date (가입일) — timestamp
  • goals (등록 목표) — List