6737634554

3) u sers

3) groupmembers

login VAROHAR(45) groupID INT

login VAROHAR(45)

>    password VARCHAR(45) 0 name VARCHAR(45)

>    surname VARCHAR(45) 0 email VARCHAR(45)

>    birlhdate DATĘ

>    logdate DATĘ O regdate DATĘ

-44-

Ki—-

44- —

Ki—-H--

—K

----44-

3) groups

groupID INT

groupname VAROHAR(45) v*groupowner VAROH#l(45) autooptymalization BOCL

commitments

'm

41--

—K

■f

I

I

I

i

sessions

sessionID BIGINT > login VARCHAR(45) v userIP VARCHAR(20) / rememberme BOCL

—K

—K

commitmentlD INT

>    comm itmentname VARCHAR( 100) >obligor VAROHAR(45) >obligeeVARCHAR(45)

>    groupID INT

>    comm itmentowner VARCHAR(45) >sum FLOAT

Ocomment VAROHAR(200)

O comm itmentdate DATĘ

>    status INT

>1----

Indexes

A

—K

—1 - -_J groupjom	T
groupjoinID INT
-^groupjoinowner VARCHAR(45)
<► groupID INT
O login VAROHAR(45)
Oinvitation BOOL