CREATE TABLE person_schedule_info (
  sched_id int NOT NULL,
  person_id int NOT NULL,
  department varying NOT NULL,
  day1 int NOT NULL,
  day2 int NOT NULL,
  day3 int NOT NULL,
  day4 int NOT NULL,
  day5 int NOT NULL,
  day6 int NOT NULL,
  day7 int NOT NULL,
  day8 int NOT NULL,
  day9 int NOT NULL,
  day10 int NOT NULL,
  day11 int NOT NULL,
  day12 int NOT NULL,
  day13 int NOT NULL,
  day14 int NOT NULL,
  day15 int NOT NULL,
  day16 int NOT NULL,
  day17 int NOT NULL,
  day18 int NOT NULL,
  day19 int NOT NULL,
  day20 int NOT NULL,
  day21 int NOT NULL,
  day22 int NOT NULL,
  day23 int NOT NULL,
  day24 int NOT NULL,
  day25 int NOT NULL,
  day26 int NOT NULL,
  day27 int NOT NULL,
  day28 int NOT NULL,
  day29 int NOT NULL,
  day30 int NOT NULL
);
