TASK Log in -page, database

[roosavihlman]

Under this ticket, there is created Session-table to store timestamps when user has logged in and out.

When user logs in, there is created new database row where:

• id (PRIMARY KEY) is ascending number created automatically by the system
• account_id (FOREIGN KEY) references to db table Account's column id and tells, which user has logged in
• log_in timestamp tells the log in time
• log_out is first set as NULL, but when user logs out, this specific db row is updated with the log out timestamp
  • log out functionality is implemented under story APUOPE-RE/Wiki#19

Database table Session:	Column	Type	Key	Nullable
id	INT	PRIMARY KEY	FALSE
account_id	INT	FOREIGN KEY Account(id)	FALSE
log_in	TIMESTAMP	-	FALSE
log_out	TIMESTAMP	-	TRUE

Sub task of ticket APUOPE-RE/wiki#9 Specifications: FR - Log In & Registration

[roosavihlman]

Edit 1.10.2024: Updated specification link.