Database Schema
Card
- _id [internal]
- artifacts [list]
- actualcost [float]
- actualcosthistory [list of dictionaries]:
- actualcost [float]
- datetime [datetime]
- username [string]
- actualtime [float]
- actualtimehistory [list of dictionaries]:
- actualtime [float]
- datetime [datetime]
- username [string]
- blocked [string]
- blockedhistory [list of dictionaries]:
- action [string]
- datetime [datetime]
- reason [string]
- username [string]
- comments [list]
- coowner [string]
- coreviewer [string]
- creator [string]
- difficulty [string]
- estimatedcost [float]
- estimatedcosthistory [list of dictionaries]:
- datetime [datetime]
- estimatedcost [float]
- username [string]
- estimatedtime [float]
- estimatedtimehistory [list of dictionaries]:
- datetime [datetime]
- estimatedtime [float]
- username [string]
- hierarchy [string]
- history [list of dictionaries]:
- attribute [string]
- datetime [datetime]
- mode [string]
- username [string]
- value [string]
- id [string]
- lastchanged [datetime]
- lastchangedby [string]
- lasttouched [datetime]
- lasttouchedby [string]
- mode [string]
- owner [string]
- position [integer]
- priority [string]
- project [string]
- reassigncoowner [string]
- reassigncoreviewer [string]
- reassignowner [string]
- reassignreviewer [string]
- recurring [boolean]
- reopened [boolean]
- resolution [string]
- reviewer [string]
- rules [list of dictionaries]:
- components [list]
- lasttriggered [datetime]
- rule [string]
- status [string]
- usage [string]
- severity [string]
- state [string]
- statehistory [list of dictionaries]:
- datetime [datetime]
- state [string]
- username [string]
- testcases [list]
- title [string]
- type [string]
Member
- _id [internal]
- card [string]
- category [string]
- classofservice [string]
- columns [string]
- customer [string]
- displayname [string]
- filterbarcomponents [dictionary]:
- card [boolean]
- category [boolean]
- classofservice [boolean]
- columns [boolean]
- customer [boolean]
- fontsize [boolean]
- hashtag [boolean]
- iteration [boolean]
- kanbanboard [boolean]
- priority [boolean]
- project [boolean]
- release [boolean]
- severity [boolean]
- subteam [boolean]
- swimlanes [boolean]
- teammember [boolean]
- type [boolean]
- filtername [string]
- filters [list of dictionaries]:
- card [string]
- category [string]
- columns [string]
- customer [string]
- filtername [string]
- fontsize [string]
- hashtag [string]
- iteration [string]
- kanbanboard [string]
- priority [string]
- project [string]
- release [string]
- severity [string]
- subteam [string]
- teammember [string]
- type [string]
- firstname [string]
- fontsize [string]
- fullname [string]
- hashtag [string]
- iteration [string]
- kanbanboard [string]
- lastname [string]
- listview [list]
- priority [string]
- project [string]
- projects [list of dictionaries]:
- project [string]
- role [string]
- project_wips [dictionary]:
- <project> [dictionary]:
- closedwip [string]
- enforcewiplimits [boolean]
- step<step_no>buffermaxwip [integer]
- step<step_no>bufferminwip [integer]
- step<step_no>counterpartmaxwip [integer]
- step<step_no>counterpartminwip [integer]
- step<step_no>mainmaxwip [integer]
- step<step_no>mainminwip [integer]
- <project> [dictionary]:
- release [string]
- reports [list of dictionaries]:
- reportname [string]
- reportcriteria [string]
- routine_cards [list]
- severity [string]
- subteam [string]
- swimlanes [string]
- team [string]
- teammember [string]
- theme [string]
- type [string]
- username [string]
Project
- _id [internal]
- announcements [list]
- categories [list of dictionaries]:
- category [string]
- colour [string]
- creator [string]
- currency [string]
- customattributes [dictionary]
- customstates [dictionary]
- entrycriteria [dictionary]
- exitcriteria [dictionary]
- global_wips [dictionary]:
- closedwip [string]
- enforcewiplimits [boolean]
- step<step_no>sharedmaxwip [integer]
- wip_grouping [string]
- wip_limit [integer]
- wip_scope [string]
- master_host [string]
- master_port [string]
- members [list of dictionaries]:
- colour [string]
- role [string]
- username [string]
- nextcardnumber [integer]
- next_synchronisation [datetime]
- project [string]
- project_normalised [string]
- releases [list of dictionaries]:
- end_date [datetime]
- release [string]
- start_date [datetime]
- role [string]
- synchronisation_period [string]
- synchronised_upto [integer should be datetime]
- workflow [list of exactly 12 dictionaries]:
- buffercolumn [dictionary]:
- name [string]
- centric [string]
- state [string]
- description [string]
- counterpartcolumn [dictionary]:
- name [string]
- centric [string]
- state [string]
- description [string]
- maincolumn [dictionary]:
- name [string]
- centric [string]
- state [string]
- description [string]
- step [string]
- buffercolumn [dictionary]:
- workflow_index [dictionary]:
- buffer_column_centrics [list]
- buffer_column_descriptions [list]
- buffer_column_names [list]
- buffer_column_states [list]
- condensed_column_names [list]
- condensed_column_states [list]
- condensed_column_states_dict [dictionary]
- counterpart_column_centrics [list]
- counterpart_column_descriptions [list]
- counterpart_column_names [list]
- counterpart_column_states [list]
- main_column_centrics [list]
- main_column_desciptions [list]
- main_column_names [list]
- main_column_states [list]
- precedingacceptancetesting [string]
- precedingacceptancetestingaccepted [string]
- precedinganalysed [string]
- precedinganalysis [string]
- precedingclosed [string]
- precedingdefined [string]
- precedingdeveloped [string]
- precedingdevelopment [string]
- step<step_no>buffercentric [string]
- step<step_no>bufferdescription [string]
- step<step_no>buffername [string]
- step<step_no>bufferstate [string]
- step<step_no>counterpartcentric [string]
- step<step_no>counterpartdescription [string]
- step<step_no>counterpartname [string]
- step<step_no>counterpartstate [string]
- step<step_no>maincentric [string]
- step<step_no>maindescription [string]
- step<step_no>mainname [string]
- step<step_no>mainstate [string]
- steps [list]
- uncondensed_column_centrics [list]
- uncondensed_column_descriptions [list]
- uncondensed_column_names [list]
- uncondensed_column_states [list]
Session
- _id [internal]
- displayname [string]
- firstname [string]
- fullname [string]
- ip_address [string]
- lastaccess [datetime]
- lastname [string]
- recent_cards [list]
- session_id [string]
- user_agent [string]
- username [string]