public.assignees
Contains details of teams and users who can be assigned to cases or tasks
Stability: The assignees table is to be considered unstable.
Analytical Platform : Yes
Alternative formats : JSON
| Column Name | Column Type | Character Maximum | Is Nullable | Default | Constrained values |
|---|---|---|---|---|---|
| permanent | boolean | YES | false | ||
| roles | json | YES | |||
| suspended | boolean | YES | false | ||
| deleted | timestamp without time zone | YES | |||
| updateddate | timestamp without time zone | YES | NULL::timestamp without time zone | ||
| id | integer | NO | |||
| teamtype | character varying | 255 | YES | NULL::character varying | |
| name | character varying | 255 | NO | ||
| type | character varying | 255 | NO | ||
| character varying | 255 | YES | NULL::character varying | ||
| surname | character varying | 255 | YES | NULL::character varying | |
| phonenumber | character varying | 255 | YES | NULL::character varying |