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)