Project history

From Open Source Software Research
Jump to: navigation, search

Appears in the following schemas:

Most Recent Description

Table "sf0914.project_history"
Column Type Modifiers
project_history_id integer not null default nextval(('project_history_pk_seq'::text)::regclass)
project_task_id integer not null default 0
field_name text not null default ''::text
old_value text not null default ''::text
mod_by integer not null default 0
date integer not null default 0


Other Information About the Data

probed by Acapiluppi

Table "sf0112.project_history WHERE 1=1 limit 10"
1 3 end_date 942307200 3 942367397
2 3 priority 9 3 942367437
3 3 percent_complete 20 3 942367437
4 3 details testing this thing 3 942367437
5 3 hours 0.00 3 942367452
6 3 status_id 1 3 942367703
7 1 summary feed the snake 2 942367945
8 1 summary feed the snake to dog 5 942368000
9 1 summary feed Tim to the snake 5 942371012
11 5 percent_complete 0 5 942375932

ER diagram

Task schema.png