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	11341	6539	6,537.500	2,773.591	9608	1	4	5	int(11)	int(5)
pre_script			9	9	0	0.003	8.997	9608	1	1	1	varchar(1)	varchar(1)
post_script			9	9	0	0.003	8.997	56		1	1	varchar(1)	varchar(1)
type								9608	1	1	1	varchar(1)	varchar(1)
time_executed								9608	1	19	19	timestamp	datetime

rescheme table based on defacto type

Read the documentation.