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

Application 2.2.1 Tool 2.10 DMS Observation Schema

ibdbv2-dms

 

 
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

 
phenotype  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

phenotype_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

uniquename

varchar(255)

utf8_general_ci

NO

UNI

(NULL)

 

select,insert,update,references

 

name

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

observable_id

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

attr_id

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

value

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

cvalue_id

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

assay_id

int(11)

(NULL)

YES

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

phenotype

0

PRIMARY

1

phenotype_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

phenotype

0

phenotype_idx1

1

uniquename

A

0

(NULL)

(NULL)

 

BTREE

 

 

phenotype

1

phenotype_idx2

1

assay_id

A

0

(NULL)

(NULL)

YES

BTREE

 

 

phenotype

1

phenotype_idx3

1

cvalue_id

A

0

(NULL)

(NULL)

YES

BTREE

 

 

phenotype

1

phenotype_idx4

1

observable_id

A

0

(NULL)

(NULL)

YES

BTREE

 

 

phenotype

1

phenotype_idx5

1

attr_id

A

0

(NULL)

(NULL)

YES

BTREE

 

 

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

phenotype_fk1

cvterm

`observable_id`

`cvterm_id`

ON DELETE CASCADE,

phenotype_fk2

cvterm

`attr_id`

`cvterm_id`

ON DELETE SET NULL,

phenotype_fk3

cvterm

`cvalue_id`

`cvterm_id`

ON DELETE SET NULL,

phenotype_fk4

cvterm

`assay_id`

`cvterm_id`

ON DELETE SET NULL

Back

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