Login   Register  
PHP Classes
elePHPant
Icontem

File: doc/desc-tables.txt

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Pierre FAUQUE  >  Genealogy Classes  >  doc/desc-tables.txt  >  Download  
File: doc/desc-tables.txt
Role: Documentation
Content type: text/plain
Description: Description of MySQL tables
Class: Genealogy Classes
Manage genealogy trees for a family
Author: By
Last change:
Date: 2011-06-22 19:47
Size: 13,445 bytes
 

Contents

Class file image Download
mysql> show full columns from [table]

gen_Addresses : Table of addresses
+--------+--------------+------+-----+---------+----------------+-----------------------+
| Field  | Type         | Null | Key | Default | Extra          | Comment               |
+--------+--------------+------+-----+---------+----------------+-----------------------+
| idaddr | int(11)      | NO   | PRI | NULL    | auto_increment | ID of an address      |
| addr   | varchar(60)  | NO   |     |         |                | Address libel         |
| acode  | varchar(5)   | NO   |     |         |                | Address zipcode       |
| aplac  | varchar(30)  | NO   |     |         |                | Address place (city)  |
| actry  | char(2)      | NO   |     |         |                | Address country       |
| aphon  | varchar(15)  | NO   |     |         |                | Phone at this address |
| myobs  | varchar(200) | NO   |     |         |                | My personnal comments |
+--------+--------------+------+-----+---------+----------------+-----------------------+
7 rows in set (0.01 sec)

gen_Marry : Table of unions
+---------+--------------+------+-----+---------+----------------+------------------------------------------------+
| Field   | Type         | Null | Key | Default | Extra          | Comment                                        |
+---------+--------------+------+-----+---------+----------------+------------------------------------------------+
| idfam   | int(11)      | NO   | PRI | NULL    | auto_increment | ID of the family                               |
| idh     | int(11)      | NO   | PRI | 0       |                | ID of the husband                              |
| idw     | int(11)      | NO   | PRI | 0       |                | ID of the wife                                 |
| idunion | int(11)      | NO   |     | 0       |                | ID of the union                                |
| udate   | varchar(10)  | NO   |     |         |                | Date of the union                              |
| uplac   | varchar(30)  | NO   |     |         |                | Place of the union (city)                      |
| ucode   | char(5)      | NO   |     |         |                | Code of the city of the union                  |
| uctry   | char(2)      | NO   |     |         |                | Country of the union                           |
| usour   | int(11)      | NO   |     | 0       |                | Source of the union (document, act)            |
| idend   | tinyint(4)   | NO   |     | 0       |                | ID of the eventual end of union                |
| edate   | varchar(10)  | NO   |     |         |                | Date of this eventual end of union             |
| eplac   | varchar(30)  | NO   |     |         |                | Place of this eventual end of union (city)     |
| ecode   | varchar(5)   | NO   |     |         |                | Code of the city of this eventual end of union |
| ectry   | char(2)      | NO   |     |         |                | Country of this eventual end of union          |
| uorder  | int(11)      | NO   |     | 0       |                | Order of this union (if several)               |
| nchi    | tinyint(4)   | YES  |     | NULL    |                | Number of children (if known)                  |
| myobs   | varchar(200) | NO   |     |         |                | My personnal comments                          |
+---------+--------------+------+-----+---------+----------------+------------------------------------------------+
17 rows in set (0.00 sec)

gen_Notes : Table of event's people
+--------+--------------+------+-----+---------+----------------+----------------------------------------+
| Field  | Type         | Null | Key | Default | Extra          | Comment                                |
+--------+--------------+------+-----+---------+----------------+----------------------------------------+
| idnote | int(11)      | NO   | PRI | NULL    | auto_increment | ID of the note                         |
| idpers | int(11)      | NO   | MUL |         |                | ID of the person                       |
| nallow | tinyint(4)   | NO   |     | 1       |                | Note allowed for display (0:no, 1:yes) |
| note   | varchar(250) | NO   |     |         |                | Note libel                             |
| norder | int(11)      | NO   |     |         |                | Order of this note for this person     |
+--------+--------------+------+-----+---------+----------------+----------------------------------------+
5 rows in set (0.00 sec)

gen_People : Table of people
+--------+-------------------+------+-----+---------+----------------+---------------------------------+
| Field  | Type              | Null | Key | Default | Extra          | Comment                         |
+--------+-------------------+------+-----+---------+----------------+---------------------------------+
| idpers | int(11)           | NO   | PRI | NULL    | auto_increment | ID of the person                |
| sex    | enum('U','M','F') | NO   |     | U       |                | Sex of the person               |
| alias  | varchar(30)       | NO   |     |         |                | Alias of the person             |
| lname  | varchar(30)       | NO   |     |         |                | Last name                       |
| fname  | varchar(50)       | NO   |     |         |                | First name                      |
| bdate  | varchar(10)       | NO   |     |         |                | Date of birth                   |
| bplac  | varchar(30)       | NO   |     |         |                | Place of birth                  |
| bcode  | char(5)           | NO   |     |         |                | Code of the place of birth      |
| bctry  | char(2)           | NO   |     |         |                | Country of birth                |
| bsour  | int(11)           | NO   |     | 0       |                | Source of birth (document, act) |
| ddate  | varchar(10)       | NO   |     |         |                | Date of death                   |
| dplac  | varchar(30)       | NO   |     |         |                | Place of death                  |
| dcode  | char(5)           | NO   |     |         |                | Code of the place of death      |
| dctry  | char(2)           | NO   |     |         |                | Country of death                |
| dsour  | int(11)           | NO   |     | 0       |                | Source of death (document, act) |
| iplac  | varchar(30)       | NO   |     |         |                | Place of inhumation             |
| icode  | char(5)           | NO   |     |         |                | Code of place of inhumation     |
| ictry  | char(2)           | NO   |     |         |                | Country of inhumation           |
| idf    | int(11)           | YES  |     | 0       |                | ID of the Father                |
| idm    | int(11)           | YES  |     | 0       |                | ID of the Mother                |
| disp   | int(11)           | NO   |     | 97      |                | Display authorizations          |
| mail   | varchar(50)       | NO   |     |         |                | Mail of the person              |
| mphon  | varchar(15)       | NO   |     |         |                | Phone (mobile) of the person    |
| pic    | varchar(25)       | NO   |     |         |                | Picture filename                |
| pdate  | varchar(10)       | NO   |     |         |                | Year of the picture             |
| idaddr | int(11)           | NO   |     | 0       |                | ID of his postal address        |
| porder | int(11)           | NO   |     | 10      |                | Person order (in his family)    |
+--------+-------------------+------+-----+---------+----------------+---------------------------------+
27 rows in set (0.00 sec)

