Data base

Bases de données

Le projet Wemove repose sur une base de données composée de 3 tables, en voici les schémas:

Table host

+--------------+--------------+------+-----+---------+----------------+
| Field        | Type         | Null | Key | Default | Extra          |
+--------------+--------------+------+-----+---------+----------------+
| host_id      | int(11)      | NO   | PRI | NULL    | auto_increment | 
| host_contact | varchar(120) | YES  |     | NULL    |                | 
| host_url     | varchar(120) | NO   |     |         |                | 
+--------------+--------------+------+-----+---------+----------------+

Table seed

+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| seed_id  | int(11)      | NO   | PRI | NULL    | auto_increment | 
| id_host  | int(11)      | NO   |     |         |                | 
| id_lang  | int(11)      | NO   |     |         |                | 
| seed_url | varchar(256) | NO   | UNI |         |                | 
+----------+--------------+------+-----+---------+----------------+

Table item

+-------------+--------------+------+-----+-------------------+----------------+
| Field       | Type         | Null | Key | Default           | Extra          |
+-------------+--------------+------+-----+-------------------+----------------+
| item_id     | int(6)       | NO   | PRI | NULL              | auto_increment | 
| id_seed     | int(6)       | NO   |     |                   |                | 
| md5_link    | varchar(128) | NO   | UNI |                   |                | 
| title       | varchar(255) | NO   | MUL |                   |                | 
| description | longtext     | NO   |     |                   |                | 
| link        | varchar(255) | NO   |     |                   |                | 
| guid        | varchar(255) | YES  |     | NULL              |                | 
| author      | varchar(255) | YES  |     | NULL              |                | 
| pubDate     | datetime     | YES  |     | NULL              |                | 
| archDate    | timestamp    | YES  |     | CURRENT_TIMESTAMP |                | 
| online      | tinyint(1)   | NO   |     | 1                 |                | 
+-------------+--------------+------+-----+-------------------+----------------+