Compendium 2.0 Beta 1 Database Schema
 

 
Audit  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

AuditID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Author

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

ItemID

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

AuditDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

Category

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

Action

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Data

longtext

latin1_swedish_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

Audit

0

PRIMARY

1

AuditID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
Clone  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ParentNodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

ChildNodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

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

Clone

0

PRIMARY

1

ParentNodeID

A

0

(NULL)

(NULL)

 

BTREE

 

Clone

0

PRIMARY

2

ChildNodeID

A

0

(NULL)

(NULL)

 

BTREE

 

Clone

1

Clone_ChildNodeID_Ind

1

ChildNodeID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
Code  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

CodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Author

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

Name

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

Description

varchar(100)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Behavior

varchar(255)

latin1_swedish_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

Code

0

PRIMARY

1

CodeID

A

95

(NULL)

(NULL)

 

BTREE

 

Back

 
CodeGroup  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

CodeGroupID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Author

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

Name

varchar(100)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

Description

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(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

CodeGroup

0

PRIMARY

1

CodeGroupID

A

1

(NULL)

(NULL)

 

BTREE

 

Back

 
Connections  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

UserID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Profile

varchar(255)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Type

int(11)

(NULL)

NO

PRI

0

 

select,insert,update,references

 

Server

varchar(255)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

Login

varchar(255)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

Password

varchar(255)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

Name

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Port

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Resource

varchar(255)

latin1_swedish_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

Connections

0

PRIMARY

1

UserID

A

0

(NULL)

(NULL)

 

BTREE

 

Connections

0

PRIMARY

2

Profile

A

0

(NULL)

(NULL)

 

BTREE

 

Connections

0

PRIMARY

3

Type

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
ExtendedNodeType  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ExtendedNodeTypeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Author

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

Name

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Description

varchar(100)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BaseNodeType

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Icon

varchar(200)

latin1_swedish_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

ExtendedNodeType

0

PRIMARY

1

ExtendedNodeTypeID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
ExtendedTypeCode  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ExtendedNodeTypeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

CodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

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

ExtendedTypeCode

0

PRIMARY

1

ExtendedNodeTypeID

A

0

(NULL)

(NULL)

 

BTREE

 

ExtendedTypeCode

0

PRIMARY

2

CodeID

A

0

(NULL)

(NULL)

 

BTREE

 

ExtendedTypeCode

1

ExtendedCode_CodeID_Ind

1

CodeID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
Favorite  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

UserID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

NodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Label

longtext

latin1_swedish_ci

NO

 

(NULL)

 

select,insert,update,references

 

NodeType

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ViewID

varchar(50)

latin1_swedish_ci

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

Favorite

0

PRIMARY

1

UserID

A

1

(NULL)

(NULL)

 

BTREE

 

Favorite

0

PRIMARY

2

NodeID

A

1

(NULL)

(NULL)

 

BTREE

 

Favorite

1

Favorite_NodeID_Ind

1

NodeID

A

1

(NULL)

(NULL)

 

BTREE

 

Favorite

1

FK_Favorite_3

1

ViewID

A

1

(NULL)

(NULL)

YES

BTREE

 

Back

 
GroupCode  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

CodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

CodeGroupID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Author

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(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

GroupCode

0

PRIMARY

1

CodeID

A

9

(NULL)

(NULL)

 

BTREE

 

GroupCode

0

PRIMARY

2

CodeGroupID

A

9

(NULL)

(NULL)

 

BTREE

 

GroupCode

1

GroupCode_CodeGroupID_Ind

1

CodeGroupID

A

2

(NULL)

(NULL)

 

BTREE

 

Back

 
GroupUser  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

UserID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

GroupID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

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

GroupUser

0

PRIMARY

1

UserID

A

0

(NULL)

(NULL)

 

BTREE

 

GroupUser

0

PRIMARY

2

GroupID

A

0

(NULL)

(NULL)

 

BTREE

 

GroupUser

1

GroupUser_GroupID_Ind

1

GroupID

A

0

(NULL)

(NULL)

 

BTREE

 

GroupUser

1

UserGroup_UserID_Ind

1

UserID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
Link  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

LinkID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Author

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

LinkType

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

OriginalID

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FromNode

varchar(50)

latin1_swedish_ci

NO

MUL

 

 

select,insert,update,references

 

ToNode

varchar(50)

latin1_swedish_ci

NO

MUL

 

 

select,insert,update,references

 

ViewID

varchar(50)

latin1_swedish_ci

NO

 

0

 

select,insert,update,references

 

Label

text

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CurrentStatus

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

Link

0

PRIMARY

1

LinkID

A

8473

(NULL)

(NULL)

 

BTREE

 

Link

1

Link_FromNode_Ind

1

FromNode

A

8473

(NULL)

(NULL)

 

BTREE

 

Link

1

Link_ToNode_Ind

1

ToNode

A

8473

(NULL)

(NULL)

 

BTREE

 

Back

 
LinkedFile  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

FileID

varchar(50)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

FileName

varchar(255)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

FileSize

int(11)

(NULL)

NO

 

(NULL)

 

select,insert,update,references

 

FileData

longblob

(NULL)

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

LinkedFile

1

LinkedFile_FileID_Ind

1

FileID

A

0

(NULL)

(NULL)

 

BTREE

 

LinkedFile

1

LinkedFile_FileName_Ind

1

FileName

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
MediaIndex  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ViewID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

NodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

MeetingID

varchar(255)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

MediaIndex

double

(NULL)

NO

 

0

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(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

MediaIndex

0

PRIMARY

1

ViewID

A

71

(NULL)

(NULL)

 

BTREE

 

MediaIndex

0

PRIMARY

2

NodeID

A

215

(NULL)

(NULL)

 

BTREE

 

MediaIndex

0

PRIMARY

3

MeetingID

A

215

(NULL)

(NULL)

 

BTREE

 

MediaIndex

1

MediaIndex_NodeID_Ind

1

NodeID

A

215

(NULL)

(NULL)

 

BTREE

 

MediaIndex

1

MediaIndex_MeetingID_Ind

1

MeetingID

A

14

(NULL)

(NULL)

 

BTREE

 

Back

 
Meeting  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

MeetingID

varchar(255)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

MeetingMapID

varchar(50)

latin1_swedish_ci

NO

MUL

 

 

select,insert,update,references

 

MeetingName

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

MeetingDate

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CurrentStatus

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

Meeting

0

PRIMARY

1

MeetingID

A

7

(NULL)

(NULL)

 

BTREE

 

Meeting

1

Meeting_MeetingMapID_Ind

1

MeetingMapID

A

7

(NULL)

(NULL)

 

BTREE

 

Back

 
MovieProperties  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

MoviePropertyID

varchar(50)

latin1_swedish_ci

NO

PRI

(NULL)

 

select,insert,update,references

 

MovieID

varchar(50)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

XPos

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

YPos

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Width

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Height

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Transparency

float

(NULL)

NO

 

1

 

select,insert,update,references

 

CreationDate

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ModificationDate

double

(NULL)

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

MovieProperties

0

PRIMARY

1

MoviePropertyID

A

0

(NULL)

(NULL)

 

BTREE

 

MovieProperties

1

FK_MovieProperties_1

1

MovieID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
Movies  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

MovieID

varchar(50)

latin1_swedish_ci

NO

PRI

(NULL)

 

select,insert,update,references

 

ViewID

varchar(50)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

Link

text

latin1_swedish_ci

NO

 

(NULL)

 

select,insert,update,references

 

CreationDate

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ModificationDate

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

Name

varchar(255)

latin1_swedish_ci

YES

 

 

 

select,insert,update,references

 

StartTime

double

(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

Movies

0

PRIMARY

1

MovieID

A

0

(NULL)

(NULL)

 

BTREE

 

Movies

1

FK_Movies_1

1

ViewID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
Node  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

NodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Author

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

NodeType

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

OriginalID

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ExtendedNodeType

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Label

longtext

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Detail

longtext

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CurrentStatus

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

LastModAuthor

varchar(50)

latin1_swedish_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

Node

0

PRIMARY

1

NodeID

A

9715

(NULL)

(NULL)

 

BTREE

 

Back

 
NodeCode  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

NodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

CodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

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

NodeCode

0

PRIMARY

1

NodeID

A

1963

(NULL)

(NULL)

 

BTREE

 

NodeCode

0

PRIMARY

2

CodeID

A

1963

(NULL)

(NULL)

 

BTREE

 

NodeCode

1

NodeCode_CodeID_Ind

1

CodeID

A

151

(NULL)

(NULL)

 

BTREE

 

Back

 
NodeDetail  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

NodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Author

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

PageNo

int(11)

(NULL)

NO

PRI

0

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

Detail

longtext

latin1_swedish_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

NodeDetail

0

PRIMARY

1

NodeID

A

6800

(NULL)

(NULL)

 

BTREE

 

NodeDetail

0

PRIMARY

2

PageNo

A

6800

(NULL)

(NULL)

 

BTREE

 

Back

 
NodeProperty  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

NodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

UserID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

ShowTags

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

ShowText

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

ShowTrans

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

ShowWeight

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

SmallIcons

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

HideIcons

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

LabelLength

int(11)

(NULL)

NO

 

100

 

select,insert,update,references

 

LabelWidth

int(11)

(NULL)

NO

 

15

 

select,insert,update,references

 

FontSize

int(11)

(NULL)

NO

 

12

 

select,insert,update,references

 

FontFace

varchar(100)

latin1_swedish_ci

NO

 

Arial

 

select,insert,update,references

 

FontStyle

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

NodeProperty

0

PRIMARY

1

UserID

A

0

(NULL)

(NULL)

 

BTREE

 

NodeProperty

0

PRIMARY

2

NodeID

A

0

(NULL)

(NULL)

 

BTREE

 

NodeProperty

1

NodeProperty_NodeID_Ind

1

NodeID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
NodeUserState  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

NodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

UserID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

State

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

NodeUserState

0

PRIMARY

1

NodeID

A

16597

(NULL)

(NULL)

 

BTREE

 

NodeUserState

0

PRIMARY

2

UserID

A

33195

(NULL)

(NULL)

 

BTREE

 

NodeUserState

1

NodeUserState_UserID_Ind

1

UserID

A

5

(NULL)

(NULL)

 

BTREE

 

Back

 
Permission  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ItemID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

GroupID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Permission

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

Permission

0

PRIMARY

1

ItemID

A

0

(NULL)

(NULL)

 

BTREE

 

Permission

0

PRIMARY

2

GroupID

A

0

(NULL)

(NULL)

 

BTREE

 

Permission

1

Permission_GroupID_Ind

1

GroupID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
Preference  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

UserID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Property

varchar(100)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Contents

varchar(255)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

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

Preference

0

PRIMARY

1

UserID

A

0

(NULL)

(NULL)

 

BTREE

 

Preference

0

PRIMARY

2

Property

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
ReferenceNode  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

NodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Source

text

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ImageSource

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ImageWidth

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ImageHeight

int(11)

(NULL)

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

ReferenceNode

0

PRIMARY

1

NodeID

A

2392

(NULL)

(NULL)

 

BTREE

 

Back

 
ShortCutNode  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

NodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

ReferenceID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

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

ShortCutNode

0

PRIMARY

1

NodeID

A

3

(NULL)

(NULL)

 

BTREE

 

ShortCutNode

0

PRIMARY

2

ReferenceID

A

3

(NULL)

(NULL)

 

BTREE

 

Back

 
System  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

Property

varchar(100)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Contents

varchar(255)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

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

System

0

PRIMARY

1

Property

A

9

(NULL)

(NULL)

 

BTREE

 

Back

 
UserGroup  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

GroupID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

UserID

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

Name

varchar(100)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

Description

varchar(255)

latin1_swedish_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

UserGroup

0

PRIMARY

1

GroupID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
Users  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

UserID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Author

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

Login

varchar(20)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

Name

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Password

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

Description

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

HomeView

varchar(50)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

IsAdministrator

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

CurrentStatus

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

LinkView

varchar(50)

latin1_swedish_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

Users

0

PRIMARY

1

UserID

A

7

(NULL)

(NULL)

 

BTREE

 

Back

 
ViewLayer  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

UserID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

ViewID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

Scribble

longtext

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Background

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Grid

varchar(255)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

Shapes

longtext

latin1_swedish_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

ViewLayer

0

PRIMARY

1

UserID

A

2

(NULL)

(NULL)

 

BTREE

 

ViewLayer

0

PRIMARY

2

ViewID

A

1312

(NULL)

(NULL)

 

BTREE

 

ViewLayer

1

ViewLayer_ViewID_Ind

1

ViewID

A

1312

(NULL)

(NULL)

 

BTREE

 

Back

 
ViewLink  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ViewID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

LinkID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

CurrentStatus

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

LabelWrapWidth

int(11)

(NULL)

NO

 

20

 

select,insert,update,references

 

ArrowType

int(11)

(NULL)

NO

 

1

 

select,insert,update,references

 

LinkStyle

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

LinkDashed

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

LinkWeight

int(11)

(NULL)

NO

 

1

 

select,insert,update,references

 

LinkColour

int(11)

(NULL)

NO

 

-16777216

 

select,insert,update,references

 

FontSize

int(11)

(NULL)

NO

 

12

 

select,insert,update,references

 

FontFace

varchar(100)

latin1_swedish_ci

NO

 

Arial

 

select,insert,update,references

 

FontStyle

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Foreground

int(11)

(NULL)

NO

 

-16777216

 

select,insert,update,references

 

Background

int(11)

(NULL)

NO

 

-1

 

select,insert,update,references

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

ViewLink

0

PRIMARY

1

ViewID

A

997

(NULL)

(NULL)

 

BTREE

 

ViewLink

0

PRIMARY

2

LinkID

A

8977

(NULL)

(NULL)

 

BTREE

 

ViewLink

1

ViewLink_LinkID_Ind

1

LinkID

A

8977

(NULL)

(NULL)

 

BTREE

 

Back

 
ViewNode  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ViewID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

NodeID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

XPos

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

YPos

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

CreationDate

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ModificationDate

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CurrentStatus

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

ShowTags

char(1)

latin1_swedish_ci

NO

 

Y

 

select,insert,update,references

 

ShowText

char(1)

latin1_swedish_ci

NO

 

Y

 

select,insert,update,references

 

ShowTrans

char(1)

latin1_swedish_ci

NO

 

Y

 

select,insert,update,references

 

ShowWeight

char(1)

latin1_swedish_ci

NO

 

Y

 

select,insert,update,references

 

SmallIcon

char(1)

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

HideIcon

char(1)

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

LabelWrapWidth

int(11)

(NULL)

NO

 

20

 

select,insert,update,references

 

FontSize

int(11)

(NULL)

NO

 

12

 

select,insert,update,references

 

FontFace

varchar(100)

latin1_swedish_ci

NO

 

Arial

 

select,insert,update,references

 

FontStyle

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Foreground

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Background

int(11)

(NULL)

NO

 

-1

 

select,insert,update,references

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

ViewNode

0

PRIMARY

1

ViewID

A

2312

(NULL)

(NULL)

 

BTREE

 

ViewNode

0

PRIMARY

2

NodeID

A

16187

(NULL)

(NULL)

 

BTREE

 

ViewNode

1

ViewNode_NodeID_Ind

1

NodeID

A

16187

(NULL)

(NULL)

 

BTREE

 

Back

 
ViewProperty  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

UserID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

ViewID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

HorizontalScroll

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

VerticalScroll

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Width

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Height

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

XPosition

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

YPosition

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

IsIcon

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

IsMaximum

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

ShowTags

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

ShowText

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

ShowTrans

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

ShowWeight

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

SmallIcons

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

HideIcons

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

LabelLength

int(11)

(NULL)

NO

 

100

 

select,insert,update,references

 

LabelWidth

int(11)

(NULL)

NO

 

15

 

select,insert,update,references

 

FontSize

int(11)

(NULL)

NO

 

12

 

select,insert,update,references

 

FontFace

varchar(100)

latin1_swedish_ci

NO

 

Arial

 

select,insert,update,references

 

FontStyle

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

ViewProperty

0

PRIMARY

1

UserID

A

6

(NULL)

(NULL)

 

BTREE

 

ViewProperty

0

PRIMARY

2

ViewID

A

559

(NULL)

(NULL)

 

BTREE

 

ViewProperty

1

ViewProperty_ViewID_Ind

1

ViewID

A

559

(NULL)

(NULL)

 

BTREE

 

Back

 
ViewTimeNode  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ViewTimeNodeID

varchar(50)

latin1_swedish_ci

NO

PRI

(NULL)

 

select,insert,update,references

 

ViewID

varchar(50)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

NodeID

varchar(50)

latin1_swedish_ci

NO

MUL

(NULL)

 

select,insert,update,references

 

TimeToShow

double

(NULL)

NO

 

0

 

select,insert,update,references

 

TimeToHide

double

(NULL)

NO

 

-1

 

select,insert,update,references

 

XPos

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

YPos

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

CreationDate

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

ModificationDate

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CurrentStatus

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

ViewTimeNode

0

PRIMARY

1

ViewTimeNodeID

A

0

(NULL)

(NULL)

 

BTREE

 

ViewTimeNode

1

ViewTimeNode_NodeID_Ind

1

NodeID

A

0

(NULL)

(NULL)

 

BTREE

 

ViewTimeNode

1

FK_ViewTimeNode_1

1

ViewID

A

0

(NULL)

(NULL)

 

BTREE

 

Back

 
Workspace  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

WorkspaceID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

UserID

varchar(50)

latin1_swedish_ci

NO

MUL

 

 

select,insert,update,references

 

Name

varchar(100)

latin1_swedish_ci

NO

 

 

 

select,insert,update,references

 

CreationDate

double

(NULL)

NO

 

0

 

select,insert,update,references

 

ModificationDate

double

(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

Workspace

0

PRIMARY

1

WorkspaceID

A

3

(NULL)

(NULL)

 

BTREE

 

Workspace

1

Workspace_UserID_Ind

1

UserID

A

3

(NULL)

(NULL)

 

BTREE

 

Back

 
WorkspaceView  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

WorkspaceID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

ViewID

varchar(50)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

HorizontalScroll

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

VerticalScroll

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Width

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

Height

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

XPosition

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

YPosition

int(11)

(NULL)

NO

 

0

 

select,insert,update,references

 

IsIcon

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

 

IsMaximum

enum('N','Y')

latin1_swedish_ci

NO

 

N

 

select,insert,update,references

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

WorkspaceView

0

PRIMARY

1

WorkspaceID

A

0

(NULL)

(NULL)

 

BTREE

 

WorkspaceView

0

PRIMARY

2

ViewID

A

0

(NULL)

(NULL)

 

BTREE

 

WorkspaceView

1

WorkspaceView_ViewID_Ind

1

ViewID

A

0

(NULL)

(NULL)

 

BTREE

 

Back