login
Tables (4)
Authentication Information (Untitled2)
- AutoID (auto_id) — INT(11) — Primary key — NOT NULL
- PasswordHash (password_hash) — CHAR(11)
- PasswordSalt (password_salt) — CHAR(11)
- IsActive (isactive)
- UserID (user_id) — INT(11) — Foreign key → USER.UserID — NOT NULL
Session (Untitled3)
- SessionID (session_id) — INT(11) — Primary key — NOT NULL
- Field2
- SessionToken (sessiontoken) — INT(20)
- ExpiresAt (expereat) — CHAR(12)
- CreatedAt (createdat) — CHAR(12)
- UserID (user_id) — INT(11) — Foreign key → USER.UserID — NOT NULL
USER (Untitled)
- UserID (user_id) — INT(11) — Primary key — NOT NULL
- Username (user_name) — VARCHAR(255)
- Email (email) — VARCHAR(255)
- PasswordHash (password_hash) — CHAR(11)
- CreatedAt (created_at) — CHAR(8)
- LastLogin (last_login) — CHAR(12)