Access Keys:
Skip to content (Access Key - 0)

Application 2.2.1 Tool 2.10 DMS Trial Design Schema

ibdbv2-dms

 

 
nd_experiment  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

nd_experiment_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

nd_geolocation_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

type_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

nd_experiment

0

PRIMARY

1

nd_experiment_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experiment

1

nd_experiment_idx1

1

nd_geolocation_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experiment

1

nd_experiment_idx2

1

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

Foreign Key Relationships
FK Id Reference Table Source Column Target Column Extra Info

nd_experiment_fk1

nd_geolocation

`nd_geolocation_id`

`nd_geolocation_id`

ON DELETE CASCADE,

nd_experiment_fk2

cvterm

`type_id`

`cvterm_id`

ON DELETE CASCADE

Back

 
nd_experiment_phenotype  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

nd_experiment_phenotype_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

nd_experiment_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

phenotype_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

nd_experiment_phenotype

0

PRIMARY

1

nd_experiment_phenotype_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experiment_phenotype

0

nd_experiment_phenotype_idx1

1

nd_experiment_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experiment_phenotype

0

nd_experiment_phenotype_idx1

2

phenotype_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experiment_phenotype

1

nd_experiment_phenotype_idx2

1

phenotype_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

Foreign Key Relationships
FK Id Reference Table Source Column Target Column Extra Info

nd_experiment_phenotype_fk1

nd_experiment

`nd_experiment_id`

`nd_experiment_id`

ON DELETE CASCADE,

nd_experiment_phenotype_fk2

phenotype

`phenotype_id`

`phenotype_id`

ON DELETE CASCADE

Back

 
nd_experiment_project  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

nd_experiment_project_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

project_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

nd_experiment_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

nd_experiment_project

0

PRIMARY

1

nd_experiment_project_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experiment_project

1

nd_experiment_project_idx1

1

project_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experiment_project

1

nd_experiment_project_idx2

1

nd_experiment_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

Foreign Key Relationships
FK Id Reference Table Source Column Target Column Extra Info

nd_experiment_project_fk1

project

`project_id`

`project_id`

ON DELETE CASCADE,

nd_experiment_project_fk2

nd_experiment

`nd_experiment_id`

`nd_experiment_id`

ON DELETE CASCADE

Back

 
nd_experiment_stock  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

nd_experiment_stock_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

nd_experiment_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

stock_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

type_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

nd_experiment_stock

0

PRIMARY

1

nd_experiment_stock_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experiment_stock

1

nd_experiment_stock_idx1

1

nd_experiment_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experiment_stock

1

nd_experiment_stock_idx2

1

stock_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experiment_stock

1

nd_experiment_stock_idx3

1

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

Foreign Key Relationships
FK Id Reference Table Source Column Target Column Extra Info

nd_experiment_stock_fk1

nd_experiment

`nd_experiment_id`

`nd_experiment_id`

ON DELETE CASCADE,

nd_experiment_stock_fk2

stock

`stock_id`

`stock_id`

ON DELETE CASCADE,

nd_experiment_stock_fk3

cvterm

`type_id`

`cvterm_id`

ON DELETE CASCADE

Back

 
nd_experimentprop  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

nd_experimentprop_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

nd_experiment_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

type_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

value

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

rank

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment Index
comment

nd_experimentprop

0

PRIMARY

1

nd_experimentprop_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experimentprop

0

nd_experimentprop_idx1

1

nd_experiment_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experimentprop

0

nd_experimentprop_idx1

2

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experimentprop

0

nd_experimentprop_idx1

3

rank

A

0

(NULL)

(NULL)

 

BTREE

 

 

nd_experimentprop

1

nd_experimentprop_idx2

1

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

Foreign Key Relationships
FK Id Reference Table Source Column Target Column Extra Info

nd_experimentprop_fk1

nd_experiment

`nd_experiment_id`

`nd_experiment_id`

ON DELETE CASCADE,

nd_experimentprop_fk2

cvterm

`type_id`

`cvterm_id`

ON DELETE CASCADE

Back

Adaptavist Theme Builder (3.3.3-conf210) Powered by Atlassian Confluence 2.10.3, the Enterprise Wiki.
Free theme builder license