Wednesday 31 October 2012

LIferay Database Tables

Introduction
Liferay maintains all its data and content inside the tables but what tables? and which data is getting stored in which table? I always come across such type of questions.
for the same I thought of summing up all in all I got to know through my experience.

This will be for the Liferay 6.1

Summation
Schema for database 'lportal61' -->
lportal61
&nbsp
&nbsp
account_ &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
accountId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
parentAccountId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
name
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
legalName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
legalId
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
legalType
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
sicCode
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
tickerSymbol
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
industry
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
type_
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
size_
varchar(75)
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 Index
comment
account_
0
PRIMARY
1
accountId
A
1
(NULL)
(NULL)
BTREE
Back

&nbsp
address &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
addressId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
classNameId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
classPK
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
street1
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
street2
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
street3
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
city
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
zip
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
regionId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
countryId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
typeId
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
mailing
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
primary_
tinyint(4)
(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 Index
comment
address
0
PRIMARY
1
addressId
A
0
(NULL)
(NULL)
BTREE
address
1
IX_93D5AD4E
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_ABD7DAC0
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_ABD7DAC0
2
classNameId
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_71CB1123
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_71CB1123
2
classNameId
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_71CB1123
3
classPK
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_923BD178
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_923BD178
2
classNameId
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_923BD178
3
classPK
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_923BD178
4
mailing
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_9226DBB4
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_9226DBB4
2
classNameId
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_9226DBB4
3
classPK
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_9226DBB4
4
primary_
A
0
(NULL)
(NULL)
YES
BTREE
address
1
IX_5BC8B0D4
1
userId
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
announcementsdelivery &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
deliveryId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
type_
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
email
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
sms
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
website
tinyint(4)
(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 Index
comment
announcementsdelivery
0
PRIMARY
1
deliveryId
A
3
(NULL)
(NULL)
BTREE
announcementsdelivery
0
IX_BA4413D5
1
userId
A
3
(NULL)
(NULL)
YES
BTREE
announcementsdelivery
0
IX_BA4413D5
2
type_
A
3
(NULL)
(NULL)
YES
BTREE
announcementsdelivery
1
IX_6EDB9600
1
userId
A
3
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
announcementsentry &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
entryId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
classNameId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
classPK
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
title
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
content
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
url
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
type_
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
displayDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
expirationDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
priority
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
alert
tinyint(4)
(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 Index
comment
announcementsentry
0
PRIMARY
1
entryId
A
0
(NULL)
(NULL)
BTREE
announcementsentry
1
IX_A6EF0B81
1
classNameId
A
0
(NULL)
(NULL)
YES
BTREE
announcementsentry
1
IX_A6EF0B81
2
classPK
A
0
(NULL)
(NULL)
YES
BTREE
announcementsentry
1
IX_14F06A6B
1
classNameId
A
0
(NULL)
(NULL)
YES
BTREE
announcementsentry
1
IX_14F06A6B
2
classPK
A
0
(NULL)
(NULL)
YES
BTREE
announcementsentry
1
IX_14F06A6B
3
alert
A
0
(NULL)
(NULL)
YES
BTREE
announcementsentry
1
IX_D49C2E66
1
userId
A
0
(NULL)
(NULL)
YES
BTREE
announcementsentry
1
IX_1AFBDE08
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
announcementsflag &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
flagId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
entryId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
value
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 Index
comment
announcementsflag
0
PRIMARY
1
flagId
A
0
(NULL)
(NULL)
BTREE
announcementsflag
0
IX_4539A99C
1
userId
A
0
(NULL)
(NULL)
YES
BTREE
announcementsflag
0
IX_4539A99C
2
entryId
A
0
(NULL)
(NULL)
YES
BTREE
announcementsflag
0
IX_4539A99C
3
value
A
0
(NULL)
(NULL)
YES
BTREE
announcementsflag
1
IX_9C7EB9F
1
entryId
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
assetcategory &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
categoryId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
parentCategoryId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
leftCategoryId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
rightCategoryId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
name
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
title
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
vocabularyId
bigint(20)
(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
assetcategory
0
PRIMARY
1
categoryId
A
0
(NULL)
(NULL)
BTREE
assetcategory
0
IX_BE4DF2BF
1
parentCategoryId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
0
IX_BE4DF2BF
2
name
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
0
IX_BE4DF2BF
3
vocabularyId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
0
IX_E8D019AA
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
0
IX_E8D019AA
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_E639E2F6
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_2008FACB
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_2008FACB
2
vocabularyId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_D61ABE08
1
name
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_D61ABE08
2
vocabularyId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_7BB1826B
1
parentCategoryId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_9DDD15EA
1
parentCategoryId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_9DDD15EA
2
name
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_B185E980
1
parentCategoryId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_B185E980
2
vocabularyId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_4D37BB00
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
assetcategory
1
IX_287B1F89
1
vocabularyId
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
assetcategoryproperty &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
categoryPropertyId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
categoryId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
key_
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
value
varchar(75)
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 Index
comment
assetcategoryproperty
0
PRIMARY
1
categoryPropertyId
A
0
(NULL)
(NULL)
BTREE
assetcategoryproperty
0
IX_DBD111AA
1
categoryId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategoryproperty
0
IX_DBD111AA
2
key_
A
0
(NULL)
(NULL)
YES
BTREE
assetcategoryproperty
1
IX_99DA856
1
categoryId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategoryproperty
1
IX_8654719F
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategoryproperty
1
IX_52340033
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
assetcategoryproperty
1
IX_52340033
2
key_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
assetentries_assetcategories &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
entryId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
categoryId
bigint(20)
(NULL)
NO
PRI
(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
assetentries_assetcategories
0
PRIMARY
1
entryId
A
0
(NULL)
(NULL)
BTREE
assetentries_assetcategories
0
PRIMARY
2
categoryId
A
0
(NULL)
(NULL)
BTREE
assetentries_assetcategories
1
IX_A188F560
1
categoryId
A
0
(NULL)
(NULL)
BTREE
assetentries_assetcategories
1
IX_E119938A
1
entryId
A
0
(NULL)
(NULL)
BTREE
Back

&nbsp
assetentries_assettags &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
entryId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
tagId
bigint(20)
(NULL)
NO
PRI
(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
assetentries_assettags
0
PRIMARY
1
entryId
A
0
(NULL)
(NULL)
BTREE
assetentries_assettags
0
PRIMARY
2
tagId
A
0
(NULL)
(NULL)
BTREE
assetentries_assettags
1
IX_2ED82CAD
1
entryId
A
0
(NULL)
(NULL)
BTREE
assetentries_assettags
1
IX_B2A61B55
1
tagId
A
0
(NULL)
(NULL)
BTREE
Back

&nbsp
assetentry &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
entryId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
classNameId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
classPK
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
classUuid
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
classTypeId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
visible
tinyint(4)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
startDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
endDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
publishDate
datetime
(NULL)
YES
MUL
(NULL)
select,insert,update,references
expirationDate
datetime
(NULL)
YES
MUL
(NULL)
select,insert,update,references
mimeType
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
title
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
summary
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
url
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
layoutUuid
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
height
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
width
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
priority
double
(NULL)
YES
(NULL)
select,insert,update,references
viewCount
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 Index
comment
assetentry
0
PRIMARY
1
entryId
A
22
(NULL)
(NULL)
BTREE
assetentry
0
IX_1E9D371D
1
classNameId
A
4
(NULL)
(NULL)
YES
BTREE
assetentry
0
IX_1E9D371D
2
classPK
A
22
(NULL)
(NULL)
YES
BTREE
assetentry
1
IX_FC1F9C7B
1
classUuid
A
22
(NULL)
(NULL)
YES
BTREE
assetentry
1
IX_7306C60
1
companyId
A
2
(NULL)
(NULL)
YES
BTREE
assetentry
1
IX_75D42FF9
1
expirationDate
A
2
(NULL)
(NULL)
YES
BTREE
assetentry
1
IX_1EBA6821
1
groupId
A
22
(NULL)
(NULL)
YES
BTREE
assetentry
1
IX_1EBA6821
2
classUuid
A
22
(NULL)
(NULL)
YES
BTREE
assetentry
1
IX_2E4E3885
1
publishDate
A
2
(NULL)
(NULL)
YES
BTREE
assetentry
1
IX_9029E15A
1
visible
A
2
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
assetlink &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
linkId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
entryId1
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
entryId2
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
type_
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
weight
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 Index
comment
assetlink
0
PRIMARY
1
linkId
A
0
(NULL)
(NULL)
BTREE
assetlink
0
IX_8F542794
1
entryId1
A
0
(NULL)
(NULL)
YES
BTREE
assetlink
0
IX_8F542794
2
entryId2
A
0
(NULL)
(NULL)
YES
BTREE
assetlink
0
IX_8F542794
3
type_
A
0
(NULL)
(NULL)
YES
BTREE
assetlink
1
IX_128516C8
1
entryId1
A
0
(NULL)
(NULL)
YES
BTREE
assetlink
1
IX_56E0AB21
1
entryId1
A
0
(NULL)
(NULL)
YES
BTREE
assetlink
1
IX_56E0AB21
2
entryId2
A
0
(NULL)
(NULL)
YES
BTREE
assetlink
1
IX_14D5A20D
1
entryId1
A
0
(NULL)
(NULL)
YES
BTREE
assetlink
1
IX_14D5A20D
2
type_
A
0
(NULL)
(NULL)
YES
BTREE
assetlink
1
IX_12851A89
1
entryId2
A
0
(NULL)
(NULL)
YES
BTREE
assetlink
1
IX_91F132C
1
entryId2
A
0
(NULL)
(NULL)
YES
BTREE
assetlink
1
IX_91F132C
2
type_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
assettag &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
tagId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
name
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
assetCount
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 Index
comment
assettag
0
PRIMARY
1
tagId
A
0
(NULL)
(NULL)
BTREE
assettag
1
IX_7C9E46BA
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
assettag
1
IX_D63322F9
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
assettag
1
IX_D63322F9
2
name
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
assettagproperty &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
tagPropertyId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
tagId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
key_
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
value
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 Index
comment
assettagproperty
0
PRIMARY
1
tagPropertyId
A
0
(NULL)
(NULL)
BTREE
assettagproperty
0
IX_2C944354
1
tagId
A
0
(NULL)
(NULL)
YES
BTREE
assettagproperty
0
IX_2C944354
2
key_
A
0
(NULL)
(NULL)
YES
BTREE
assettagproperty
1
IX_DFF1F063
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
assettagproperty
1
IX_13805BF7
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
assettagproperty
1
IX_13805BF7
2
key_
A
0
(NULL)
(NULL)
YES
BTREE
assettagproperty
1
IX_3269E180
1
tagId
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
assettagstats &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
tagStatsId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
tagId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
classNameId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
assetCount
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 Index
comment
assettagstats
0
PRIMARY
1
tagStatsId
A
0
(NULL)
(NULL)
BTREE
assettagstats
0
IX_56682CC4
1
tagId
A
0
(NULL)
(NULL)
YES
BTREE
assettagstats
0
IX_56682CC4
2
classNameId
A
0
(NULL)
(NULL)
YES
BTREE
assettagstats
1
IX_50702693
1
classNameId
A
0
(NULL)
(NULL)
YES
BTREE
assettagstats
1
IX_9464CA
1
tagId
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
assetvocabulary &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
vocabularyId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
name
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
title
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
settings_
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 Index
comment
assetvocabulary
0
PRIMARY
1
vocabularyId
A
1
(NULL)
(NULL)
BTREE
assetvocabulary
0
IX_C0AAD74D
1
groupId
A
1
(NULL)
(NULL)
YES
BTREE
assetvocabulary
0
IX_C0AAD74D
2
name
A
1
(NULL)
(NULL)
YES
BTREE
assetvocabulary
0
IX_1B2B8792
1
uuid_
A
1
(NULL)
(NULL)
YES
BTREE
assetvocabulary
0
IX_1B2B8792
2
groupId
A
1
(NULL)
(NULL)
YES
BTREE
assetvocabulary
1
IX_B22D908C
1
companyId
A
1
(NULL)
(NULL)
YES
BTREE
assetvocabulary
1
IX_B6B8CA0E
1
groupId
A
1
(NULL)
(NULL)
YES
BTREE
assetvocabulary
1
IX_55F58818
1
uuid_
A
1
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
blogsentry &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
entryId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
title
varchar(150)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
urlTitle
varchar(150)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
content
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
displayDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
allowPingbacks
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
allowTrackbacks
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
trackbacks
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
smallImage
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
smallImageId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
smallImageURL
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
status
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
statusByUserId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
statusByUserName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
statusDate
datetime
(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 Index
comment
blogsentry
0
PRIMARY
1
entryId
A
0
(NULL)
(NULL)
BTREE
blogsentry
0
IX_DB780A20
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
0
IX_DB780A20
2
urlTitle
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
0
IX_1B1040FD
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
0
IX_1B1040FD
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_72EF6041
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_430D791F
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_430D791F
2
displayDate
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_BB0C2905
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_BB0C2905
2
displayDate
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_BB0C2905
3
status
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_EB2DCE27
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_EB2DCE27
2
status
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_8CACE77B
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_8CACE77B
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_A5F57B61
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_A5F57B61
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_A5F57B61
3
status
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_81A50303
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_621E19D
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_621E19D
2
displayDate
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_F0E73383
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_F0E73383
2
displayDate
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_F0E73383
3
status
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_1EFD8EE9
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_1EFD8EE9
2
status
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_FBDE0AA3
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_FBDE0AA3
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_FBDE0AA3
3
displayDate
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_DA04F689
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_DA04F689
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_DA04F689
3
displayDate
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_DA04F689
4
status
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_49E15A23
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_49E15A23
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_49E15A23
3
status
A
0
(NULL)
(NULL)
YES
BTREE
blogsentry
1
IX_69157A4D
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
blogsstatsuser &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
statsUserId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
entryCount
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
lastPostDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
ratingsTotalEntries
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
ratingsTotalScore
double
(NULL)
YES
(NULL)
select,insert,update,references
ratingsAverageScore
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 Index
comment
blogsstatsuser
0
PRIMARY
1
statsUserId
A
0
(NULL)
(NULL)
BTREE
blogsstatsuser
0
IX_82254C25
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsstatsuser
0
IX_82254C25
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
blogsstatsuser
1
IX_90CDA39A
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
blogsstatsuser
1
IX_90CDA39A
2
entryCount
A
0
(NULL)
(NULL)
YES
BTREE
blogsstatsuser
1
IX_43840EEB
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsstatsuser
1
IX_28C78D5C
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
blogsstatsuser
1
IX_28C78D5C
2
entryCount
A
0
(NULL)
(NULL)
YES
BTREE
blogsstatsuser
1
IX_BB51F1D9
1
userId
A
0
(NULL)
(NULL)
YES
BTREE
blogsstatsuser
1
IX_507BA031
1
userId
A
0
(NULL)
(NULL)
YES
BTREE
blogsstatsuser
1
IX_507BA031
2
lastPostDate
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
bookmarksentry &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
entryId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
resourceBlockId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
folderId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
name
varchar(255)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
url
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
visits
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
priority
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 Index
comment
bookmarksentry
0
PRIMARY
1
entryId
A
0
(NULL)
(NULL)
BTREE
bookmarksentry
0
IX_EAA02A91
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksentry
0
IX_EAA02A91
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksentry
1
IX_E52FF7EF
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksentry
1
IX_5200100C
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksentry
1
IX_5200100C
2
folderId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksentry
1
IX_E2E9F129
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksentry
1
IX_E2E9F129
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksentry
1
IX_E848278F
1
resourceBlockId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksentry
1
IX_B670BA39
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
bookmarksfolder &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
folderId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
resourceBlockId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
parentFolderId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
name
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
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 Index
comment
bookmarksfolder
0
PRIMARY
1
folderId
A
0
(NULL)
(NULL)
BTREE
bookmarksfolder
0
IX_DC2F8927
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksfolder
0
IX_DC2F8927
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksfolder
1
IX_2ABA25D7
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksfolder
1
IX_7F703619
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksfolder
1
IX_967799C0
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksfolder
1
IX_967799C0
2
parentFolderId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksfolder
1
IX_28A49BB9
1
resourceBlockId
A
0
(NULL)
(NULL)
YES
BTREE
bookmarksfolder
1
IX_451E7AE3
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
browsertracker &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
browserTrackerId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
UNI
(NULL)
select,insert,update,references
browserKey
bigint(20)
(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 Index
comment
browsertracker
0
PRIMARY
1
browserTrackerId
A
0
(NULL)
(NULL)
BTREE
browsertracker
0
IX_E7B95510
1
userId
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
calevent &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
eventId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
title
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
location
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
startDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
endDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
durationHour
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
durationMinute
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
allDay
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
timeZoneSensitive
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
type_
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
repeating
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
recurrence
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
remindBy
int(11)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
firstReminder
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
secondReminder
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 Index
comment
calevent
0
PRIMARY
1
eventId
A
0
(NULL)
(NULL)
BTREE
calevent
0
IX_5CCE79C8
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
calevent
0
IX_5CCE79C8
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_D6FD9496
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_12EE4898
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_4FDDD2BF
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_4FDDD2BF
2
repeating
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_FCD7C63D
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_FCD7C63D
2
type_
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_FD93CBFA
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_FD93CBFA
2
type_
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_FD93CBFA
3
repeating
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_F6006202
1
remindBy
A
0
(NULL)
(NULL)
YES
BTREE
calevent
1
IX_C1AD2122
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
classname_ &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
classNameId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
value
varchar(200)
latin1_swedish_ci
YES
UNI
(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
classname_
0
PRIMARY
1
classNameId
A
156
(NULL)
(NULL)
BTREE
classname_
0
IX_B27A301F
1
value
A
156
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
clustergroup &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
clusterGroupId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
name
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
clusterNodeIds
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
wholeCluster
tinyint(4)
(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 Index
comment
clustergroup
0
PRIMARY
1
clusterGroupId
A
0
(NULL)
(NULL)
BTREE
Back

&nbsp
company &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
companyId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
accountId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
webId
varchar(75)
latin1_swedish_ci
YES
UNI
(NULL)
select,insert,update,references
key_
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
mx
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
homeURL
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
logoId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
system
tinyint(4)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
maxUsers
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
active_
tinyint(4)
(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 Index
comment
company
0
PRIMARY
1
companyId
A
1
(NULL)
(NULL)
BTREE
company
0
IX_EC00543C
1
webId
A
1
(NULL)
(NULL)
YES
BTREE
company
1
IX_38EFE3FD
1
logoId
A
1
(NULL)
(NULL)
YES
BTREE
company
1
IX_12566EC2
1
mx
A
1
(NULL)
(NULL)
YES
BTREE
company
1
IX_35E3E7C6
1
system
A
1
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
contact_ &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
contactId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
accountId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
parentContactId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
firstName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
middleName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
lastName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
prefixId
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
suffixId
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
male
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
birthday
datetime
(NULL)
YES
(NULL)
select,insert,update,references
smsSn
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
aimSn
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
facebookSn
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
icqSn
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
jabberSn
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
msnSn
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
mySpaceSn
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
skypeSn
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
twitterSn
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
ymSn
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
employeeStatusId
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
employeeNumber
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
jobTitle
varchar(100)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
jobClass
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
hoursOfOperation
varchar(75)
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 Index
comment
contact_
0
PRIMARY
1
contactId
A
2
(NULL)
(NULL)
BTREE
contact_
1
IX_66D496A3
1
companyId
A
2
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
counter &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
name
varchar(75)
latin1_swedish_ci
NO
PRI
(NULL)
select,insert,update,references
currentId
bigint(20)
(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 Index
comment
counter
0
PRIMARY
1
name
A
14
(NULL)
(NULL)
BTREE
Back

&nbsp
country &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
countryId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
name
varchar(75)
latin1_swedish_ci
YES
UNI
(NULL)
select,insert,update,references
a2
varchar(75)
latin1_swedish_ci
YES
UNI
(NULL)
select,insert,update,references
a3
varchar(75)
latin1_swedish_ci
YES
UNI
(NULL)
select,insert,update,references
number_
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
idd_
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
zipRequired
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
active_
tinyint(4)
(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
country
0
PRIMARY
1
countryId
A
227
(NULL)
(NULL)
BTREE
country
0
IX_717B97E1
1
a2
A
227
(NULL)
(NULL)
YES
BTREE
country
0
IX_717B9BA2
1
a3
A
227
(NULL)
(NULL)
YES
BTREE
country
0
IX_19DA007B
1
name
A
227
(NULL)
(NULL)
YES
BTREE
country
1
IX_25D734CD
1
active_
A
2
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
cyrususer &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
userId
varchar(75)
latin1_swedish_ci
NO
PRI
(NULL)
select,insert,update,references
password_
varchar(75)
latin1_swedish_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
cyrususer
0
PRIMARY
1
userId
A
0
(NULL)
(NULL)
BTREE
Back

&nbsp
cyrusvirtual &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
emailAddress
varchar(75)
latin1_swedish_ci
NO
PRI
(NULL)
select,insert,update,references
userId
varchar(75)
latin1_swedish_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
cyrusvirtual
0
PRIMARY
1
emailAddress
A
0
(NULL)
(NULL)
BTREE
Back

&nbsp
ddlrecord &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
recordId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
versionUserId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
versionUserName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
DDMStorageId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
recordSetId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
version
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
displayIndex
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 Index
comment
ddlrecord
0
PRIMARY
1
recordId
A
0
(NULL)
(NULL)
BTREE
ddlrecord
0
IX_B4328F39
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecord
0
IX_B4328F39
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecord
1
IX_87A6B599
1
recordSetId
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecord
1
IX_AAC564D3
1
recordSetId
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecord
1
IX_AAC564D3
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecord
1
IX_8BC2F891
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
ddlrecordset &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
recordSetId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
DDMStructureId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
recordSetKey
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
name
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
minDisplayRows
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
scope
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 Index
comment
ddlrecordset
0
PRIMARY
1
recordSetId
A
0
(NULL)
(NULL)
BTREE
ddlrecordset
0
IX_56DAB121
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecordset
0
IX_56DAB121
2
recordSetKey
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecordset
0
IX_270BA5E1
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecordset
0
IX_270BA5E1
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecordset
1
IX_4FA5969F
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecordset
1
IX_561E44E9
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
ddlrecordversion &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
recordVersionId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
DDMStorageId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
recordSetId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
recordId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
version
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
displayIndex
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
status
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
statusByUserId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
statusByUserName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
statusDate
datetime
(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 Index
comment
ddlrecordversion
0
PRIMARY
1
recordVersionId
A
0
(NULL)
(NULL)
BTREE
ddlrecordversion
0
IX_C79E347
1
recordId
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecordversion
0
IX_C79E347
2
version
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecordversion
1
IX_2F4DDFE1
1
recordId
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecordversion
1
IX_762ADC7
1
recordId
A
0
(NULL)
(NULL)
YES
BTREE
ddlrecordversion
1
IX_762ADC7
2
status
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
ddmcontent &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
contentId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
name
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
xml
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 Index
comment
ddmcontent
0
PRIMARY
1
contentId
A
0
(NULL)
(NULL)
BTREE
ddmcontent
0
IX_EB9BDE28
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
ddmcontent
0
IX_EB9BDE28
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
ddmcontent
1
IX_E3BAF436
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
ddmcontent
1
IX_50BF1038
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
ddmcontent
1
IX_AE4B50C2
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
ddmstoragelink &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
storageLinkId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
classNameId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
classPK
bigint(20)
(NULL)
YES
UNI
(NULL)
select,insert,update,references
structureId
bigint(20)
(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
ddmstoragelink
0
PRIMARY
1
storageLinkId
A
0
(NULL)
(NULL)
BTREE
ddmstoragelink
0
IX_702D1AD5
1
classPK
A
0
(NULL)
(NULL)
YES
BTREE
ddmstoragelink
1
IX_81776090
1
structureId
A
0
(NULL)
(NULL)
YES
BTREE
ddmstoragelink
1
IX_32A18526
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
ddmstructure &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
structureId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
classNameId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
structureKey
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
name
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
xsd
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
storageType
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
type_
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 Index
comment
ddmstructure
0
PRIMARY
1
structureId
A
28
(NULL)
(NULL)
BTREE
ddmstructure
0
IX_490E7A1E
1
groupId
A
5
(NULL)
(NULL)
YES
BTREE
ddmstructure
0
IX_490E7A1E
2
structureKey
A
28
(NULL)
(NULL)
YES
BTREE
ddmstructure
0
IX_85C7EBE2
1
uuid_
A
28
(NULL)
(NULL)
YES
BTREE
ddmstructure
0
IX_85C7EBE2
2
groupId
A
28
(NULL)
(NULL)
YES
BTREE
ddmstructure
1
IX_31817A62
1
classNameId
A
9
(NULL)
(NULL)
YES
BTREE
ddmstructure
1
IX_C8419FBE
1
groupId
A
5
(NULL)
(NULL)
YES
BTREE
ddmstructure
1
IX_E61809C8
1
uuid_
A
28
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
ddmstructurelink &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
structureLinkId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
classNameId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
classPK
bigint(20)
(NULL)
YES
UNI
(NULL)
select,insert,update,references
structureId
bigint(20)
(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
ddmstructurelink
0
PRIMARY
1
structureLinkId
A
0
(NULL)
(NULL)
BTREE
ddmstructurelink
0
IX_C803899D
1
classPK
A
0
(NULL)
(NULL)
YES
BTREE
ddmstructurelink
1
IX_D43E4208
1
classNameId
A
0
(NULL)
(NULL)
YES
BTREE
ddmstructurelink
1
IX_17692B58
1
structureId
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
ddmtemplate &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
templateId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
structureId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
name
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
type_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
mode_
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
language
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
script
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 Index
comment
ddmtemplate
0
PRIMARY
1
templateId
A
0
(NULL)
(NULL)
BTREE
ddmtemplate
0
IX_1AA75CE3
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
0
IX_1AA75CE3
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
1
IX_DB24DDDD
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
1
IX_33BEF579
1
language
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
1
IX_C9757A51
1
structureId
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
1
IX_5BC0E264
1
structureId
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
1
IX_5BC0E264
2
type_
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
1
IX_5B019FE8
1
structureId
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
1
IX_5B019FE8
2
type_
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
1
IX_5B019FE8
3
mode_
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
1
IX_C4F283C8
1
type_
A
0
(NULL)
(NULL)
YES
BTREE
ddmtemplate
1
IX_F2A243A7
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
dlcontent &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
contentId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
repositoryId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
path_
varchar(255)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
version
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
data_
longblob
(NULL)
YES
(NULL)
select,insert,update,references
size_
bigint(20)
(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 Index
comment
dlcontent
0
PRIMARY
1
contentId
A
0
(NULL)
(NULL)
BTREE
dlcontent
0
IX_FDD1AAA8
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
dlcontent
0
IX_FDD1AAA8
2
repositoryId
A
0
(NULL)
(NULL)
YES
BTREE
dlcontent
0
IX_FDD1AAA8
3
path_
A
0
(NULL)
(NULL)
YES
BTREE
dlcontent
0
IX_FDD1AAA8
4
version
A
0
(NULL)
(NULL)
YES
BTREE
dlcontent
1
IX_6A83A66A
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
dlcontent
1
IX_6A83A66A
2
repositoryId
A
0
(NULL)
(NULL)
YES
BTREE
dlcontent
1
IX_EB531760
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
dlcontent
1
IX_EB531760
2
repositoryId
A
0
(NULL)
(NULL)
YES
BTREE
dlcontent
1
IX_EB531760
3
path_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
dlfileentry &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
fileEntryId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
versionUserId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
versionUserName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
repositoryId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
folderId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
name
varchar(255)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
extension
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
mimeType
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
title
varchar(255)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
extraSettings
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
fileEntryTypeId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
version
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
size_
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
readCount
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
smallImageId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
largeImageId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
custom1ImageId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
custom2ImageId
bigint(20)
(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 Index
comment
dlfileentry
0
PRIMARY
1
fileEntryId
A
0
(NULL)
(NULL)
BTREE
dlfileentry
0
IX_5391712
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
0
IX_5391712
2
folderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
0
IX_5391712
3
name
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
0
IX_ED5CA615
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
0
IX_ED5CA615
2
folderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
0
IX_ED5CA615
3
title
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
0
IX_BC2E7E6A
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
0
IX_BC2E7E6A
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_4CB1B2B4
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_F4AF5636
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_93CF8193
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_93CF8193
2
folderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_29D0AF28
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_29D0AF28
2
folderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_29D0AF28
3
fileEntryTypeId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_43261870
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_43261870
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_D20C434D
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_D20C434D
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_D20C434D
3
folderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentry
1
IX_64F0FE40
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
dlfileentrymetadata &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
fileEntryMetadataId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
DDMStorageId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
DDMStructureId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
fileEntryTypeId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
fileEntryId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
fileVersionId
bigint(20)
(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
dlfileentrymetadata
0
PRIMARY
1
fileEntryMetadataId
A
0
(NULL)
(NULL)
BTREE
dlfileentrymetadata
0
IX_7332B44F
1
DDMStructureId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentrymetadata
0
IX_7332B44F
2
fileVersionId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentrymetadata
1
IX_4F40FE5E
1
fileEntryId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentrymetadata
1
IX_A44636C9
1
fileEntryId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentrymetadata
1
IX_A44636C9
2
fileVersionId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentrymetadata
1
IX_F8E90438
1
fileEntryTypeId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentrymetadata
1
IX_1FE9C04
1
fileVersionId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileentrymetadata
1
IX_D49AB5D1
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
dlfileentrytype &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
fileEntryTypeId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
name
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
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 Index
comment
dlfileentrytype
0
PRIMARY
1
fileEntryTypeId
A
5
(NULL)
(NULL)
BTREE
dlfileentrytype
0
IX_E9B6A85B
1
groupId
A
5
(NULL)
(NULL)
YES
BTREE
dlfileentrytype
0
IX_E9B6A85B
2
name
A
5
(NULL)
(NULL)
YES
BTREE
dlfileentrytype
0
IX_1399D844
1
uuid_
A
5
(NULL)
(NULL)
YES
BTREE
dlfileentrytype
0
IX_1399D844
2
groupId
A
5
(NULL)
(NULL)
YES
BTREE
dlfileentrytype
1
IX_4501FD9C
1
groupId
A
5
(NULL)
(NULL)
YES
BTREE
dlfileentrytype
1
IX_90724726
1
uuid_
A
5
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
dlfileentrytypes_ddmstructures &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
fileEntryTypeId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
structureId
bigint(20)
(NULL)
NO
PRI
(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
dlfileentrytypes_ddmstructures
0
PRIMARY
1
fileEntryTypeId
A
7
(NULL)
(NULL)
BTREE
dlfileentrytypes_ddmstructures
0
PRIMARY
2
structureId
A
7
(NULL)
(NULL)
BTREE
dlfileentrytypes_ddmstructures
1
IX_8373EC7C
1
fileEntryTypeId
A
7
(NULL)
(NULL)
BTREE
dlfileentrytypes_ddmstructures
1
IX_F147CF3F
1
structureId
A
7
(NULL)
(NULL)
BTREE
Back

&nbsp
dlfileentrytypes_dlfolders &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
fileEntryTypeId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
folderId
bigint(20)
(NULL)
NO
PRI
(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
dlfileentrytypes_dlfolders
0
PRIMARY
1
fileEntryTypeId
A
0
(NULL)
(NULL)
BTREE
dlfileentrytypes_dlfolders
0
PRIMARY
2
folderId
A
0
(NULL)
(NULL)
BTREE
dlfileentrytypes_dlfolders
1
IX_5BB6AD6C
1
fileEntryTypeId
A
0
(NULL)
(NULL)
BTREE
dlfileentrytypes_dlfolders
1
IX_6E00A2EC
1
folderId
A
0
(NULL)
(NULL)
BTREE
Back

&nbsp
dlfilerank &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
fileRankId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
fileEntryId
bigint(20)
(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
dlfilerank
0
PRIMARY
1
fileRankId
A
0
(NULL)
(NULL)
BTREE
dlfilerank
0
IX_38F0315
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
dlfilerank
0
IX_38F0315
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
dlfilerank
0
IX_38F0315
3
fileEntryId
A
0
(NULL)
(NULL)
YES
BTREE
dlfilerank
1
IX_A65A1F8B
1
fileEntryId
A
0
(NULL)
(NULL)
YES
BTREE
dlfilerank
1
IX_BAFB116E
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfilerank
1
IX_BAFB116E
2
userId
A
0
(NULL)
(NULL)
YES
BTREE
dlfilerank
1
IX_EED06670
1
userId
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
dlfileshortcut &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
fileShortcutId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
repositoryId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
folderId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
toFileEntryId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
status
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
statusByUserId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
statusByUserName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
statusDate
datetime
(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 Index
comment
dlfileshortcut
0
PRIMARY
1
fileShortcutId
A
0
(NULL)
(NULL)
BTREE
dlfileshortcut
0
IX_FDB4A946
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
dlfileshortcut
0
IX_FDB4A946
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileshortcut
1
IX_B0051937
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileshortcut
1
IX_B0051937
2
folderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileshortcut
1
IX_ECCE311D
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileshortcut
1
IX_ECCE311D
2
folderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileshortcut
1
IX_ECCE311D
3
status
A
0
(NULL)
(NULL)
YES
BTREE
dlfileshortcut
1
IX_4B7247F6
1
toFileEntryId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileshortcut
1
IX_4831EBE4
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
dlfileversion &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
fileVersionId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
repositoryId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
folderId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
fileEntryId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
extension
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
mimeType
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
title
varchar(255)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
changeLog
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
extraSettings
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
fileEntryTypeId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
version
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
size_
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
status
int(11)
(NULL)
YES
(NULL)
select,insert,update,references
statusByUserId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
statusByUserName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
statusDate
datetime
(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 Index
comment
dlfileversion
0
PRIMARY
1
fileVersionId
A
0
(NULL)
(NULL)
BTREE
dlfileversion
0
IX_E2815081
1
fileEntryId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileversion
0
IX_E2815081
2
version
A
0
(NULL)
(NULL)
YES
BTREE
dlfileversion
0
IX_C99B2650
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
dlfileversion
0
IX_C99B2650
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileversion
1
IX_C68DC967
1
fileEntryId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileversion
1
IX_D47BB14D
1
fileEntryId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileversion
1
IX_D47BB14D
2
status
A
0
(NULL)
(NULL)
YES
BTREE
dlfileversion
1
IX_DFD809D3
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileversion
1
IX_DFD809D3
2
folderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfileversion
1
IX_DFD809D3
3
status
A
0
(NULL)
(NULL)
YES
BTREE
dlfileversion
1
IX_4BFABB9A
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
Back

&nbsp
dlfolder &nbsp
Fields
Field Type Collation Null Key Default Extra Privileges Comment
uuid_
varchar(75)
latin1_swedish_ci
YES
MUL
(NULL)
select,insert,update,references
folderId
bigint(20)
(NULL)
NO
PRI
(NULL)
select,insert,update,references
groupId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
companyId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
userId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
userName
varchar(75)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
createDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
modifiedDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
repositoryId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
mountPoint
tinyint(4)
(NULL)
YES
(NULL)
select,insert,update,references
parentFolderId
bigint(20)
(NULL)
YES
MUL
(NULL)
select,insert,update,references
name
varchar(100)
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
description
longtext
latin1_swedish_ci
YES
(NULL)
select,insert,update,references
lastPostDate
datetime
(NULL)
YES
(NULL)
select,insert,update,references
defaultFileEntryTypeId
bigint(20)
(NULL)
YES
(NULL)
select,insert,update,references
overrideFileEntryTypes
tinyint(4)
(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 Index
comment
dlfolder
0
PRIMARY
1
folderId
A
0
(NULL)
(NULL)
BTREE
dlfolder
0
IX_902FD874
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
0
IX_902FD874
2
parentFolderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
0
IX_902FD874
3
name
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
0
IX_3CC1DED2
1
uuid_
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
0
IX_3CC1DED2
2
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
1
IX_A74DB14C
1
companyId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
1
IX_F2EA1ACE
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
1
IX_49C37475
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
1
IX_49C37475
2
parentFolderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
1
IX_2A048EA0
1
groupId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
1
IX_2A048EA0
2
parentFolderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
1
IX_2A048EA0
3
mountPoint
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
1
IX_51556082
1
parentFolderId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
1
IX_51556082
2
name
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder
1
IX_EE29C715
1
repositoryId
A
0
(NULL)
(NULL)
YES
BTREE
dlfolder</

3 comments:

  1. Priyanka Nice post and it would be great if you provide relationship between tables or you can mention description of tables for eg:- User_ table used for handling user details etc etc :)

    ReplyDelete
  2. Hey Priyanka, Hats off to your efforts. Can You provide an E-R Diagram to for database relationship. Hope that provides a clear set of idea.

    ReplyDelete
  3. Hello good day. I need to consult the data model LifeRay . Would it be possible to give me access to the links in the tables ?.

    Greetings and thank you very much.

    ReplyDelete