gen_Sources : Table of sources
+--------+--------------+------+-----+---------+----------------+-------------------------------------------+
| Field  | Type         | Null | Key | Default | Extra          | Comment                                   |
+--------+--------------+------+-----+---------+----------------+-------------------------------------------+
| idsrc  | int(11)      | NO   | PRI | NULL    | auto_increment | ID of the source                          |
| sallow | smallint(6)  | NO   |     | 1       |                | Source allowed for display (0:no, 1:yes)  |
| file   | varchar(40)  | NO   |     |         |                | Filename of the source (scanned document) |
| source | varchar(200) | NO   |     |         |                | Reference of this document                |
+--------+--------------+------+-----+---------+----------------+-------------------------------------------+
4 rows in set (0.00 sec)

gen_Unions : Table of types of unions
+---------+-------------+------+-----+---------+----------------+-----------------------------------------+
| Field   | Type        | Null | Key | Default | Extra          | Comment                                 |
+---------+-------------+------+-----+---------+----------------+-----------------------------------------+
| idunion | tinyint(4)  | NO   | PRI | NULL    | auto_increment | ID of the type of union or end of union |
| union   | varchar(30) | NO   |     |         |                | Union or end of union libel             |
+---------+-------------+------+-----+---------+----------------+-----------------------------------------+
2 rows in set (0.00 sec)

gen_Visitors : Table of visitors (used by me only for PDF and GED files)
+----------+-------------+------+-----+---------+-------+-----------------------+
| Field    | Type        | Null | Key | Default | Extra | Comment               |
+----------+-------------+------+-----+---------+-------+-----------------------+
| horodate | datetime    | NO   | PRI |         |       | Datetime of the visit |
| page     | varchar(20) | NO   |     |         |       | Viewed page           |
| ip       | varchar(15) | NO   |     |         |       | From this IP          |
+----------+-------------+------+-----+---------+-------+-----------------------+
3 rows in set (0.00 sec)

geo_Cities : Table of French cities
+-------+---------------+------+-----+---------+-------+-------------------------------------------+
| Field | Type          | Null | Key | Default | Extra | Comment                                   |
+-------+---------------+------+-----+---------+-------+-------------------------------------------+
| insee | varchar(5)    | NO   | PRI |         |       | ID of the city (INSEE number)             |
| city  | varchar(40)   | NO   |     |         |       | Name of the city                          |
| code  | varchar(5)    | NO   |     |         |       | Zipcode of the city                       |
| mcity | tinyint(4)    | NO   |     |         |       | Main city of the department (0:no, 1:yes) |
| lat   | decimal(11,6) | NO   |     |         |       | Latitude                                  |
| lon   | decimal(11,6) | NO   |     |         |       | Longitude                                 |
| iddep | char(3)       | NO   |     |         |       | ID of the department                      |
+-------+---------------+------+-----+---------+-------+-------------------------------------------+
7 rows in set (0.00 sec)

geo_Countries : Table of countries
+---------+-------------+------+-----+---------+-------+--------------------------------------+
| Field   | Type        | Null | Key | Default | Extra | Comment                              |
+---------+-------------+------+-----+---------+-------+--------------------------------------+
| tld     | varchar(3)  | NO   | PRI |         |       | ID of the country (Top Level Domain) |
| country | varchar(45) | NO   |     |         |       | Name of the country                  |
+---------+-------------+------+-----+---------+-------+--------------------------------------+
2 rows in set (0.00 sec)

geo_Departments : Table of French departments
+------------+-------------+------+-----+---------+-------+------------------------+
| Field      | Type        | Null | Key | Default | Extra | Comment                |
+------------+-------------+------+-----+---------+-------+------------------------+
| iddep      | varchar(3)  | NO   | PRI |         |       | ID of the department   |
| idreg      | tinyint(4)  | NO   |     |         |       | ID of the region       |
| department | varchar(35) | NO   |     |         |       | Name of the department |
+------------+-------------+------+-----+---------+-------+------------------------+
3 rows in set (0.00 sec)

geo_Regions : Table of regions
+--------+-------------+------+-----+---------+----------------+--------------------+
| Field  | Type        | Null | Key | Default | Extra          | Comment            |
+--------+-------------+------+-----+---------+----------------+--------------------+
| idreg  | int(11)     | NO   | PRI | NULL    | auto_increment | ID of the region   |
| region | varchar(30) | NO   |     |         |                | Name of the region |
+--------+-------------+------+-----+---------+----------------+--------------------+
2 rows in set (0.00 sec)