Ozibug - web based bug tracking


Below is a description of each of the tables in the Ozibug database schema. A highlighted row denotes a primary key, while * denotes a non-primary key index.

  1. ozi_attachment
  2. ozi_attachment_data
  3. ozi_bug
  4. ozi_bug_id
  5. ozi_custom_value
  6. ozi_filter
  7. ozi_filter_value
  8. ozi_link
  9. ozi_preference
  10. ozi_record
  11. ozi_reference
  12. ozi_reference_detail
  13. ozi_reference_module
  14. ozi_reference_value
  15. ozi_test
  16. ozi_text
  17. ozi_user
  18. ozi_user_module
Back to index
 
Column Name Type Size Null Description
bug_module_id varchar 16 No Module id
bug_id varchar 16 No Bug id
id varchar 16 No Attachment id
created timestamp   No Creation date/time
description varchar 128 No Description of file attachment
content_type varchar 32 No Mime type of file attachment
content_size integer   No Size of file attachment in bytes
Back to top
 
Column Name Type Size Null Description
bug_module_id varchar 16 No Module id
bug_id varchar 16 No Bug id
attachment_id varchar 16 No Attachment Id
data longVarBinary   No File attachment contents
Back to top
 
Column Name Type Size Null Description
module_id varchar 16 No Module id (reference data)
id varchar 16 No Bug id
status_id varchar 16 No Status id (reference data: open, closed, etc)
priority_id varchar 16 No Priority id (reference data: high, medium, low, etc)
description varchar 128 No Summary or short description
data_version integer   No Version of data, used for update conflicts
privacy integer   No Indicates whether the bug is private
assignee_user_id varchar 32 Yes User id assigned to the bug
previous_module_id varchar 16 Yes Previous module id, used when the bug has been moved from another module
previous_id varchar 16 Yes Previous bug id, used when the bug has been moved from another module
Back to top
 
Column Name Type Size Null Description
bug_module_id varchar 16 No Module id
next_bug_id varchar 16 No Next available bug id
Back to top
 
Column Name Type Size Null Description
bug_module_id varchar 16 No Module id
bug_id varchar 16 No Bug id
reference_name varchar 32 No Custom category name
value varchar 64 No Custom category value
Back to top
 
Column Name Type Size Null Description
user_id varchar 32 No User id
name varchar 32 No Filter name
Back to top
 
Column Name Type Size Null Description
user_id varchar 32 No User id
filter_name varchar 32 No Filter name
name varchar 32 No Filter attribute name
value varchar 1 No Filter attribute value
is_filter_value integer   No Indicates whether the value is for a filter or sorter
Back to top
 
Column Name Type Size Null Description
bug_module_id varchar 16 No Module id
bug_id varchar 16 No Bug id
link_bug_module_id * varchar 16 No Linked module id
link_bug_id * varchar 16 No Linked bug id
Back to top
 
Column Name Type Size Null Description
user_id varchar 32 No User id
name varchar 32 No Preference name
value varchar 1 Yes Preference value
Back to top
 
Column Name Type Size Null Description
bug_module_id varchar 16 No Module id
bug_id varchar 16 No Bug id
is_audit integer   No Indicates whether the record is for an audit trail or bug comment entry
id varchar 16 No Id or sort order of record within its type
created timestamp   No Creation date/time
creator_user_id varchar 32 No User id who created the record
privacy integer   No Indicates whether the record is private
Back to top
 
Column Name Type Size Null Description
name varchar 32 No Reference category name
display_name varchar 64 No Display name of reference category
input_type varchar 16 Yes Indicates the input type of the reference category, ie., fixed (default), free format or mixed
default_reference_value_id varchar 16 Yes Id of reference value to be used as the default
Back to top
 
Column Name Type Size Null Description
reference_name varchar 32 No Reference category name
reference_value_id varchar 16 No Reference value id
name varchar 32 No Name of reference value attribute
value varchar 64 No Value of reference value attribute
Back to top
 
Column Name Type Size Null Description
reference_name varchar 32 No Custom reference category name
reference_value_id * varchar 16 No Module id
Back to top
 
Column Name Type Size Null Description
reference_name varchar 32 No Reference category name
id varchar 16 No Reference value id
value varchar 64 No Reference value display name
sort_order integer   No Order that is to be used for sorting values in select boxes
active integer   No Indicates whether the reference value is active
Back to top
 
Column Name Type Size Null Description
dummy varchar 1 Yes Dummy field for validation only
Back to top
 
Column Name Type Size Null Description
bug_module_id varchar 16 No Module id
bug_id varchar 16 No Bug id
type varchar 16 No Type of text, ie., bug detail, or bug, audit or comment description
type_id varchar 16 No Id or sort order of text within its type
data longVarchar   No Text contents
Back to top
 
Column Name Type Size Null Description
id varchar 32 No User id
name varchar 64 No User name
password varchar 16 No Encrypted password
role varchar 16 No Access role
active integer   No Indicates whether a user is active
last_login timestamp   No Last login date/time
email varchar 128 Yes Email address
tmp_password varchar 16 Yes Temporary system generated encrypted password used for forgotten password requests
default_filter_name varchar 32 Yes Name of filter to be applied by default
Back to top
 
Column Name Type Size Null Description
user_id varchar 32 No User id
reference_value_id * varchar 16 No Module id
Back to top
 
Back to index
Back to Ozibug home