sparta_scheduleapp

Tables (5)

member

  • id — int — Primary key — NOT NULL
  • email — varchar(100)
  • pwd — varchar(100)
  • username — varchar(100)
  • created_at — datetime
  • modified_at — datetime

schedules

  • schedule_id — int — Primary key — NOT NULL
  • id — long — Foreign key → users.id — NOT NULL
  • todo — varchar(45)
  • password — int
  • last_update — date

schedules (CopyOfschedules)

  • id — int — Primary key — NOT NULL
  • title — varchar(100)
  • contents — varchar(100)
  • writer — varchar(100)
  • pwd — varchar(100)
  • created_at — datetime
  • modified_at — datetime

schedules (schedule)

  • id — int — Primary key — NOT NULL
  • member_id — int — Foreign key → member.id — NOT NULL
  • title — varchar(100)
  • contents — varchar(100)
  • created_at — datetime
  • modified_at — datetime

users

  • id — long — Primary key — NOT NULL
  • name — varchar(10)