test2

Tables (3)

author

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

comment

  • id — BIGINT — Primary key — NOT NULL
  • author_id — BIGINT — Foreign key → author.id
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • schedule_id — BIGINT — Foreign key → schedule.id
  • contents — VARCHAR(255) — NOT NULL

schedule

  • id — BIGINT — Primary key — NOT NULL
  • author_id — BIGINT — Foreign key → author.id
  • created_at — DATETIME(6)
  • modified_at — DATETIME(6)
  • contents — LONGTEXT
  • title — VARCHAR(255) — NOT NULL