![[H]ard|Forum](/styles/hardforum/xenforo/logo_dark.png){kind=logo}
tim_m
i'm so nice
- Joined
- Feb 10, 2003
- Messages
- 5,539
There are 3 parts for this poll
i'm looking mainly for tables that you've personally made or otherwise have some sort of role in. i would be happy to here any 'extraordinary' tables even if they aren't actually yours but you happen to know about
here's mine.
i actually have a tie for 2 tables for number of columns. both have 18
first is a table for an image management system i'm currently developing (it's still subject to get bigger though)
the other holds info on faculty/staff members
both these tables are for the math/cs deptartment site that i'm in charge of at my college
http://mathcs.muhlenberg.edu
the table with the largest number of rows is a table of images (from a different project) that stores info for images from most of the episodes of star trek. there are 3,392 rows taking 392.8 kb (the images are not stored in blobs in the table)
as for the largest size table, when i made this project i was still a relative newb so i made different tables for each star trek series to hold episode information but the schema were all the same, i should have made one table, i'll display the info as if i made one table. it would be 1.75 mb, the table holds the synopses for most of the episodes of startrek. there are 606 rows so that makes about 2.95 kb per row
http://zero.servequake.com/startrek
- Number of columns (post a schema dump)
- Number of records/rows
- Total size of table/Average record size
i'm looking mainly for tables that you've personally made or otherwise have some sort of role in. i would be happy to here any 'extraordinary' tables even if they aren't actually yours but you happen to know about
here's mine.
i actually have a tie for 2 tables for number of columns. both have 18
first is a table for an image management system i'm currently developing (it's still subject to get bigger though)
Code:
CREATE TABLE `images` (
`iid` int(10) unsigned NOT NULL auto_increment,
`sid` int(10) unsigned NOT NULL default '0',
`context_id` int(10) unsigned default NULL,
`path` varchar(255) NOT NULL default '',
`file` varchar(255) NOT NULL default '',
`caption` text,
`size` int(10) unsigned NOT NULL default '0',
`width` int(10) unsigned NOT NULL default '0',
`height` int(10) unsigned NOT NULL default '0',
`has_thumb` tinyint(1) unsigned NOT NULL default '0',
`thumb_aspect` varchar(20) NOT NULL default 'keep_aspect',
`thumb_size` int(10) unsigned NOT NULL default '0',
`thumb_width` int(10) unsigned NOT NULL default '0',
`thumb_height` int(10) unsigned NOT NULL default '0',
`thumb_desired_width` int(10) unsigned NOT NULL default '0',
`thumb_desired_height` int(10) unsigned NOT NULL default '0',
`added_by_name` varchar(25) NOT NULL default '',
`added_by_uid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`iid`)
) TYPE=MyISAM;
Code:
CREATE TABLE `faculty` (
`fid` int(10) unsigned NOT NULL auto_increment,
`active` tinyint(1) unsigned NOT NULL default '1',
`prefix` varchar(10) NOT NULL default '',
`fname` varchar(50) NOT NULL default '',
`mname` varchar(50) NOT NULL default '',
`lname` varchar(50) NOT NULL default '',
`position_short` varchar(255) NOT NULL default '',
`position_long` tinytext NOT NULL,
`education` text NOT NULL,
`office` varchar(255) NOT NULL default '',
`phone` varchar(255) NOT NULL default '',
`fax` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`www` varchar(255) NOT NULL default '',
`mailing` tinytext NOT NULL,
`bio` text NOT NULL,
`image` varchar(255) NOT NULL default '',
`iid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`fid`)
) TYPE=MyISAM;http://mathcs.muhlenberg.edu
the table with the largest number of rows is a table of images (from a different project) that stores info for images from most of the episodes of star trek. there are 3,392 rows taking 392.8 kb (the images are not stored in blobs in the table)
as for the largest size table, when i made this project i was still a relative newb so i made different tables for each star trek series to hold episode information but the schema were all the same, i should have made one table, i'll display the info as if i made one table. it would be 1.75 mb, the table holds the synopses for most of the episodes of startrek. there are 606 rows so that makes about 2.95 kb per row
http://zero.servequake.com/startrek