Users

id_user INT

id_group INT

name VARCHAR(20)

surname VARCHAR(50)

Attachments

id_attachment INT

id_subject INT

name VARCHAR(50)

value VARCHAR(100)

Roles

id_role INT

id_position INT

name VARCHAR(45)

Subjects

id_subject INT

id_lecturer INT

title VARCHAR(100)

duration INT

Position

id_position INT

name VARCHAR(50)

Position_Users

id_position INT

id_user INT

Credits

id_credit INT

id_subject INT

date DATETIME

type VARCHAR(40)

Lectures

id_lecture INT

id_subject INT

type VARCHAR(45)

building VARCHAR(45)

room VARCHAR(45)

date VARCHAR(45)

space_number INT

News

id_news INT

id_user INT

title VARCHAR(45)

body VARCHAR(45)

announcement BOOL

attachment VARCHAR(

200)

Payments

id_payment INT

id_user INT

name VARCHAR(100)

value FLOAT

payment_date DATETI

ME

Documents

id_document INT

id_user INT

title VARCHAR(50)

body VARCHAR(2000)

date DATETIME

Personal_Data

id_user INT

email VARCHAR(45)

tel_number VARCHAR(

45)

city VARCHAR(45)

street VARCHAR(45)

post_number VARCHAR

(45)

Messages

id_message INT

id_user_from INT

id_user_to INT

title VARCHAR(200)

body VARCHAR(4000)

attachment VARCHAR(

200)

Groups

id_group INT

name VARCHAR(20)

Groups_has_Lecture

s

id_group INT

id_lecture INT

id_subject INT

Student_has_Marks

id_mark INT

id_student INT

id_subject INT

id_lecturer INT

value VARCHAR(10)

Access

id_access INT

id_role INT

id_service INT

access_allow INT

assertion VARCHAR(10

0)

Services

id_service INT