Difference between revisions of "Talk:5.x Roadmap/DB Model"
Jump to navigation
Jump to search
m (1 revision(s)) |
(No difference)
|
Latest revision as of 12:02, 3 March 2008
Contents
Greg Roach's Suggestion
This is the initial DB Model as suggested by Greg Roach
Tables
tree
Instance Definition
An instance in the tree table is .....
Attributes
- tree_id
- An auto incrementing unsigned integer used for the primary key
tree_setting
Instance Definition
An instance in the tree_setting table is .....
Attributes
- tree_id
- A foreign key from the tree table. It forms a composite primary key together with tree_parameter.
- tree_parameter
- Some description. It forms a composite primary key together with tree_id.
- tree_value
- Some description.
buffer
Instance Definition
An instance in the buffer table is .....
Attributes
- buff_tree_id
- Some description.
- buff_id
- Some description.
- buff_value
- Some description.
user
Instance Definition
An instance in the user table is .....
Attributes
- user_id
- Some description. Used as the primary key.
- user_name
- Some description. A unique index.
- user_password
- Some description.
user_setting
Instance Definition
An instance in the user_setting table is .....
Attributes
- user_id
- A foreign key from the user table. It forms a composite primary key together with user_parameter.
- user_parameter
- Some description. It forms a composite primary key together with user_id.
- user_value
- Some description.
Instance Definition
An instance in the tree table is .....
Attributes
- tree_id
- An auto incrementing unsigned integer used for the primary key
tree_setting
Instance Definition
An instance in the tree_setting table is .....
Attributes
- tree_id
- A foreign key from the tree table. It forms a composite primary key together with tree_parameter.
- tree_parameter
- Some description. It forms a composite primary key together with tree_id.
- tree_value
- Some description.
buffer
Instance Definition
An instance in the buffer table is .....
Attributes
- buff_tree_id
- Some description.
- buff_id
- Some description.
- buff_value
- Some description.
user
Instance Definition
An instance in the user table is .....
Attributes
- user_id
- Some description. Used as the primary key.
- user_name
- Some description. A unique index.
- user_password
- Some description.
edit
Instance Definition
An instance in the edit table is .....
Attributes
- edit_id
- An unsigned auto incrementing integer. Used as the primary key.
- edit_user_id
- Some description. A foreign key from the user table.
- edit_time
- Some description
record
Instance Definition
An instance in the record table is .....
Attributes
- rec_id
- An unsigned auto incrementing integer. Used as the primary key.
- rec_tree_id
- Some description. A foreign key from the tree table.
- rec_xref
- Some description
- rec_type
- Some description
event
Instance Definition
An instance in the event table is .....
Attributes
- evt_id
- An unsigned auto incrementing integer. Used as the primary key.
- evt_rec_id
- A foreign key from the record table.
- evt_type
- Some description.
- evt_value
- Some description.
- evt_resn
- Some description.
- evt_date
- Some description. The DATE value.
- evt_plac
- Some description. The PLAC value.
- evt_created
- Some description. A foreign key from the edit table.
- evt_deleted
- Some description. A foreign key from the edit table.
date
Instance Definition
An instance in the date table is .....
Attributes
- date_id
- An unsigned auto incrementing integer. Used as the primary key.
- date_evt_id
- A foreign key from the event table.
- date_cal
- Some description.
- date_day
- Some description.
- date_month
- Some description.
- date_year
- Some description.
- date_jd1
- Some description.
- date_jd2
- Some description.
name
Instance Definition
An instance in the name table is .....
Attributes
- name_id
- An unsigned auto incrementing integer. Used as the primary key.
- name_rec_id
- A foreign key from the record table.
- name_type
- Some description.
- name_full
- Some description.
- name_sort
- Some description.
- name_list
- Some description.
site_setting
Instance Definition
An instance in the site_setting table is .....
Attributes
- setting_parameter
- Some description.
- setting_value
- Some description.
ER Diagram
When the table descriptions have stablised and enough descriptions has been added to each attribute/table, then an ERD can be put here.
