task_assignments
From Dontopedia, the open, paraconsistent wiki. (Last updated 2026-06-07.)
task_assignments has 58 facts recorded in Dontopedia across 2 references, with 10 live disagreements.
Mostly:has column(13), has foreign key(6), rdf:type(4)
Maturity scale
raw canonical shape-checked rule-derived certifiedHas Columnin disputehasColumn
- Start Date Ta[1]sourceall time · A887db6d 930d 4434 Bd71 E09c9979ef5e
- End Date Ta[1]sourceall time · A887db6d 930d 4434 Bd71 E09c9979ef5e
- Status Ta[1]sourceall time · A887db6d 930d 4434 Bd71 E09c9979ef5e
- Assignment Id Column[2]all time · C2258b4a 77f6 41b7 994b 16233d9c8dd8
- Task Id Column[2]all time · C2258b4a 77f6 41b7 994b 16233d9c8dd8
- User Id Column[2]all time · C2258b4a 77f6 41b7 994b 16233d9c8dd8
- Role Id Column[2]all time · C2258b4a 77f6 41b7 994b 16233d9c8dd8
- Assignment Start Date Column[2]all time · C2258b4a 77f6 41b7 994b 16233d9c8dd8
- Assignment End Date Column[2]all time · C2258b4a 77f6 41b7 994b 16233d9c8dd8
- Assignment Status Column[2]all time · C2258b4a 77f6 41b7 994b 16233d9c8dd8
Inbound mentions (17)
Other subjects in dontopedia point AT this entity as a value. These are inverse relationships — e.g. "X motherOf this subject" — and answer questions the forward facts can't. Grouped by predicate.
isPartOfIs Part of(9)
- Assignment Created at Column
ex:assignment-created-at-column - Assignment End Date Column
ex:assignment-end-date-column - Assignment Id Column
ex:assignment-id-column - Assignment Start Date Column
ex:assignment-start-date-column - Assignment Status Column
ex:assignment-status-column - Assignment Updated at Column
ex:assignment-updated-at-column - Role Id Column
ex:role-id-column - Task Id Column
ex:task-id-column - User Id Column
ex:user-id-column
isReferencedByIs Referenced by(3)
- Roles Table
ex:roles-table - Tasks Table
ex:tasks-table - Users Table
ex:users-table
relatedToRelated to(3)
- Roles Table
ex:roles-table - Tasks Table
ex:tasks-table - Users Table
ex:users-table
containsDDLContains Ddl(1)
- Source Document
ex:source-document
uniquelyIdentifiesUniquely Identifies(1)
- Assignment Id
ex:assignment-id
Other facts (43)
The long tail: predicates that appear too rarely to warrant their own section. Filter or scroll to find a specific one. Each row links to its source.
| Predicate | Value | Ref |
|---|---|---|
| Has Foreign Key | Fk Ta Tasks | [1] |
| Has Foreign Key | Fk Ta Users | [1] |
| Has Foreign Key | Fk Ta Roles | [1] |
| Has Foreign Key | Fk Task Assignments Task | [2] |
| Has Foreign Key | Fk Task Assignments User | [2] |
| Has Foreign Key | Fk Task Assignments Role | [2] |
| Rdf:type | Database Table | [1] |
| Rdf:type | Database Table | [2] |
| Rdf:type | Junction Table | [2] |
| Rdf:type | Junction Table | [1] |
| Links Tables | Tasks Table | [1] |
| Links Tables | Users Table | [1] |
| Links Tables | Roles Table | [1] |
| Associates Entity | Tasks Table | [2] |
| Associates Entity | Users Table | [2] |
| Associates Entity | Roles Table | [2] |
| Nary Relationship Participants | Tasks Table | [1] |
| Nary Relationship Participants | Users Table | [1] |
| Nary Relationship Participants | Roles Table | [1] |
| Resolution Table for | Tasks Table | [1] |
| Resolution Table for | Users Table | [1] |
| Resolution Table for | Roles Table | [1] |
| Enables Many to Many | Tasks Table | [1] |
| Enables Many to Many | Users Table | [1] |
| Enables Many to Many | Roles Table | [1] |
| Uses Sql Syntax | AUTO_INCREMENT | [2] |
| Uses Sql Syntax | PRIMARY KEY | [2] |
| Has Assignment Period | Assignment Start Date Column | [2] |
| Has Assignment Period | Assignment End Date Column | [2] |
| Part of | Database Schema | [1] |
| Models Relationship | Task User Role Assignment | [1] |
| Is Junction Table | true | [1] |
| Column Order | 4 | [1] |
| Has Primary Key | Assignment Id | [1] |
| Is Many to Many Junction | true | [1] |
| Models Nary Relationship | true | [1] |
| Supports Temporal Tracking | true | [2] |
| Enables History Tracking | true | [2] |
| Allows Multiple Assignments Per Task | true | [2] |
| Allows Task Reassignment | true | [2] |
| Has Status Column | Assignment Status Column | [2] |
| Is Part of | Database Schema | [2] |
| Has Assignment Identifier | Assignment Id Column | [2] |
Timeline
Timeline axis is valid_time — when each source says the fact was true in the world, not when Dontopedia learned about it. Retracted rows are kept for provenance; coloured stripes indicate the context kind.
References (2)
ctx:claims/beam/a887db6d-930d-4434-bd71-e09c9979ef5e- full textbeam-chunktext/plain1 KB
doc:beam/a887db6d-930d-4434-bd71-e09c9979ef5eShow excerpt
FOREIGN KEY (assigned_role) REFERENCES roles(role_id) ); CREATE TABLE task_assignments ( assignment_id INT AUTO_INCREMENT PRIMARY KEY, task_id INT, user_id INT, role_id INT, start_date DATE, end_date DATE, status VARCHAR(25…
ctx:claims/beam/c2258b4a-77f6-41b7-994b-16233d9c8dd8
See also
- Database Table
- Start Date Ta
- End Date Ta
- Status Ta
- Fk Ta Tasks
- Fk Ta Users
- Fk Ta Roles
- Assignment Id Column
- Task Id Column
- User Id Column
- Role Id Column
- Assignment Start Date Column
- Assignment End Date Column
- Assignment Status Column
- Assignment Created at Column
- Assignment Updated at Column
- Database Schema
- Task User Role Assignment
- Tasks Table
- Users Table
- Roles Table
- Fk Task Assignments Task
- Fk Task Assignments User
- Fk Task Assignments Role
- Assignment Id
- Junction Table
- Task Id Ta
Keep researching
Missing something or suspicious of what's here? Kick off a research session — a Claude agent will investigate, cite its sources, and file new facts into a dedicated context you can review before accepting into the shared view.