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