     `customer_id`       int(4) NOT NULL,
     `promotion_id`      int(4),
     `notes`             varchar(255),
-    `start_timestamp`   timestamp NOT NULL,
-    `end_timestamp`     timestamp,
+    `start_datetime`   datetime NOT NULL,
+    `end_datetime`     datetime,
     `repeat`            boolean,
     `staff_id`          int(4),
     `resources`         varchar(255),
     `status_code`       int(4),
-    `check_in`          timestamp,
+    `check_in`          datetime,
     PRIMARY KEY         (`appointment_id`)
 ); 
 

CREATE TABLE `status` (
    `status_code` int(4) NOT NULL AUTO_INCREMENT,
    `name`        varchar(35) NOT NULL,
    PRIMARY KEY   (`status_code`)
); 



CREATE TABLE `shift` (
    `shift_id`      int(4) NOT NULL AUTO_INCREMENT,
    `shift_start`   datetime NOT NULL,
    `shift_end`     datetime,
    `staff_id`      int(4),
    PRIMARY KEY     (`shift_id`)
); 
