Project Tracking Tool

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
}
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: