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

Application 2.2.1 Tool 2.10 OMS Schema

ibdbv2-dms

 

 
cv  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

cv_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

name

varchar(255)

utf8_general_ci

NO

UNI

(NULL)

 

select,insert,update,references

 

definition

varchar(255)

utf8_general_ci

YES

 

(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

cv

0

PRIMARY

1

cv_id

A

11

(NULL)

(NULL)

 

BTREE

 

 

cv

0

cv_idx1

1

name

A

11

(NULL)

(NULL)

 

BTREE

 

 

Back

 
cvterm  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

cvterm_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

cv_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

name

varchar(200)

utf8_general_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

definition

varchar(255)

utf8_general_ci

YES

 

(NULL)

 

select,insert,update,references

 

dbxref_id

int(11)

(NULL)

YES

UNI

(NULL)

 

select,insert,update,references

 

is_obsolete

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

is_relationshiptype

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

cvterm

0

PRIMARY

1

cvterm_id

A

415

(NULL)

(NULL)

 

BTREE

 

 

cvterm

0

cvterm_idx1

1

name

A

415

(NULL)

(NULL)

 

BTREE

 

 

cvterm

0

cvterm_idx1

2

cv_id

A

415

(NULL)

(NULL)

 

BTREE

 

 

cvterm

0

cvterm_idx1

3

is_obsolete

A

415

(NULL)

(NULL)

 

BTREE

 

 

cvterm

0

cvterm_idx2

1

dbxref_id

A

4

(NULL)

(NULL)

YES

BTREE

 

 

cvterm

1

cvterm_idx3

1

cv_id

A

51

(NULL)

(NULL)

 

BTREE

 

 

cvterm

1

cvterm_idx4

1

name

A

415

(NULL)

(NULL)

 

BTREE

 

 

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

cvterm_fk1

cv

`cv_id`

`cv_id`

ON DELETE CASCADE

Back

 
cvterm_relationship  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

cvterm_relationship_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

type_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

subject_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

object_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

cvterm_relationship

0

PRIMARY

1

cvterm_relationship_id

A

515

(NULL)

(NULL)

 

BTREE

 

 

cvterm_relationship

0

cvterm_relationship_c1

1

subject_id

A

515

(NULL)

(NULL)

 

BTREE

 

 

cvterm_relationship

0

cvterm_relationship_c1

2

object_id

A

515

(NULL)

(NULL)

 

BTREE

 

 

cvterm_relationship

0

cvterm_relationship_c1

3

type_id

A

515

(NULL)

(NULL)

 

BTREE

 

 

cvterm_relationship

1

cvterm_relationship_idx1

1

type_id

A

9

(NULL)

(NULL)

 

BTREE

 

 

cvterm_relationship

1

cvterm_relationship_idx2

1

subject_id

A

515

(NULL)

(NULL)

 

BTREE

 

 

cvterm_relationship

1

cvterm_relationship_idx3

1

object_id

A

257

(NULL)

(NULL)

 

BTREE

 

 

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

cvterm_relationship_fk1

cvterm

`type_id`

`cvterm_id`

ON DELETE CASCADE,

cvterm_relationship_fk2

cvterm

`subject_id`

`cvterm_id`

ON DELETE CASCADE,

cvterm_relationship_fk3

cvterm

`object_id`

`cvterm_id`

ON DELETE CASCADE

Back

 
cvtermprop  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

cvtermprop_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

cvterm_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(200)

utf8_general_ci

NO

 

 

 

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

cvtermprop

0

PRIMARY

1

cvtermprop_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

cvtermprop

0

cvtermprop_c1

1

cvterm_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

cvtermprop

0

cvtermprop_c1

2

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

cvtermprop

0

cvtermprop_c1

3

value

A

0

(NULL)

(NULL)

 

BTREE

 

 

cvtermprop

0

cvtermprop_c1

4

rank

A

0

(NULL)

(NULL)

 

BTREE

 

 

cvtermprop

1

cvtermprop_idx1

1

cvterm_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

cvtermprop

1

cvtermprop_idx2

1

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

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

cvtermprop_ibfk_1

cvterm

`cvterm_id`

`cvterm_id`

ON DELETE CASCADE,

cvtermprop_ibfk_2

cvterm

`type_id`

`cvterm_id`

ON DELETE CASCADE

Back

 
cvtermsynonym  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

cvtermsynonym_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

cvterm_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

synonym

varchar(200)

utf8_general_ci

NO

 

(NULL)

 

select,insert,update,references

 

type_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

cvtermsynonym

0

PRIMARY

1

cvtermsynonym_id

A

86

(NULL)

(NULL)

 

BTREE

 

 

cvtermsynonym

0

cvtermsynonym_c1

1

cvterm_id

A

86

(NULL)

(NULL)

 

BTREE

 

 

cvtermsynonym

0

cvtermsynonym_c1

2

synonym

A

86

(NULL)

(NULL)

 

BTREE

 

 

cvtermsynonym

1

cvtermsynonym_fk2

1

type_id

A

2

(NULL)

(NULL)

YES

BTREE

 

 

cvtermsynonym

1

cvtermsynonym_idx1

1

cvterm_id

A

86

(NULL)

(NULL)

 

BTREE

 

 

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

cvtermsynonym_fk1

cvterm

`cvterm_id`

`cvterm_id`

ON DELETE CASCADE,

cvtermsynonym_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