This is my ontology:
-
Worker
- Worker id (primary key)
- Last name
-
Award
- Award ID (primary key)
- Award type
- Paragraph 1
- Paragraph 2
- Time award created
-
Award stakeholder
- Award stakeholder id (primary key)
- Award id (foreign key)
- Worker id (foreign key)
- Award stakeholder role: nominee, originator, reviewer, approver
-
Award action history
- Award history id (primary key)
- Action performed by award stakeholder id (foreign key)
- Action performed (denied, forwarded, approved)
- Note associated with action (free text: example: denied - “you forgot to capitalize all of the proper nouns”)
- Timestamp associated with action (timestamp)
I would love to be able to run “tests” to see if my ontology is solid
Examples:
-
Alex nominated Frank for an award id 1
Alex nominated Felix for an award id 2
Alex nominated Frank for an award id 3 -
Bob is a reviewer for award id 1
Bob is a reviewer for award id 2 -
Chad is a reviewer for award id 1
Chad is an approver for award id 2 -
Bob denied award 1 back to Alex
Bob forwarded award 2 to chad
Desired features:
- voice → test → catalogue of past tests
- fails lots of tests → suggested ontology update
thoughts???