This Help forum is for issues relates to the latest release (1.4.6). For issues related to beta or git version please use their own Help forum.
Before asking for help please read "How to request help" by clicking on that tab above here.

TOPIC: webtrees DB structure

webtrees DB structure 6 years 4 weeks ago #1

  • msaidat
  • msaidat's Avatar
Hello,

Can you please explain the main tables that are used in the MYSQL database of webtree ? and what are the general purposes for each of them ? Can you please lead me to the DB explanation website who can clarify the DB hierarchically ?

Regards,
The administrator has disabled public write access.

webtrees DB structure 6 years 4 weeks ago #2

  • ToyGuy
  • ToyGuy's Avatar
  • Offline
  • Moderator
  • Live like it's Christmas every day - Santa Stephen
  • Posts: 4925
Please, review the DB structure yourself. As is previously posted, there is no comprehensive written guideline, although by searching you will find some general discussions. The current, main developer is phasing out the current structure in preparations for the next project, which will be normalized, and as such, it would be a waste of his valuable time to record the structure for you.

Usually, DB structure information is self-obtained in OS projects and then you can fork your own project to handle special calls and rewriting.
Santa Stephen the Fabled Santa
Latest webtrees at MyArnolds.com
Hosted by webtreesonline.com, a division of GeneHosts LLC
MacOS 10.6.8, Apache 2.2+, PHP 5.4.16, MySQL 5.5.28
The administrator has disabled public write access.

webtrees DB structure 6 years 4 weeks ago #3

  • fisharebest
  • fisharebest's Avatar
  • Offline
  • Administrator
  • Posts: 11224
well, there is a table called "wt_individuals" that contains individuals, a table called "wt_families" that contains families ....

There is nothing particularly sophisticated. It is just a data-store, and the entities are fairly self evident.

There are two naming conventions:
Older tables have plural names (individuals versus individual) and use ID and FILE as their key values.
Newer tables have singular names, and use XREF and GEDCOM_ID as their key values.
Greg Roach - This email address is being protected from spambots. You need JavaScript enabled to view it. - fisharebest.webtrees.net
The administrator has disabled public write access.
Powered by Kunena Forum