https://wiki.phpgedview.net/en/index.php?action=history&feed=atom&title=Talk%3A5.x_Roadmap%2FDB_ModelTalk:5.x Roadmap/DB Model - Revision history2026-06-03T08:52:52ZRevision history for this page on the wikiMediaWiki 1.34.2https://wiki.phpgedview.net/en/index.php?title=Talk:5.x_Roadmap/DB_Model&diff=9825&oldid=prevLaurie: 1 revision(s)2008-03-03T11:02:03Z<p>1 revision(s)</p>
<p><b>New page</b></p><div>__TOC__<br />
<br />
== Greg Roach's Suggestion ==<br />
<br />
This is the initial DB Model as suggested by [[User:Fisharebest|Greg Roach]]<br />
<br />
=== Tables ===<br />
<br />
==== tree ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the tree table is .....<br />
<br />
===== Attributes =====<br />
<br />
; tree_id<br />
: An auto incrementing unsigned integer used for the primary key<br />
<br />
==== tree_setting ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the tree_setting table is .....<br />
<br />
===== Attributes =====<br />
<br />
; tree_id<br />
: A foreign key from the tree table. It forms a composite primary key together with tree_parameter.<br />
<br />
; tree_parameter<br />
: Some description. It forms a composite primary key together with tree_id.<br />
<br />
; tree_value<br />
: Some description.<br />
<br />
==== buffer ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the buffer table is .....<br />
<br />
===== Attributes =====<br />
<br />
; buff_tree_id<br />
: Some description.<br />
<br />
; buff_id<br />
: Some description.<br />
<br />
; buff_value<br />
: Some description.<br />
<br />
==== user ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the user table is .....<br />
<br />
===== Attributes =====<br />
<br />
; user_id<br />
: Some description. Used as the primary key.<br />
<br />
; user_name<br />
: Some description. A unique index.<br />
<br />
; user_password<br />
: Some description.<br />
<br />
==== user_setting ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the user_setting table is .....<br />
<br />
===== Attributes =====<br />
<br />
; user_id<br />
: A foreign key from the user table. It forms a composite primary key together with user_parameter.<br />
<br />
; user_parameter<br />
: Some description. It forms a composite primary key together with user_id.<br />
<br />
; user_value<br />
: Some description.<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the tree table is .....<br />
<br />
===== Attributes =====<br />
<br />
; tree_id<br />
: An auto incrementing unsigned integer used for the primary key<br />
<br />
==== tree_setting ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the tree_setting table is .....<br />
<br />
===== Attributes =====<br />
<br />
; tree_id<br />
: A foreign key from the tree table. It forms a composite primary key together with tree_parameter.<br />
<br />
; tree_parameter<br />
: Some description. It forms a composite primary key together with tree_id.<br />
<br />
; tree_value<br />
: Some description.<br />
<br />
==== buffer ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the buffer table is .....<br />
<br />
===== Attributes =====<br />
<br />
; buff_tree_id<br />
: Some description.<br />
<br />
; buff_id<br />
: Some description.<br />
<br />
; buff_value<br />
: Some description.<br />
<br />
==== user ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the user table is .....<br />
<br />
===== Attributes =====<br />
<br />
; user_id<br />
: Some description. Used as the primary key.<br />
<br />
; user_name<br />
: Some description. A unique index.<br />
<br />
; user_password<br />
: Some description.<br />
<br />
==== edit ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the edit table is .....<br />
<br />
===== Attributes =====<br />
<br />
; edit_id<br />
: An unsigned auto incrementing integer. Used as the primary key.<br />
<br />
; edit_user_id<br />
: Some description. A foreign key from the user table.<br />
<br />
; edit_time<br />
: Some description<br />
<br />
==== record ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the record table is .....<br />
<br />
===== Attributes =====<br />
<br />
; rec_id<br />
: An unsigned auto incrementing integer. Used as the primary key.<br />
<br />
; rec_tree_id<br />
: Some description. A foreign key from the tree table.<br />
<br />
; rec_xref<br />
: Some description<br />
<br />
; rec_type<br />
: Some description<br />
<br />
==== event ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the event table is .....<br />
<br />
===== Attributes =====<br />
<br />
; evt_id<br />
: An unsigned auto incrementing integer. Used as the primary key.<br />
<br />
; evt_rec_id<br />
: A foreign key from the record table.<br />
<br />
; evt_type<br />
: Some description.<br />
<br />
; evt_value<br />
: Some description.<br />
<br />
; evt_resn<br />
: Some description.<br />
<br />
; evt_date<br />
: Some description. The [[DATE]] value.<br />
<br />
; evt_plac<br />
: Some description. The [[PLAC]] value. <br />
<br />
; evt_created<br />
: Some description. A foreign key from the edit table.<br />
<br />
; evt_deleted<br />
: Some description. A foreign key from the edit table.<br />
<br />
==== date ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the date table is .....<br />
<br />
===== Attributes =====<br />
<br />
; date_id<br />
: An unsigned auto incrementing integer. Used as the primary key.<br />
<br />
; date_evt_id<br />
: A foreign key from the event table.<br />
<br />
; date_cal<br />
: Some description.<br />
<br />
; date_day<br />
: Some description.<br />
<br />
; date_month<br />
: Some description.<br />
<br />
; date_year<br />
: Some description.<br />
<br />
; date_jd1<br />
: Some description.<br />
<br />
; date_jd2<br />
: Some description.<br />
<br />
==== name ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the name table is .....<br />
<br />
===== Attributes =====<br />
<br />
; name_id<br />
: An unsigned auto incrementing integer. Used as the primary key.<br />
<br />
; name_rec_id<br />
: A foreign key from the record table.<br />
<br />
; name_type<br />
: Some description.<br />
<br />
; name_full<br />
: Some description.<br />
<br />
; name_sort<br />
: Some description.<br />
<br />
; name_list<br />
: Some description.<br />
<br />
==== site_setting ====<br />
<br />
===== Instance Definition =====<br />
<br />
An instance in the site_setting table is .....<br />
<br />
===== Attributes =====<br />
<br />
; setting_parameter<br />
: Some description.<br />
<br />
; setting_value<br />
: Some description.<br />
<br />
== ER Diagram ==<br />
<br />
When the table descriptions have stablised and enough descriptions has been added to each attribute/table, then an ERD can be put here.</div>Laurie