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

Application 2.2.1 Tool 2.10 DMS Study Schema

ibdbv2-dms

 

 
project  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

project_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

 

description

varchar(255)

utf8_general_ci

NO

 

(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

project

0

PRIMARY

1

project_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

project

0

project_idx1

1

name

A

0

(NULL)

(NULL)

 

BTREE

 

 

Back

 
project_relationship  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

project_relationship_id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

subject_project_id

int(11)

(NULL)

NO

MUL

(NULL)

 

select,insert,update,references

 

object_project_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

project_relationship

0

PRIMARY

1

project_relationship_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

project_relationship

0

project_relationship_idx1

1

subject_project_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

project_relationship

0

project_relationship_idx1

2

object_project_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

project_relationship

0

project_relationship_idx1

3

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

project_relationship

1

project_relationship_idx2

1

object_project_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

project_relationship

1

project_relationship_idx3

1

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

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

project_relationship_fk1

project

`subject_project_id`

`project_id`

ON DELETE CASCADE,

project_relationship_fk2

project

`object_project_id`

`project_id`

ON DELETE CASCADE,

project_relationship_fk3

cvterm

`type_id`

`cvterm_id`

Back

 
projectprop  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

projectprop_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

 

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

projectprop

0

PRIMARY

1

projectprop_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

projectprop

0

projectprop_idx1

1

project_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

projectprop

0

projectprop_idx1

2

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

projectprop

0

projectprop_idx1

3

rank

A

0

(NULL)

(NULL)

 

BTREE

 

 

projectprop

1

projectprop_idx2

1

type_id

A

0

(NULL)

(NULL)

 

BTREE

 

 

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

projectprop_fk1

project

`project_id`

`project_id`

ON DELETE CASCADE,

projectprop_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