Models for Test
Tables (16)
Control (controls)
- id (Key) — Primary key — NOT NULL
- author_id (Key2) — Foreign key → User.id — NOT NULL
- title (Field)
- status (Field2)
- created_time (Field3)
- updated_time (Field4)
Evidence Request (evidence_request)
- id (Key) — Primary key — NOT NULL
File (files)
- id (Key) — Primary key — NOT NULL
- test_id (Key3) — Foreign key → Test.id — NOT NULL
- editor_id (Field)
- title (Field2)
- created_time (Field4)
- updated_time (Field3)
- due_date (Field5)
- url (Field7)
- assigned_time (Field6)
- parent_id (Field8)
- related_count (Field9)
Issue (issue)
- id (Key) — Primary key — NOT NULL
- test_id (Key2) — Foreign key → Test.id — NOT NULL
- issue_id (Field2)
- content (Field)
- created_time (Field3)
- updated_time (Field4)
Issue Comment (issue_comment)
- id (Key) — Primary key — NOT NULL
- issue_id (Key2) — Foreign key → Issue.id — NOT NULL
- content (Field)
- created_time (Field2)
- updated_time (Field3)
Review Request (review_request)
- id (Key) — Primary key — NOT NULL
Sample (samples)
- id (Key) — Primary key — NOT NULL
- test_id (Key2) — Foreign key → Test.id — NOT NULL
- created_time (Field2)
Sample Column (sample_columns)
- id (Key) — Primary key — NOT NULL
- test_id (Key2) — Foreign key → Test.id — NOT NULL
- title (Field)
- order (Field2)
Sample Column Data (sample_column_data)
- id (Key) — Primary key — NOT NULL
- sample_id (Key2) — Foreign key → Sample.id — NOT NULL
- column_id (Key3) — Foreign key → Sample Column.id — NOT NULL
- data (Field)
Test (tests)
- id (Key) — Primary key — NOT NULL
- control_id (Key2) — Foreign key → Control.id — NOT NULL
- test_type_id (Key3) — Foreign key → TestType.id — NOT NULL
- author_id (Key4) — Foreign key → User.id — NOT NULL
- status (Field2)
- created_time (Field3)
- updated_time (Field4)
- due_date (Field6)
Test Attribute (test_attributes)
- id (Key) — Primary key — NOT NULL
- control_id (Key2) — Foreign key → Control.id — NOT NULL
- title (Field)
- created_time (Field2)
Test Information (test_informations)
- test_id (Key2) — Foreign key → Test.id — NOT NULL
- test_procedure (Field)
- observation_of_design (Field11)
- source_of_population (Field2)
- completeness_of_population (Field3)
- number_of_population (Field4)
- sampling_method (Field6)
- number_of_samples (Field5)
- issue_notes (Field7)
- exceptions_noted (Field8)
- conclusion (Field9)
- has_remediation (Field12)
- remediation_due_date (Field13)
- rationale (Field10)
Test Log (test_logs)
- id (Key2) — Primary key — NOT NULL
- test_id (Key) — Foreign key → Test.id — NOT NULL
- assginee_type (Field2)
- date_received (Field3)
- date_completed (Field4)
- status (Field6)
TestAttribute Data (test_attibute_sample)
- id (Key) — Primary key — NOT NULL
- sample_id (Key2) — Foreign key → Sample.id — NOT NULL
- attribute_id (Key3) — Foreign key → Test Attribute.id — NOT NULL
- data (Field)
TestType (test_types)
- id (Key) — Primary key — NOT NULL
- name (Field)
- type (Field2)
- from_date (Field3)
- to_date (Field4)
User (users)
- id (Key) — Primary key — NOT NULL
- username (Key2) — NOT NULL
- password (Field2)
- frist_name (Field)
- last_name (Field3)
- is_admin (Field4)