TABLE 'heads' +--------------------+------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------+------+-----+---------------------+----------------+ | id | bigint(20) | | PRI | NULL | auto_increment | | date_indexed | datetime | | | 0000-00-00 00:00:00 | | | last_date_spidered | datetime | | | 0000-00-00 00:00:00 | | | pub_date | datetime | | | 0000-00-00 00:00:00 | | | url | text | | | | | +--------------------+------------+------+-----+---------------------+----------------+ TABLE 'items' (foreign key on [head_id] references 'heads' [id]) +-------------+--------------+------+-----+---------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------------------+----------------+ | id | bigint(20) | | PRI | NULL | auto_increment | | head_id | bigint(20) | | MUL | 0 | | | pub_date | datetime | | | 0000-00-00 00:00:00 | | | title | varchar(120) | | | | | | url | text | | | | | | description | text | | | | | | content | mediumtext | | | | | +-------------+--------------+------+-----+---------------------+----------------+