Gus Mueller

Database visualizer

create new table db tools manually enter SQL

gus_demo : tf_scriptlog : column analysis

column	foreign refs	primary refs	minval	maxval	median	mean	stand dev	nonnulls	no nulls	minsize	maxsize	type	defacto type
scriptlog_id			1734	13253	7495	7,493.500	3,325.538	11520	1	4	5	int(11)	int(5)
pre_script			9	9	0	0.002	8.998	11520	1	1	1	varchar(1)	varchar(1)
post_script			9	9	0	0.002	8.998	59		1	1	varchar(1)	varchar(1)
type								11520	1	1	1	varchar(1)	varchar(1)
time_executed								11520	1	19	19	timestamp	datetime

rescheme table based on defacto type

Read the documentation.