audit log
Tables (10)
Citation/reference (Untitled10)
- cid (Key) — num — Primary key — NOT NULL
- citation (Field) — char
Control (Untitled3)
- Controlid (Key) — char — Primary key — NOT NULL
- spid (Key2) — num — Foreign key → Sub-process.spid — NOT NULL
- pid (Key22) — num — Foreign key → Sub-process.pid — NOT NULL
- title (Field) — char
- description (Field2) — char
- hastest (Field4) — boolean
- iskey (Field5) — boolean
- isautomated (Field3) — boolean
- riskid (Key3) — num — Foreign key → Risk.riskid — NOT NULL
- spid (Key23) — num — Foreign key → Risk.spid — NOT NULL
- pid (Key222) — num — Foreign key → Risk.pid — NOT NULL
- sysid (Key4) — num — Foreign key → System.sysid — NOT NULL
- cid (Key5) — num — Foreign key → Citation/reference.cid — NOT NULL
Process (Untitled)
- pid (Key) — num — Primary key — NOT NULL
- title (Field2) — char
Review (Untitled9)
- review id (Key) — num — Primary key — NOT NULL
- reviewer (Field) — char
- reviewdate (Field2) — date
- status (Field3) — char
- level (Field4) — num
- testid (Key2) — Foreign key → Test.testid — NOT NULL
- evid (Key3) — num — Foreign key → Test.evid — NOT NULL
- testid (Key23) — Foreign key → Test.testid — NOT NULL
Risk (Untitled4)
- riskid (Key) — num — Primary key — NOT NULL
- spid (Key2) — num — Foreign key → Sub-process.spid — NOT NULL
- pid (Key22) — num — Foreign key → Sub-process.pid — NOT NULL
- title (Field) — char
Sub-process (Untitled2)
- spid (Key) — num — Primary key — NOT NULL
- pid (Key2) — num — Foreign key → Process.pid — NOT NULL
- title (Field) — char
System (Untitled7)
- sysid (Key) — num — Primary key — NOT NULL
- system (Field) — char
- Controlid (Key2) — char — Foreign key → Control.Controlid — NOT NULL
- spid (Key22) — num — Foreign key → Control.spid — NOT NULL
- pid (Key222) — num — Foreign key → Control.pid — NOT NULL
Test (Untitled5)
- testid (Key) — Primary key — NOT NULL
- evid (Key3) — num — Foreign key → evidence.evid — NOT NULL
- testid (Key23) — Foreign key → evidence.testid — NOT NULL
- procedure (Field) — char
- coverstart (Field6) — date
- coverend (Field7) — date
- teststart (Field4) — date
- testend (Field5) — date
- duedate (Field8) — date
- samplesize (Field9) — num
- tester (Field3) — char
- result (Field2) — char
- Controlid (Key2) — char — Foreign key → Control.Controlid — NOT NULL
- spid (Key22) — num — Foreign key → Control.spid — NOT NULL
- pid (Key222) — num — Foreign key → Control.pid — NOT NULL
Test_attribute (Untitled6)
- taid (Key) — num — Primary key — NOT NULL
- description (Field) — char
- hasexception (Field2) — boolean
- testid (Key2) — Foreign key → Test.testid — NOT NULL
- evid (Key3) — num — Foreign key → Test.evid — NOT NULL
- testid (Key23) — Foreign key → Test.testid — NOT NULL
evidence (Untitled8)
- evid (Key) — num — Primary key — NOT NULL
- testid (Key2) — Foreign key → Test.testid — NOT NULL
- evid (Key3) — num — Foreign key → Test.evid — NOT NULL
- testid (Key23) — Foreign key → Test.testid — NOT NULL
- title (Field) — char
- evidencelink (Field2) — char
- uploadedat (Field3) — datetime
- uploadedby (Field4) — char