#
# TABLE STRUCTURE FOR: work_sheet
#

DROP TABLE IF EXISTS `work_sheet`;

CREATE TABLE `work_sheet` (
  `worksheet_id` varchar(255) NOT NULL COMMENT 'Work Sheet ID',
  `tasktransaction_id` varchar(100) NOT NULL,
  `staff_id` int(11) DEFAULT NULL COMMENT 'Staff ID',
  `project_id` int(11) DEFAULT NULL COMMENT 'Project ID',
  `worktype_id` int(11) DEFAULT NULL COMMENT 'Work Type ID',
  `ws_sequence_num` int(100) NOT NULL,
  `date` date NOT NULL COMMENT 'Task Date',
  `time_slot_start` decimal(5,2) DEFAULT NULL COMMENT 'Time Slot Start',
  `time_slot_end` decimal(5,2) DEFAULT NULL COMMENT 'Time Slot End',
  `total_time` decimal(5,2) DEFAULT NULL COMMENT 'Total Hours Spent',
  `comments` longtext COMMENT 'Staff Comment',
  `percentage_completed` int(50) NOT NULL COMMENT 'Percentage Completed ',
  `added_on` datetime DEFAULT NULL COMMENT 'Date Added',
  `updated_on` datetime DEFAULT NULL COMMENT 'Date Updated',
  `approved_by` int(11) DEFAULT NULL COMMENT 'Approved By',
  `approved_on` datetime DEFAULT NULL COMMENT 'Date Approved',
  `approval_status` varchar(45) DEFAULT NULL COMMENT 'Approval Status',
  `entry_status` varchar(45) DEFAULT NULL COMMENT 'Entry Status',
  `authorization` varchar(45) DEFAULT NULL COMMENT 'Authorization',
  `reason_delay_entry` varchar(255) DEFAULT NULL COMMENT 'Reason For Delayed Entry',
  `reason_delay_aaproval` varchar(255) DEFAULT NULL COMMENT 'Reason For Delayed Approval',
  `deptid` varchar(11) DEFAULT NULL COMMENT 'Department ID',
  `wtcid` int(11) DEFAULT NULL COMMENT 'Work Type Class ID',
  `reject_reason` mediumtext,
  `start_time` time DEFAULT NULL COMMENT 'start time',
  `end_time` time DEFAULT NULL COMMENT 'End time',
  `midnight` int(1) NOT NULL DEFAULT '0' COMMENT 'midnight check',
  `manager_comment` text,
  `change_status` int(1) NOT NULL DEFAULT '0' COMMENT 'New entry=0/date change entry=1',
  `p_type` text NOT NULL COMMENT 'to identify project type for weekend or week internal/client',
  `external_manager_id` int(11) DEFAULT NULL COMMENT 'for external internship reporting manager',
  PRIMARY KEY (`worksheet_id`),
  KEY `tasktransaction_id` (`tasktransaction_id`,`staff_id`,`project_id`,`worktype_id`,`ws_sequence_num`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;