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	20140	10938	10,937.000	5,313.643	18407	1	4	5	int(11)	int(5)
pre_script			1	9		0.005	6.564	18407	1	1	1	varchar(1)	varchar(1)
post_script			9	9		0.001	8.999	59		1	1	varchar(1)	varchar(1)
type								18407	1	1	1	varchar(1)	varchar(1)
time_executed								18407	1	19	19	timestamp	datetime

rescheme table based on defacto type