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

Application 2.2.1 Tool 2.10 DMS Germplasm Entries Schema

ibdbv2-dms

 

 
stock  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

stock_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

dbxref_id

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

organism_id

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

name

varchar(255)

utf8_general_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

uniquename

varchar(255)

utf8_general_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

value

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

description

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

type_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

is_obsolete

tinyint(1)

(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

stock

0

PRIMARY

1

stock_id

A

1

(NULL)

(NULL)

 

BTREE

 

 

stock

0

stock_idx1

1

organism_id

A

1

(NULL)

(NULL)

YES

BTREE

 

 

stock

0

stock_idx1

2

uniquename

A

1

(NULL)

(NULL)

 

BTREE

 

 

stock

0

stock_idx1

3

type_id

A

1

(NULL)

(NULL)

 

BTREE

 

 

stock

1

stock_idx2

1

name

A

1

(NULL)

(NULL)

YES

BTREE

 

 

stock

1

stock_idx3

1

dbxref_id

A

1

(NULL)

(NULL)

YES

BTREE

 

 

stock

1

stock_idx4

1

organism_id

A

1

(NULL)

(NULL)

YES

BTREE

 

 

stock

1

stock_idx5

1

type_id

A

1

(NULL)

(NULL)

 

BTREE

 

 

stock

1

stock_idx6

1

uniquename

A

1

(NULL)

(NULL)

 

BTREE

 

 

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

stock_fk1

dbxref

`dbxref_id`

`dbxref_id`

ON DELETE SET NULL,

stock_fk2

organism

`organism_id`

`organism_id`

ON DELETE CASCADE,

stock_fk3

cvterm

`type_id`

`cvterm_id`

ON DELETE CASCADE

Back

 
stockprop  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

stockprop_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

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

 

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

stockprop

0

PRIMARY

1

stockprop_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

stockprop

0

stockprop_idx1

1

stock_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

stockprop

0

stockprop_idx1

2

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

stockprop

0

stockprop_idx1

3

rank

A

0

(NULL)

(NULL)

 

BTREE

 

 

stockprop

1

stockprop_idx2

1

stock_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

stockprop

1

stockprop_idx3

1

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

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

stockprop_fk1

stock

`stock_id`

`stock_id`

ON DELETE CASCADE,

stockprop_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