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