Desker
Tables (10)
Channel (channel)
- Channel ID (channel_id) — INT — Primary key — NOT NULL
- Service Name (service_name) — Varchar(50) — Foreign key → Service.Service Name — NOT NULL
- Company name (company_name) — Varchar(50) — Foreign key → Service.Company name — NOT NULL
- Channel Name (channel_name) — Varchar(50)
- API Key (api_key) — Varchar(100)
Knowledgebase (knowledgebase)
- Team name (team_name) — Varchar(50) — Foreign key → Team.Team name — NOT NULL
- Case Name (case_name) — Varchar(50)
- Case Detail (case_detail) — Varchar(500)
Service (service_meta_data)
- Service Name (service_name) — Varchar(50) — Primary key — NOT NULL
- Company name (company_name) — Varchar(50) — Foreign key → Sub Domain.Company name — NOT NULL
- Service Field (service_field) — Varhcar(30)
Sub Domain (sub_domain)
- Company name (company_name) — Varchar(50) — Primary key — NOT NULL
Task (task)
- Task ID (task_id) — INT — Primary key — NOT NULL
- Team name (team_name) — Varchar(50) — Foreign key → Team.Team name — NOT NULL
- Task Detail (task_detail) — Varchar(500)
- Task State (task_state) — Char(10) — enum('start', 'progress', 'stopped', 'done')
Task Assignment (task_assignment)
- UserID (user_id) — Varchar(30) — Foreign key → Team Member.UserID — NOT NULL
- Task ID (task_id) — INT — Foreign key → Task.Task ID — NOT NULL
- Task Member Role (task_member_role) — Varhcar(30)
Team (team)
- Team name (team_name) — Varchar(50) — Primary key — NOT NULL
- Team Role (team_role) — Varhcar(30)
Team Member (team_member)
- Team name (team_name) — Varchar(50) — Foreign key → Team.Team name — NOT NULL
- UserID (user_id) — Varchar(30) — Foreign key → User.UserID — NOT NULL
- Member Name (member_name) — Varchar(50)
Thread (thread)
- Thread ID (thread_id) — INT — Primary key — NOT NULL
- Team name (team_name) — Varchar(50) — Foreign key → Team.Team name — NOT NULL
- Thread Name (thread_name) — Varchar(50)
- Thread Detail (thread_detail) — Varchar(500)
- IsArchaived (is_archaived) — bool
User (user)
- UserID (user_id) — Varchar(30) — Primary key — NOT NULL