search

design-hub-arc / software-db

A database management website for tracking software licenses
1 stars 0 forks source link

rework data model a bit #12

Open Matt-Crow opened 2 years ago

Matt-Crow commented 2 years ago

WHO, WHAT, WHEN, WHERE, and WHY should be top level subjects. Maybe require that all other subjects descend from them, then each subject has at least one parent

Matt-Crow commented 2 years ago

Required: vendor, license number (PK!), license type, "faculty champion" (manages the license). Allow "UNKNOWN" value for some fields