public.tasks
Tasks assigned to users and teams
Stability: The tasks table is to be considered unstable.
Analytical Platform : Yes
Alternative formats : JSON
| Column Name | Column Type | Character Maximum | Is Nullable | Default | Constrained values |
|---|---|---|---|---|---|
| id | integer | NO | |||
| assignee_id | integer | YES | |||
| createdtime | timestamp without time zone | NO | |||
| caseownertask | boolean | YES | |||
| completedby_id | integer | YES | |||
| ispriority | boolean | NO | false | ||
| systemtype | integer | YES | |||
| duedate | timestamp without time zone | YES | NULL::timestamp without time zone | ||
| activedate | timestamp without time zone | YES | NULL::timestamp without time zone | ||
| completeddate | timestamp without time zone | YES | NULL::timestamp without time zone | ||
| type | character varying | 255 | YES | NULL::character varying | |
| description | text | YES | |||
| status | character varying | 255 | YES | NULL::character varying | |
| name | character varying | 255 | YES | NULL::character varying |