3582408100

_J action

id INT(ll)

O module VARCHAR(128)

O eon troll er VARCHAR(128) O action VAROHAR(128) is_secure TINY INT

_J action_has_user ▼

action Jd INT(ll) userjd IMT(ll)

PRIMARY

fk_action

fk_user

Indexes

PRIMARY

_.

_| author

id INT(ll)

O name VARCHAR(128)

O surname VARCHAR(128) O university VARCHAR(128) Ofeculty VAROHAR(45)

O degree VARCHAR(45)

O publication_count INT

O

-O

3) user

idlNT(ll)

username VARCHAR(128) > password VARCHAR(128) 0 email VARCHAR(128) user_tipe INT(ll)

O salt VARCHAR(45)

O authorjd INT(ll)

□ log

id INT(ll)

O log_date DATĘ Ohour TIME

—

T

r

I

—K

> userjd INT (11)

44

J

Indexes

PRIMARY

username_UNIQUE

PRIMARY

fk user author

^ publication

31 publicatjon_has_author t

publicationjd INT(ll) authorjd INT(ll)

Indexes

fk_publication

fk_author

PRIMARY

id INT(ll)

O titie VARCHAR(128)

O year YEAR 0 author VARCHAR(128)

.✓ journal VARCHAR(128) Oissn INT(11)

Opoints INT(11)

> bibtex_key VAROHAR(128) Ovdume INT(ll)

Onumber INT(ll)

O pages INT(ll)

O month INT(ll)

O notę TEXT Okey VARCHAR(128)

PRIMARY

fk_publ ication _copern icus

^ copernicus

idlNT(ll)

O titie VARCHAR(128) > issn INT(ll)

0 points INT(ll)

Indexes

>o-

PRIMARY

issn_UNIQUE