s

Tables (4)

comment

  • id — int — Primary key — NOT NULL
  • schedule_id — int — Foreign key → schedule.id — NOT NULL
  • content — varchar(300) — NOT NULL
  • username — varchar(100) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

manager

  • id — int — Primary key — NOT NULL
  • schedule_id — int — Foreign key → schedule.id — NOT NULL
  • user_id — int — Foreign key → user.id — NOT NULL

schedule

  • id — int — Primary key — NOT NULL
  • user_id — int — NOT NULL
  • title — varchar(200)
  • content — varchar(500)
  • created_at — datetime
  • updated_at — timestamp
  • weather — varchar(200)

user

  • id — int — Primary key — NOT NULL
  • username — varchar(100) — NOT NULL
  • email — varchar(200) — NOT NULL
  • password — varchar(150)
  • role — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp