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)

Untitled4