TodoDevelopProject

Tables (3)

Comment (comment)

  • Schedule ID (schedule_id) — BIGINT — Foreign key → Schedule.ID — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → Schedule.User ID — NOT NULL
  • Contents (contents) — VARCHAR
  • Created Date (created_at) — DATETIME
  • Updated Date (updated_at) — DATETIME

Schedule (schedule)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • User ID (user_id) — BIGINT — Foreign key → User.ID — NOT NULL
  • Title (title) — VARCHAR
  • Contents (contents) — VARCHAR
  • Created Date (created_at) — DATETIME
  • Updated Date (updated_at) — DATETIME

User (user)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Name (name) — VARCHAR
  • Email (email) — VARCHAR
  • Password (password) — VARCHAR
  • Created Date (created_at) — DATETIME
  • Updated Date (updated_at) — DATETIME