Server: mysql.puroparty.com | Database: puroparty | Table: asLinks_links |
Field | Type | Null | Default |
---|---|---|---|
id | smallint(10) | No | |
name | varchar(255) | Yes | NULL |
varchar(255) | Yes | NULL | |
url | varchar(255) | Yes | NULL |
title | text | Yes | NULL |
description | text | Yes | NULL |
category | smallint(10) | No | 0 |
reciprocal | varchar(255) | Yes | NULL |
confirmed | smallint(1) | No | 0 |
approved | smallint(1) | No | 0 |
added | int(10) | No | 0 |
nextcheck | int(10) | No | 0 |
nocheck | smallint(1) | No | 0 |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 2 | id | |
id_2 | UNIQUE | 2 | id | |
category_2 | UNIQUE | 2 | category | |
confirmed_2 | UNIQUE | 2 | confirmed | |
approved_2 | UNIQUE | 2 | approved | |
nextcheck_2 | UNIQUE | 2 | nextcheck | |
id_3 | UNIQUE | 2 | id | |
approved_3 | UNIQUE | 2 | approved | |
nextcheck_3 | UNIQUE | 2 | nextcheck | |
confirmed_4 | UNIQUE | 2 | confirmed | |
category_4 | UNIQUE | 2 | category | |
id_6 | UNIQUE | 2 | id | |
name_2 | UNIQUE | None | name | |
email_2 | UNIQUE | None | ||
url_2 | UNIQUE | None | url | |
reciprocal_2 | UNIQUE | None | reciprocal | |
reciprocal_4 | UNIQUE | None | reciprocal | |
email_5 | UNIQUE | None | ||
name_5 | UNIQUE | None | name | |
url_4 | UNIQUE | None | url | |
name_8 | UNIQUE | None | name | |
email_8 | UNIQUE | None | ||
url_8 | UNIQUE | None | url | |
id | INDEX | None | id | |
name | INDEX | None | name | |
INDEX | None | |||
url | INDEX | None | url | |
category | INDEX | None | category | |
reciprocal | INDEX | None | reciprocal | |
confirmed | INDEX | None | confirmed | |
approved | INDEX | None | approved | |
added | INDEX | None | added | |
nextcheck | INDEX | None | nextcheck | |
nocheck | INDEX | None | nocheck | |
category_3 | INDEX | None | category | |
name_4 | INDEX | None | name | |
nocheck_2 | INDEX | None | nocheck | |
id_4 | INDEX | None | id | |
email_6 | INDEX | None | ||
confirmed_3 | INDEX | None | confirmed | |
approved_4 | INDEX | None | approved | |
added_2 | INDEX | None | added | |
reciprocal_6 | INDEX | None | reciprocal | |
nextcheck_4 | INDEX | None | nextcheck | |
url_6 | INDEX | None | url | |
nocheck_3 | INDEX | None | nocheck | |
id_5 | INDEX | None | id | |
name_7 | INDEX | None | name | |
email_7 | INDEX | None | ||
url_7 | INDEX | None | url | |
name_3 | INDEX | None | name | |
email_3 | INDEX | None | ||
url_3 | INDEX | None | url | |
title | INDEX | None | title | |
description | INDEX | None | description | |
reciprocal_3 | INDEX | None | reciprocal | |
description_2 | INDEX | None | description | |
email_4 | INDEX | None | ||
name_6 | INDEX | None | name | |
reciprocal_5 | INDEX | None | reciprocal | |
title_2 | INDEX | None | title | |
url_5 | INDEX | None | url | |
name_9 | INDEX | None | name | |
email_9 | INDEX | None |
Space usage :
|
Row Statistic :
|