PHP Classes

File: doc/desc-tables.txt

Recommend this page to a friend!
  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: 12 years ago
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)