How to use the wiki: Difference between revisions

From Dane
Jump to navigation Jump to search
Created page with "{| class="wikitable" ! Category (Entity) !! Represents !! Key Properties !! Related Entities |- | Person || A human being || Has email, Has affiliation || Role Assignment, Project Membership, Document, Application |- | Role || Role label || Description || Role Assignment |- | Program || Fellowship / Grant / Series || Program type, Year || Role Assignment, Project, Application, Curriculum Item |- | Role Assignment || Person holding role || Has person, Has role, Start/End..."
 
No edit summary
Line 20: Line 20:
| Curriculum Item || Program session || Session type, Date || Program, Person, Document
| Curriculum Item || Program session || Session type, Date || Program, Person, Document
|}
|}
{| class="wikitable"
! Database Concept !! MediaWiki Equivalent
|-
| Table || Category
|-
| Row || Page
|-
| Column || Semantic Property
|-
| Foreign Key || Page-type Property
|-
| Join Table || Category like Role Assignment
|-
| Query || #ask
|-
| Form || Page Form
|}
<pre>
Person ──< Role Assignment >── Role
  │              │
  │              └── Program
  │
  ├──< Project Membership >── Project
  │                              │
  │                              └── Document
  │
  ├── Application ── Program
  │        │
  │        └── Document
  │
  └── Curriculum Item ── Program
            │
            └── Document
</pre>

Revision as of 23:01, 27 January 2026

Category (Entity) Represents Key Properties Related Entities
Person A human being Has email, Has affiliation Role Assignment, Project Membership, Document, Application
Role Role label Description Role Assignment
Program Fellowship / Grant / Series Program type, Year Role Assignment, Project, Application, Curriculum Item
Role Assignment Person holding role Has person, Has role, Start/End date Person, Role, Program
Project Collaborative work Status, Start/End date Project Membership, Document
Project Membership Person on project Has person, Has project Person, Project
Document File + metadata Has file, Document type Person, Project, Program, Application
Application Submission event Applicant, Status Person, Program, Document
Curriculum Item Program session Session type, Date Program, Person, Document


Database Concept MediaWiki Equivalent
Table Category
Row Page
Column Semantic Property
Foreign Key Page-type Property
Join Table Category like Role Assignment
Query #ask
Form Page Form


Person ──< Role Assignment >── Role
   │              │
   │              └── Program
   │
   ├──< Project Membership >── Project
   │                              │
   │                              └── Document
   │
   ├── Application ── Program
   │        │
   │        └── Document
   │
   └── Curriculum Item ── Program
             │
             └── Document