Print view - phpMyAdmin 4.9.2

activity

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(12)	No
cycle_no	int(6)	Yes	NULL
block_no	tinyint(3)	Yes	NULL
tank_no	tinyint(2)	Yes	NULL
action	varchar(128)	No
updates	text	No
user	varchar(16)	No
log_date	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	171325	A	No

alc_zone

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(3)	No
moromi_id	tinyint(2)	No
moromi_type	varchar(64)	No
lo_day	int(8)	Yes	NULL
low	varchar(8)	Yes	NULL
hi_day	int(8)	Yes	NULL
high	varchar(8)	Yes	NULL
zone	varchar(16)	No
created_user	varchar(16)	No
created_date	timestamp	Yes	NULL
mod_user	varchar(16)	Yes
mod_date	datetime	Yes	NULL
status	tinyint(2)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	166	A	No

blocks

Column	Type	Null	Default	Links to	Comments	MIME
block_no (Primary)	int(3)	No
tank_qty	tinyint(2)	No
block_desc	varchar(254)	Yes	NULL
created_user	varchar(16)	No
created_date	timestamp	Yes	NULL
mod_user	varchar(16)	Yes
mod_date	datetime	Yes	NULL
status	tinyint(2)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	block_no	74	A	No

default_email

Column	Type	Null	Default	Links to	Comments	MIME
email_id (Primary)	int(6)	No
name	varchar(128)	Yes	NULL
email	varchar(128)	No
status	tinyint(3)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	email_id	1	A	No

ext_samp

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(8)	No
cycle_no	int(6)	No
block_no	tinyint(3)	No
tank_no	tinyint(2)	No
moromi_id	int(2)	No
samp_type (Primary)	varchar(16)	No
charge_date	date	Yes	NULL
sample_comp	date	Yes	NULL
age	int(3)	No
created_user	varchar(16)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	12600	A	No
PRIMARY	BTREE	Yes	No	samp_type	12600	A	No

lab_type

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(2)	No
position	tinyint(2)	No
lab_symbol	varchar(16)	No
lab_desc	varchar(128)	No
created_user	varchar(16)	No
created_date	timestamp	Yes	NULL
mod_user	varchar(16)	Yes
mod_date	datetime	Yes	NULL
status	tinyint(2)	Yes	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	7	A	No

moromi_tank

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(8)	No
cycle_no	int(6)	No
block_no	tinyint(3)	No
tank_no	tinyint(2)	No
charge_date	date	Yes	NULL
discharge_date	date	Yes	NULL
moromi_id	int(2)	No
moromi_name	varchar(64)	No
lab_type	varchar(64)	No
aeration_start	date	Yes	NULL
aeration_stop	date	Yes	NULL
cycle_status	tinyint(2)	No	1		1=ongoing,2=ended,3=clean
border	tinyint(2)	No	0		0=Null, 1=Black Test, 2=Red Caution, 3=Green Reset
created_user	varchar(16)	No
created_date	datetime	Yes	NULL
mod_user	varchar(16)	No
mod_date	datetime	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	14337	A	No

moromi_type

Column	Type	Null	Default	Links to	Comments	MIME
moromi_id (Primary)	int(2)	No
moromi_name	varchar(32)	No
ph_nextdate	varchar(8)	No
moromi_clr	varchar(32)	No
created_user	varchar(16)	No
created_date	timestamp	Yes	NULL
mod_user	varchar(16)	Yes
mod_date	datetime	Yes	NULL
status	tinyint(2)	Yes	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	moromi_id	13	A	No

moromi_type_new

Column	Type	Null	Default	Links to	Comments	MIME
moromi_id (Primary)	int(2)	No
moromi_name	varchar(32)	No
cycle_days	varchar(16)	Yes
ph_nextdate	varchar(8)	No
alc_nextdate	varchar(16)	Yes
aer_start	varchar(16)	Yes
wk2_analysis	varchar(16)	Yes
moromi_clr	varchar(32)	No
created_user	varchar(16)	No
created_date	timestamp	Yes	NULL
mod_user	varchar(16)	Yes
mod_date	datetime	Yes	NULL
status	tinyint(2)	Yes	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	moromi_id	15	A	No

