Livoa
Discord
Pricing
English
Sign In
Users
Field
Data Type
Constraints
user_id
INT
PK, AUTO_INCREMENT
username
VARCHAR(100)
UNIQUE, NOT NULL
email
VARCHAR(150)
UNIQUE, NOT NULL
password
VARCHAR(255)
NOT NULL
created_at
DATETIME
DEFAULT CURRENT_TIMESTAMP
JournalEntries
Field
Data Type
Constraints
entry_id
INT
PK, AUTO_INCREMENT
user_id
INT
FK → Users.user_id
title
VARCHAR(200)
NOT NULL
content
TEXT
NOT NULL
unlock_date
DATE
NOT NULL
created_at
DATETIME
DEFAULT CURRENT_TIMESTAMP
Media
Field
Data Type
Constraints
media_id
INT
PK, AUTO_INCREMENT
entry_id
INT
FK → JournalEntries.entry_id
file_path
VARCHAR(255)
NOT NULL
file_type
VARCHAR(50)
uploaded_at
DATETIME
DEFAULT CURRENT_TIMESTAMP
LoginSessions
Field
Data Type
Constraints
session_id
INT
PK, AUTO_INCREMENT
user_id
INT
FK → Users.user_id
login_time
DATETIME
logout_time
DATETIME
khushi
by Brutika
Use this design
0
0 uses
