Schedule

Tables (3)

comments

  • id — BIGINT — Primary key — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • todo_id — BIGINT — Foreign key → todos.id — NOT NULL
  • created_at — TIMESTAMP
  • modified_at — TIMESTAMP

todos

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • content — VARCHAR(255) — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP
  • modified_at — TIMESTAMP

users

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • email — VARCHAR(255)
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • modified_at — TIMESTAMP