Talk:5.x Roadmap/DB Model
Jump to navigation
Jump to search
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.
