Host: mysql.puroparty.com
Database: puroparty
Generation Time: Apr 25, 2024 at 04:12 PM
Generated by: phpMyAdmin 2.6.0-pl3 / MySQL 4.1.22-standard
SQL-query: SELECT * FROM `email_list_subscribers_unsubscribe` PROCEDURE ANALYSE();
Rows: 8
| Field_name | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std | Optimal_fieldtype |
|---|---|---|---|---|---|---|---|---|---|
| puroparty.email_list_subscribers_unsubscribe.subscriberid | 99 | 36275 | 2 | 5 | 0 | 0 | 12526.0034 | 5441.0086 | SMALLINT(5) UNSIGNED NOT NULL |
| puroparty.email_list_subscribers_unsubscribe.unsubscribetime | 1220656755 | 1291769744 | 10 | 10 | 0 | 0 | 1241657516.8678 | 0.0000 | INT(10) UNSIGNED NOT NULL |
| puroparty.email_list_subscribers_unsubscribe.unsubscribeip | 10.1.204.16 | 99.22.211.16 | 10 | 15 | 14 | 0 | 12.4847 | NULL | ENUM('','10.1.204.16','10.76.146.37','10.9.130.168','118.168.69.246','12.109.2.4','12.134.166.26','12.146.213.2','12.171.176.254','12.48.34.38','12.50.177.2','128.249.96.252','128.83.233.154','128.83.43.121','129.109.29.44','129.7.111.101','129.7.154.34','129.7.194.246','129.7.35.147','129.7.45.141','131.107.0.113','131.107.0.114','134.132.76.166','137.240.136.80','139.52.144.44','139.52.97.20','143.111.22.25','143.111.22.27','143.111.22.28','15.203.233.79','15.211.153.73','151.151.7.53','151.151.7.56','159.53.46.143','161.40.130.99','161.40.15.113','162.136.42.1','164.109.47.217','165.249.0.61','166.102.136.8','166.127.1.220','166.127.1.221','166.127.1.222','166.89.26.193','168.189.64.96','168.215.182.197','170.20.11.119','173.48.30.71','173.71.10.254','173.8.21.49','189.162.154.59','192.195.92.81','198.245.202.189','198.3.68.20','199.253.16.1','202.136.147.159','203.89.163.77','204.126.199.97','204.128.192.3','204.149.81.6','204.235.227.130','204.235.227.131','204.235.227.132','204.235.227.134','204.235.227.142','204.235.227.143','204.235.227.144','204.235.227.149','204.235.227.152','204.99.19.150','205.174.8.4','205.188.116.136','205.188.116.201','205.188.117.68','206.180.38.20','206.201.224.4','206.225.178.10','206.252.74.170','206.53.144.168','206.53.147.213','206.53.153.145','206.53.153.148','206.53.153.174','206.53.153.183','206.53.157.236','206.53.157.84','207.200.116.136','207.206.148.78','207.243.101.5','207.70.152.28','207.71.25.99','207.91.168.162','208.188.84.201','208.254.130.235','208.49.157.253','208.64.140.251','209.163.207.111','209.176.32.53','209.183.32.18','209.184.114.153','209.184.115.39','209.253.217.121','210.23.149.193','216.110.79.11','216.130.131.66','216.136.107.170','216.197.245.235','216.215.102.146','216.23.196.236','216.23.208.100','216.57.7.178','217.237.175.55','24.149.196.131','24.149.202.162','24.183.225.79','38.100.41.119','38.100.41.120','38.100.41.98','38.112.15.198','41.145.110.155','63.133.130.74','63.241.223.4','63.97.12.50','64.107.81.91','64.12.116.210','64.12.116.8','64.124.150.42','64.219.195.47','64.65.185.242','65.104.239.194','65.15.190.108','65.170.41.254','65.246.156.143','65.65.223.90','65.70.33.9','66.124.175.38','66.139.199.14','66.141.138.252','66.15.221.129','66.171.167.96','66.193.240.253','66.249.99.11','66.25.18.64','66.60.241.7','66.64.31.98','66.68.250.11','66.69.0.189','67.174.219.189','67.200.194.10','67.79.186.221','68.100.55.40','68.2.48.83','68.203.152.99','68.28.179.113','68.28.179.116','68.28.179.119','68.5.88.206','68.89.25.173','68.92.207.240','69.15.202.220','69.150.143.58','69.151.228.87','69.53.112.154','69.7.167.129','70.112.225.14','70.112.236.23','70.134.205.166','70.138.115.15','70.138.146.145','70.138.74.80','70.139.36.90','70.139.51.148','70.139.58.153','70.181.48.213','70.189.164.62','70.2.19.200','70.218.117.221','70.240.105.70','70.240.136.151','70.240.196.8','70.240.232.229','70.241.117.220','70.243.34.80','70.243.39.147','70.244.35.144','70.253.124.228','71.196.103.91','71.96.241.107','72.181.35.159','72.20.135.68','72.20.136.131','72.254.130.62','72.37.171.36','72.37.249.36','72.46.192.104','72.54.61.110','72.54.61.234','72.73.160.250','74.192.203.182','74.202.66.134','74.213.57.42','74.5.120.140','74.7.107.100','74.7.26.98','74.95.215.81','74.95.229.137','74.97.2.90','75.111.159.135','75.111.86.186','75.167.20.125','75.177.107.4','75.54.182.177','75.63.208.183','75.94.233.168','76.238.152.183','76.30.209.133','76.31.241.134','76.84.96.27','90.43.138.134','97.65.20.110','98.194.249.75','98.195.87.19','98.196.113.202','98.196.132.107','98.196.69.5','98.197.208.191','98.197.84.79','98.198.169.31','98.198.211.57','98.198.227.114','98.199.38.207','98.200.24.179','98.200.26.144','98.200.84.210','98.201.153.205','98.242.9.64','99.146.168.227','99.151.29.69','99.153.105.36','99.177.92.180','99.184.77.124','99.185.14.42','99.200.11.152','99.21.140.85','99.22.211.16') NOT NULL |
| puroparty.email_list_subscribers_unsubscribe.unsubscriberequesttime | 0 | 0 | 1 | 1 | 295 | 0 | 0.0000 | 0.0000 | ENUM('0') NOT NULL |
| puroparty.email_list_subscribers_unsubscribe.unsubscriberequestip | 0 | 0 | 295 | 0 | 0.0000 | NULL | CHAR(0) NOT NULL | ||
| puroparty.email_list_subscribers_unsubscribe.listid | 2 | 18 | 1 | 2 | 0 | 0 | 2.5322 | 2.2166 | ENUM('2','8','9','10','14','16','18') NOT NULL |
| puroparty.email_list_subscribers_unsubscribe.statid | 6 | 76 | 1 | 2 | 1 | 0 | 32.5390 | 11.5898 | ENUM('0','6','9','10','21','27','30','32','36','38','41','48','62','66','68','72','74','76') NOT NULL |
| puroparty.email_list_subscribers_unsubscribe.unsubscribearea | f | n | 1 | 1 | 0 | 0 | 1.0000 | NULL | ENUM('f','n') NOT NULL |