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