audit log modeling 3차

테이블 (24)

AuditProgram (audit_program)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • due_date (Field2)
  • possible_results (Field5)
  • from_date (Field3)
  • parent_id (Field4)
  • to_date (Field6)

Control (controls)

  • id (Key) — 기본 키 — NOT NULL
  • author_id (Key2) — 외래 키 → User.id — NOT NULL
  • audit_program_id (Key3) — 외래 키 → AuditProgram.id — NOT NULL
  • title (Field)
  • status (Field2)
  • created_time (Field3)
  • updated_time (Field4)

Control Attribute (control_attributes)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • view_group (Field2)
  • attr_group (Field3)

Control Attribute Data (control_attribute_data)

  • id (Key) — 기본 키 — NOT NULL
  • attribute_id (Key2) — 외래 키 → Control Attribute.id — NOT NULL
  • control_id (Key3) — 외래 키 → Control.id — NOT NULL
  • data (Field)

Evidence Request (evidence_request)

  • id (Key) — 기본 키 — NOT NULL

File (files)

  • id (Key) — 기본 키 — NOT NULL
  • author_id (Key2) — 외래 키 → User.id — NOT NULL
  • test_id (Key3) — 외래 키 → 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) — 기본 키 — NOT NULL
  • test_id (Key2) — 외래 키 → Test.id — NOT NULL
  • creator_id (Key3) — 외래 키 → User.id — NOT NULL
  • issue_id (Field2)
  • content (Field)
  • created_time (Field3)
  • updated_time (Field4)

Issue Comment (issue_comment)

  • id (Key) — 기본 키 — NOT NULL
  • issue_id (Key2) — 외래 키 → Issue.id — NOT NULL
  • creator_id (Key3) — 외래 키 → User.id — NOT NULL
  • content (Field)
  • created_time (Field2)
  • updated_time (Field3)

Log (logs)

  • id (Key) — 기본 키 — NOT NULL
  • actor_id (Key2) — 외래 키 → User.id — NOT NULL
  • type (Field)
  • fk (Field2)
  • action (Field3)
  • time (Field4)

Profie (profiles)

  • user_id (Key2) — 외래 키 → User.id — NOT NULL
  • email (Field2) — String
  • team (Field3)

Review Request (review_request)

  • id (Key) — 기본 키 — NOT NULL

Sample (samples)

  • id (Key) — 기본 키 — NOT NULL
  • test_id (Key2) — 외래 키 → Test.id — NOT NULL
  • created_time (Field2)

Sample Column (sample_columns)

  • id (Key) — 기본 키 — NOT NULL
  • test_id (Key2) — 외래 키 → Test.id — NOT NULL
  • title (Field)
  • order (Field2)

Sample Column Data (sample_column_data)

  • id (Key) — 기본 키 — NOT NULL
  • sample_id (Key2) — 외래 키 → Sample.id — NOT NULL
  • column_id (Key3) — 외래 키 → Sample Column.id — NOT NULL
  • data (Field)

StarredFile (starred_file)

  • user_id (Key3) — 외래 키 → User.id — NOT NULL
  • file_id (Key4) — 외래 키 → File.id — NOT NULL
  • created_time (Field)

Statistic (statistics)

  • user_id (Key2) — 외래 키 → User.id — NOT NULL
  • testIncomplete (Field)
  • testReviewComplete (Field2)
  • testComplete (Field3)
  • testOverDue (Field4)
  • controlIncomplete (Field5)
  • controlReject (Field6)
  • controlComplete (Field7)

Test (tests)

  • id (Key) — 기본 키 — NOT NULL
  • control_id (Key2) — 외래 키 → Control.id — NOT NULL
  • test_type_id (Key3) — 외래 키 → TestType.id — NOT NULL
  • author_id (Key4) — 외래 키 → User.id — NOT NULL
  • status (Field2)
  • created_time (Field3)
  • updated_time (Field4)
  • due_date (Field6)

Test Attribute (test_attributes)

  • id (Key) — 기본 키 — NOT NULL
  • control_id (Key2) — 외래 키 → Control.id — NOT NULL
  • title (Field)
  • created_time (Field2)

Test Information (test_informations)

  • test_id (Key2) — 외래 키 → 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) — 기본 키 — NOT NULL
  • test_id (Key) — 외래 키 → Test.id — NOT NULL
  • assigned_id (Key3) — 외래 키 → User.id — NOT NULL
  • assginee_type (Field2)
  • date_received (Field3)
  • date_completed (Field4)
  • status (Field6)

TestAttribute Data (test_attibute_sample)

  • id (Key) — 기본 키 — NOT NULL
  • sample_id (Key2) — 외래 키 → Sample.id — NOT NULL
  • attribute_id (Key3) — 외래 키 → Test Attribute.id — NOT NULL
  • data (Field)

TestType (test_types)

  • id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • type (Field2)
  • from_date (Field3)
  • to_date (Field4)

User (users)

  • id (Key) — 기본 키 — NOT NULL
  • username (Key2) — NOT NULL
  • password (Field2)
  • frist_name (Field)
  • last_name (Field3)
  • is_admin (Field4)

User Control (user_control)

  • control_id (Key3) — 외래 키 → Control.id — NOT NULL
  • user_id (Key4) — 외래 키 → User.id — NOT NULL
  • position (Key2) — NOT NULL
  • assigned_time (Field)