EnviroTox - Tools for Calculating Ecotoxicological Thresholds of Concern

Database Info ecottc_test

cron0

Field	Type	Primary
job_id	int(11)	Y
job_name	varchar(255)
create_date	timestamp()

cron_file0

Field	Type	Primary
cf_id	int(11)	Y
job_id	int(11)
file_id	int(11)
job_status	varchar(20)
note	varchar(255)
log_path	varchar(255)
update_date	timestamp()

file0

Field	Type	Primary
file_id	int(11)	Y
file_name	varchar(255)
file_path	varchar(255)
file_md5	varchar(255)
file_type	varchar(255)
note	text()
is_active	tinyint(1)
update_date	timestamp()

groups2

Field	Type	Primary
id	mediumint(8)	Y
name	varchar(20)
description	varchar(100)

login_attempts0

Field	Type	Primary
id	int(11)	Y
ip_address	varchar(15)
login	varchar(100)
time	int(11)

substance4267

Field	Type	Primary
substance_id	int(11)	Y
cas	bigint(20)

substance_property22

Field	Type	Primary
property_id	int(11)	Y
property_name	varchar(255)
property_unit	varchar(255)
is_required	tinyint(1)
is_searchable	tinyint(1)
sort_order	smallint(5)
default_value	text()
property_format	varchar(255)
note	varchar(255)

substance_property_double9098

Field	Type	Primary
value_id	int(11)	Y
substance_id	int(11)
property_id	int(11)
value	double()

substance_property_int19599

Field	Type	Primary
value_id	int(11)	Y
substance_id	int(11)
property_id	int(11)
value	int(11)

substance_property_text32

Field	Type	Primary
value_id	int(11)	Y
substance_id	int(11)
property_id	int(11)
value	text()

substance_property_varchar65145

Field	Type	Primary
value_id	int(11)	Y
substance_id	int(11)
property_id	int(11)
value	varchar(255)

taxonomy1641

Field	Type	Primary
taxonomy_id	int(11)	Y
latin_name	varchar(255)

taxonomy_property9

Field	Type	Primary
property_id	int(11)	Y
property_name	varchar(255)
property_unit	varchar(255)
is_required	tinyint(1)
is_searchable	tinyint(1)
sort_order	smallint(5)
default_value	text()
property_format	varchar(255)
note	varchar(255)

taxonomy_property_double0

Field	Type	Primary
value_id	int(11)	Y
taxonomy_id	int(11)
property_id	int(11)
value	double()

taxonomy_property_int0

Field	Type	Primary
value_id	int(11)	Y
taxonomy_id	int(11)
property_id	int(11)
value	int(11)

taxonomy_property_text0

Field	Type	Primary
value_id	int(11)	Y
taxonomy_id	int(11)
property_id	int(11)
value	text()

taxonomy_property_varchar14769

Field	Type	Primary
value_id	int(11)	Y
taxonomy_id	int(11)
property_id	int(11)
value	varchar(255)

test80912

Field	Type	Primary
test_id	int(11)	Y
substance_id	int(11)
taxonomy_id	int(11)

test_property15

Field	Type	Primary
property_id	int(11)	Y
property_name	varchar(255)
property_unit	varchar(255)
is_required	tinyint(1)
is_searchable	tinyint(1)
sort_order	smallint(5)
default_value	text()
property_format	varchar(255)
note	varchar(255)

test_property_double63206

Field	Type	Primary
value_id	int(11)	Y
test_id	int(11)
property_id	int(11)
value	double()

test_property_int327356

Field	Type	Primary
value_id	int(11)	Y
test_id	int(11)
property_id	int(11)
value	int(11)

test_property_text5015

Field	Type	Primary
value_id	int(11)	Y
test_id	int(11)
property_id	int(11)
value	text()

test_property_varchar818103

Field	Type	Primary
value_id	int(11)	Y
test_id	int(11)
property_id	int(11)
value	varchar(255)

users1

Field	Type	Primary
id	int(11)	Y
ip_address	varchar(45)
username	varchar(100)
password	varchar(255)
salt	varchar(255)
email	varchar(100)
activation_code	varchar(40)
forgotten_password_code	varchar(40)
forgotten_password_time	int(11)
remember_code	varchar(40)
created_on	int(11)
last_login	int(11)
active	tinyint(1)
first_name	varchar(50)
last_name	varchar(50)
company	varchar(100)
phone	varchar(20)

users_groups2

Field	Type	Primary
id	int(11)	Y
user_id	int(11)
group_id	mediumint(8)

Database Setup

Database Info ecottc_test Reinstall Upload

Database Info ecottc_test