moromi_type_old

Column	Type	Null	Default	Links to	Comments	MIME
moromi_id (Primary)	int(2)	No
moromi_name	varchar(32)	No
ph_nextdate	varchar(8)	No
moromi_clr	varchar(32)	No
created_user	varchar(16)	No
created_date	timestamp	Yes	NULL
mod_user	varchar(16)	Yes
mod_date	datetime	Yes	NULL
status	tinyint(2)	Yes	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	moromi_id	13	A	No

notification

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(6)	No
moromi	varchar(16)	No
type	varchar(64)	No
notice	varchar(128)	No
date	date	Yes	NULL

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	2250	A	No

ph_zone

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(3)	No
moromi_id	tinyint(2)	No
moromi_type	varchar(64)	No
lo_day	int(3)	Yes	NULL
low	decimal(3,2)	Yes	NULL
hi_day	int(3)	Yes	NULL
high	decimal(3,2)	Yes	NULL
zone	varchar(16)	No
created_user	varchar(16)	No
created_date	timestamp	Yes	NULL
mod_user	varchar(16)	Yes
mod_date	datetime	Yes	NULL
status	tinyint(2)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	68	A	No

post_comments

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(5)	No
cycle_no	int(6)	No
block_no	tinyint(3)	No
tank_no	tinyint(2)	No
user_email	varchar(128)	No
comments	text	No
border	tinyint(2)	No	0		0=Null, 1=Black Test, 2=Red Caution, 3=Green Reset
user	varchar(30)	No
post_date	timestamp	No	current_timestamp()
user_level	tinyint(2)	No	1		0=inactive, usr=1, supervisor=2, admin=3
status	varchar(4)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	3700	A	No

sampling

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(8)	No
cycle_no	int(6)	No
block_no	tinyint(3)	No
tank_no	tinyint(2)	No
moromi_id	int(2)	No
sample_date	datetime	Yes	NULL
age	int(3)	No
alc_age	int(3)	Yes	NULL
ph	varchar(16)	No
alc	varchar(16)	No
created_user	varchar(16)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	92683	A	No
cycle_no	BTREE	No	No	cycle_no	36	A	No
				block_no	2014	A	No
				tank_no	15447	A	No

sampling_nextdate

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(8)	No
cycle_no	int(6)	No
block_no	tinyint(3)	No
tank_no	tinyint(2)	No
moromi_name	varchar(64)	No
charge_date	date	Yes	NULL
aeration_date	date	Yes	NULL
date	datetime	Yes	NULL
age	int(3)	Yes	NULL
alc_age	int(3)	Yes	NULL
next_date	date	Yes	NULL
2wk	varchar(2)	No
done	varchar(8)	No
created_user	varchar(16)	No

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	108756	A	No
cycle_no	BTREE	No	No	cycle_no	34	A	No
				block_no	1977	A	No
				tank_no	13594	A	No

user

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(2)	No
ip	varchar(64)	Yes
name	varchar(128)	No
email	varchar(128)	No
user	varchar(16)	No
user_pwd	varchar(16)	No
user_level	tinyint(2)	Yes	1		0=inactive, usr=1, supervisor=2, admin=3
created_user	varchar(16)	No
created_date	timestamp	Yes	NULL
mod_user	varchar(16)	No
mod_date	datetime	Yes	NULL
status	tinyint(2)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	33	A	No

_secured_ip

Column	Type	Null	Default	Links to	Comments	MIME
id (Primary)	int(4)	No
ip_no	varchar(64)	No
ip_desc	varchar(128)	Yes	NULL
created_date	datetime	Yes	NULL
modified_date	timestamp	No	current_timestamp()
status	tinyint(2)	No	1

Indexes

Keyname	Type	Unique	Packed	Column	Cardinality	Collation	Null	Comment
PRIMARY	BTREE	Yes	No	id	13	A	No

Open new phpMyAdmin window