Tables:
_table_user{
SERIAL uid
VARCHAR(64) login
VARCHAR(64) first_name
VARCHAR(64) last_name
VARCHAR(64) email
VARCHAR(64) phone
}
_table_status{ (new, active, inactive...)
SERIAL uid
VARCHAR name
}
_table_type{ (requirement, comment, flex_code, java_code...)
SERIAL uid
VARCHAR name
}
_table_project{
SERIAL uid
BIGINT UNSIGNED parent
VARCHAR(64) name
VARCHAR(1024) description
DATE created
DATE estimated_finish
DATE actual_finish
BIGINT UNSIGNED status
}
_table_entries{
SERIAL uid
BIGINT UNSIGNED project
BIGINT UNSIGNED parent
DATE created
DATE last_update
BIGINT UNSIGNED type
BIGINT UNSIGNED status
VARCHAR(1024) overview
TEXT description
BIGINT UNSIGNED originator
BIGINT UNSIGNED current_user
DATE estimated_finish
DATE actual_finish
}
_table_history{
SERIAL uid
DATE logged
BIGINT UNSIGNED user
BIGINT UNSIGNED project
VARCHAR (1024) message
}
