TodoApp

TodoAppERD

Tables (3)

Reply (reply)

  • Reply Id (reply_id) — Long — Primary key — NOT NULL
  • Conent (conent) — VARCHAR(1024)
  • User Id (user_id) — Long — Foreign key → User.User Id — NOT NULL
  • Schedule Id (schedule_id) — Long — Foreign key → Schedule.Schedule Id — NOT NULL
  • CreatedAt (createdAt) — LocalDateTime
  • ModifiedAt (modifiedAt) — LocalDateTime

Schedule (schedule)

  • Schedule Id (schedule_id) — Long — Primary key — NOT NULL
  • Title (title) — VARCHAR(50)
  • Content (content) — VARCHAR(1024)
  • IsCompleted (isCompleted) — BOOLEAN
  • IsPrivate (isPrivate) — BOOLEAN
  • User Id (user_id) — Long — Foreign key → User.User Id — NOT NULL
  • CreatedAt (createdAt) — LocalDateTime
  • ModifiedAt (modifiedAt) — LocalDateTime

User (user)

  • User Id (user_id) — Long — Primary key — NOT NULL
  • User Name (username) — VARCHAR(20)
  • Password (password) — VARCHAR(100)
  • Email (email) — VARCHAR(100)
  • Admin (admin) — BOOLEAN
  • AdminToken (adminToken) — VARCHAR(255)