Columns
| Name |
Type |
Default |
Nullable |
Children |
Parents |
Comment |
| activityId |
integer |
|
false |
|
public.workflow_review_activity |
Thread this message belongs to; the activity row is its header |
| body |
text |
|
true |
|
|
Only user-editable text in the feed; nulled on delete |
| createdAt |
timestamp(3) with time zone |
CURRENT_TIMESTAMP(3) |
false |
|
|
|
| createdById |
uuid |
|
true |
|
public.user |
|
| deletedAt |
timestamp(3) with time zone |
|
true |
|
|
Set when the comment is deleted |
| history |
json |
|
true |
|
|
Comment revision history. |
| id |
integer |
|
false |
|
|
|
| updatedAt |
timestamp(3) with time zone |
|
true |
|
|
Set when the body is edited |
Constraints
| Name |
Type |
Definition |
| FK_3cd755e8ce44ee49bdf7e9222ec |
FOREIGN KEY |
FOREIGN KEY ("activityId") REFERENCES workflow_review_activity(id) ON DELETE CASCADE |
| FK_9cfac4b106553d0930a1962bea0 |
FOREIGN KEY |
FOREIGN KEY ("createdById") REFERENCES "user"(id) ON DELETE SET NULL |
| PK_5a2a7dea8b7e6afa1001129da27 |
PRIMARY KEY |
PRIMARY KEY (id) |
| workflow_review_activity_comment_activityId_not_null |
n |
NOT NULL "activityId" |
| workflow_review_activity_comment_createdAt_not_null |
n |
NOT NULL "createdAt" |
| workflow_review_activity_comment_id_not_null |
n |
NOT NULL id |
Indexes
| Name |
Definition |
| IDX_workflow_review_activity_comment_activity |
CREATE INDEX "IDX_workflow_review_activity_comment_activity" ON public.workflow_review_activity_comment USING btree ("activityId", id) |
| PK_5a2a7dea8b7e6afa1001129da27 |
CREATE UNIQUE INDEX "PK_5a2a7dea8b7e6afa1001129da27" ON public.workflow_review_activity_comment USING btree (id) |
Relations
erDiagram
"public.workflow_review_activity_comment" }o--|| "public.workflow_review_activity" : "FOREIGN KEY (#quot;activityId#quot;) REFERENCES workflow_review_activity(id) ON DELETE CASCADE"
"public.workflow_review_activity_comment" }o--o| "public.user" : "FOREIGN KEY (#quot;createdById#quot;) REFERENCES #quot;user#quot;(id) ON DELETE SET NULL"
"public.workflow_review_activity_comment" {
integer activityId FK
text body
timestamp_3__with_time_zone createdAt
uuid createdById FK
timestamp_3__with_time_zone deletedAt
json history
integer id
timestamp_3__with_time_zone updatedAt
}
"public.workflow_review_activity" {
timestamp_3__with_time_zone createdAt
uuid createdById FK
json data
integer id
varchar_64_ type
integer typeVersion
varchar_36_ workflowReviewRequestId FK
}
"public.user" {
timestamp_3__with_time_zone createdAt
boolean disabled
varchar_255_ email
varchar_32_ firstName
uuid id
date lastActiveAt
varchar_32_ lastName
boolean mfaEnabled
text mfaRecoveryCodes
text mfaSecret
varchar_255_ password
json personalizationAnswers
varchar_128_ roleSlug FK
json settings
timestamp_3__with_time_zone updatedAt
}
Generated by tbls