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)
|
Download
