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 }