IT Helpdesk

Tables (5)

Category (categories)

  • ID (id) — bigint — Primary key — NOT NULL
  • Name (name) — varchar

Group (groups)

  • ID (id) — bigint(20) — Primary key — NOT NULL
  • Name (name) — varchar(191)
  • Slug (slug) — varchar(191)

Incident (incidents)

  • ID (id) — bigint — Primary key — NOT NULL
  • UserID (user_id) — bigint(20) — Foreign key → User.ID — NOT NULL
  • GroupID (group_id) — int — Foreign key → Group.ID — NOT NULL
  • ResolvedUserID (resolved_user_id) — bigint(20) — Foreign key → User.ID — NOT NULL
  • Urgency (urgency) — tinyint
  • Phone (phone) — varchar
  • Description (description) — text
  • Status (status) — int
  • Comment (commentt) — text
  • ResolvedAt (resolved_at) — timestamp
  • CreatedAt (created_at) — timestamp

KnowledgeDatabase (kdbs)

  • ID (id) — bigint — Primary key — NOT NULL
  • CategoryID (category_id) — bigint — Foreign key → Category.ID — NOT NULL
  • Number (kb_number) — varchar
  • Problem (problem) — varchar
  • Solution (solution) — text

User (users)

  • ID (id) — bigint(20) — Primary key — NOT NULL
  • GroupID (gorup_id) — bigint(20) — Foreign key → Group.ID — NOT NULL
  • Name (name) — varchar(191) — NOT NULL
  • Email (email) — varchar(191) — NOT NULL
  • First Name (first_name) — datetime — NOT NULL
  • Last Name (last_name) — varchar(191)
  • Password (password) — varchar(191)
  • Gender (gender) — varchar(191)
  • Phone (phone) — varchar(191)
  • Picture (picture) — varchar(191)
  • Role (role) — varchar(191)