category

ColumnTypeNullDefault Links to Comments MIME
id (Primary)int(11)No
namevarchar(200)No
descriptiontextYesNULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid3ANo

contact

ColumnTypeNullDefault Links to Comments MIME
id (Primary)int(11)No
namevarchar(50)No
lastnamevarchar(50)YesNULL
emailvarchar(255)No
addressvarchar(255)YesNULL
phonevarchar(255)YesNULL
imagevarchar(255)YesNULL
is_activetinyint(1)No1
created_atdatetimeNo

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

event

ColumnTypeNullDefault Links to Comments MIME
id (Primary)int(11)No
titlevarchar(100)No
descriptiontextNo
date_atvarchar(50)No
time_atvarchar(50)No
created_atdatetimeNo
category_idint(11)YesNULL category -> id
user_idint(11)No user -> id
project_idint(11)YesNULL project -> id

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
user_idBTREENoNouser_id0ANo
category_idBTREENoNocategory_id0AYes
project_idBTREENoNoproject_id0AYes

project

ColumnTypeNullDefault Links to Comments MIME
id (Primary)int(11)No
namevarchar(200)No
descriptiontextYesNULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

user

ColumnTypeNullDefault Links to Comments MIME
id (Primary)int(11)No
usernamevarchar(50)No
namevarchar(50)No
lastnamevarchar(50)No
emailvarchar(255)No
passwordvarchar(60)No
is_activetinyint(1)No1
is_admintinyint(1)No0
created_atdatetimeYesNULL

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo