thought may be useful to display the structure of the table:
IT_timesheet
Table comments: stores timesheets for employees
Field Type Null Default Comments
id bigint(20) No
hash text No
created_by bigint(20) No 0
automatic tinyint(4) No 0
employee_id bigint(20) No 0
company_id bigint(20) No 0
employer_id bigint(20) No 0
week_ending text No
time_created text No
time_modified text No
approved_by bigint(20) No 0
employee_approved tinyint(4) No 0
status tinyint(4) No 0
job_id bigint(20) No 0
timesheet_template bigint(20) No 0
extraweekending text No
extrahours float No 0
extraworkedreason bigint(20) No 0
extranotes longtext No
supervisor bigint(20) No 0
supervisorother text No
continue tinyint(4) No 0
shift bigint(20) No 0
department bigint(20) No 0
supervisor_approved tinyint(4) No 0
finish tinyint(4) No 0
feedback_given tinyint(4) No 0
paid tinyint(4) No 0
payslip text No
pay_notes mediumtext No
extra tinyint(4) No 0
grandtotal text No
preferred_temp tinyint(4) No 0
Indexes: Documentation
Keyname Type Unique Packed Field Cardinality Collation
Null Comment
PRIMARY BTREE Yes No id 1032 A
Space usage:
Type Usage
Data 142,684 B
Index 20,480 B
Total 163,164 B
Row Statistics:
Statements Value
Format dynamic
Rows 1,032
Row length ø 138
Row size ø 158 B
Next Autoindex 1,439
Creation Aug 10, 2010 at 11:59 AM
Last update Aug 10, 2010 at 11:59 AM
--
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
