L o g
f i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
query: LONGTEXT
variables: LONGTEXT
sensitive: TINYINT(4)
cookies: LONGTEXT
userld: INT(11) «FK»
T o k e n
i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
token: VARCHAR(255)
operation: VARCHAR(255)
used: TINYINT(4)
targetUserld: INT(11) «FK»
targetMemberld: INT(11) «FK»
U s e r
id : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
password: VARCHAR(255)
email: VARCHAR(255)
status: E N U M ( 0 , 1 , 2 )
C o u n s e l o r l n f o
f i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
title: VARCHAR(255)
content: T E X T
memberld: INT(11) «FK»
> e M
e m b e r s h i p
f i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
start: DATE
end: DATE
memberld: INT(11) «FK»
U p l o a d
* i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
filename: VARCHAR(255)
uuid: VARCHAR(255)
mimetype: VARCHAR(255)
ownerld: INT(11) «FK»
R e p r e s e n t a t i v e
r i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
firstname: VARCHAR(255)
lastname: VARCHAR(255)
email: VARCHAR(255)
phone: VARCHAR(255)
representsld: INT(11) «FK»
M e m b e r s h i p R e q u e s t
id : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
status: ENUM(pending, accepted, declined)
memberld: INT(11) «FK»
U s e r s T o M e m b e r s
userld : INT(11)
m e m b e r l d : INT(11)
w
-K
m e m b e r _ o r g a n i z a t i o n _ r o l e s
_ o r g a n i z a t i o n _ r o l e
f m e m b e r l d : INT(11)
J- organizationRoleld : INT(11)
O r g a n i z a t i o n R o l e
i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
title: VARCHAR(255)
publiclnfo: TINYINT(4)
icon: VARCHAR(255)
M e m b e r
i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
firstname: VARCHAR(255)
lastname: VARCHAR(255)
gender: ENUM(male, female, other)
birthdate: DATE
nickname: VARCHAR(255)
image: VARCHAR(255)
isStudent: TINYINT(4)
school: VARCHAR(255)
schoolClass: VARCHAR(255)
isEmployee: TINYINT(4)
job: VARCHAR(255)
employer: VARCHAR(255)
email: VARCHAR(255)
phone: VARCHAR(255)
address: VARCHAR(255)
otherlnfo: VARCHAR(255)
birchLeaf: INT(11)
motd: T E X T
m e m b e r r o l e s r o l e
. " m e m b e r l d : INT(11)
f roleld : INT(11)
R o l e
i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
title: VARCHAR(255)
color: VARCHAR(255)
rights: TEXT
- K
M e m b e r s T o C e r t i f i c a t e s
i d : INT(11)
validSince: DATE
validUntil: DATE
memberld: INT(11) «FK»
certificateld: INT(11) «FK»
C e r t i f i c a t e
i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
title: TEXT
validity: INT(11)
E v e n t A t t e n d e e
i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
answer: ENUM(yes, no)
memberld: INT(11) «FK»
eventld: INT(11) «FK»
e v e n t l e a d e r s m e m b e r
f eventld : INT(11)
f m e m b e r l d : I N T f M )
3ľ
A r t i c l e
E v e n t
i d : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
from: DATETIME
to: DATETIME
allDay: TINYINT(4)
title: VARCHAR(255)
descriptionBefore: T E X T
descriptionAfter: TEXT
imageBefore: TEXT
linkPhoto: TEXT
linkvideo: TEXT
registrationStart: DATETIME
registrationEnd: DATETIME
maxAttendees: INT(11)
id : INT(11)
created: DATETIME(6)
updated: DATETIME(6)
deleted: DATETIME(6)
visibleFrom: DATETIME
visibleTo: DATETIME
title: VARCHAR(255)
content: LONGTEXT
authorld: INT(11) «FK»
relatedEventld: INT(11) «FK»
¥