The interesting (and undiscovered) part of the design is this:
Before I go too far down the wrong path, can someone tell me if my approach to modeling a single database table is correct (in this case a table of defect types)?
I chose to do a function from an "id" (say the primary key of a SQL table) to a "data" (the rest of the columns of a SQL table) or a constant indicating no row was found.
Hope you all had a great holidays. :)
Attachment:
DefectType.tla
Description: Binary data