Godple

Tables (4)

Roles

  • RoleID — Integer — Primary key — NOT NULL — Auto-Increment
  • RoleName — Varchar

Users

  • UserID — Integer — Primary key — NOT NULL — Auto-Increment
  • Username — Varchar
  • Email — Varchar — Unique
  • Password — Varchar
  • RoleID — Integer — Foreign key → Roles.RoleID — NOT NULL — Auto-Increment
  • SuspensionStartDate — DateTime
  • SuspensionEndDate — DateTime

WarningTypes

  • WarningTypeID — Integer — Primary key — NOT NULL — Auto-Increment
  • TypeName — Varchar

Warnings

  • WarningID — Integer — Primary key — NOT NULL — Auto-Increment
  • Description
  • Timestamp — DateTime
  • IssuedByUserID — Integer — Foreign key → Users.UserID — NOT NULL — Auto-Increment
  • IssuedToUserID — Integer — Foreign key → Users.UserID — NOT NULL — Auto-Increment
  • WarningTypeID — Integer — Foreign key → WarningTypes.WarningTypeID — NOT NULL — Auto-Increment