tasker

Tables (8)

Category (카테고리)

  • 카테고리 index (categoryId) — Primary key — NOT NULL
  • 색깔 index (colorId) — Foreign key → Color.색깔 index — NOT NULL
  • 유저 index (userId) — Foreign key → User.유저 index — NOT NULL
  • Field (name)

Color (색깔)

  • 색깔 index (colorId) — Primary key — NOT NULL
  • Field (colorBack)
  • Field2 (colorText)

Note (노트)

  • 노트 index (noteId) — Primary key — NOT NULL
  • 테스크 index (taskId) — Foreign key → Task.테스크 index — NOT NULL
  • Field (content)

Report (신고)

  • 신고 index (reportId) — Primary key — NOT NULL
  • 유저 index (userId) — Foreign key → User.유저 index — NOT NULL
  • 테스크 index (taskId) — Foreign key → Task.테스크 index — NOT NULL
  • Field (reportType) — enum

Task (테스크)

  • 테스크 index (taskId) — Primary key — NOT NULL
  • 유저 index (userId) — Foreign key → User.유저 index — NOT NULL
  • 카테고리 index (categoryId) — Foreign key → Category.카테고리 index — NOT NULL
  • Field (title) — String
  • Field2 (date) — String
  • Field3 (timeStart) — String
  • Field4 (timeEnd) — String
  • Field (status) — Integer

TaskBook (테스크북)

  • 테스크북 index (taskBookId) — Primary key — NOT NULL
  • 카테고리 index (categoryId) — Foreign key → Category.카테고리 index — NOT NULL
  • 주제 (topic) — enum
  • 제목 (title)
  • 소개 (introduction)

User (유저)

  • 유저 index (userId) — Primary key — NOT NULL
  • Field (phoneNumber)
  • Field (profileIntro)
  • Field (profileImg)
  • Field (phoneNumberSha)

UserRefreshToken (Untitled)

  • Key (userRefreshTokenId) — Primary key — NOT NULL
  • 유저 index (userId) — Foreign key → User.유저 index — NOT NULL
  • Field (userRefreshToken)