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	13573	7655	7,653.500	3,417.914	11840	1	4	5	int(11)	int(5)
pre_script			9	9	0	0.002	8.998	11840	1	1	1	varchar(1)	varchar(1)
post_script			9	9	0	0.002	8.998	59		1	1	varchar(1)	varchar(1)
type								11840	1	1	1	varchar(1)	varchar(1)
time_executed								11840	1	19	19	timestamp	datetime

rescheme table based on defacto type

Read the documentation.