Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: asLinks_linksasLinks_links

asLinks_links

Field Type Null Default
id  smallint(10) No   
name  varchar(255) Yes  NULL 
email  varchar(255) Yes  NULL 
url  varchar(255) Yes  NULL 
title  text Yes  NULL 
description  text Yes  NULL 
category  smallint(10) No 
reciprocal  varchar(255) Yes  NULL 
confirmed  smallint(1) No 
approved  smallint(1) No 
added  int(10) No 
nextcheck  int(10) No 
nocheck  smallint(1) No 


 Indexes :
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 email
url_2 UNIQUE None url
reciprocal_2 UNIQUE None reciprocal
reciprocal_4 UNIQUE None reciprocal
email_5 UNIQUE None email
name_5 UNIQUE None name
url_4 UNIQUE None url
name_8 UNIQUE None name
email_8 UNIQUE None email
url_8 UNIQUE None url
id INDEX None id
name INDEX None name
email INDEX None email
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 email
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 email
url_7 INDEX None url
name_3 INDEX None name
email_3 INDEX None email
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 email
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 email


 Space usage :
Type Usage
Data 444 Bytes
Index 4,096 Bytes
Total 4,540 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 2
Row length ø 222
Row size  ø 2,270 Bytes
Next Autoindex 3
Creation Nov 12, 2017 at 10:12 AM
Last update Apr 18, 2024 at 12:34 PM
Last check Apr 20, 2024 at 12:38 AM