audit log modeling 2차
테이블 (18)
Control (controls)
- id (Key) — 기본 키 — NOT NULL
- author_id (Key2) — 외래 키 → User.id — NOT NULL
- title (Field)
- status (Field2)
- created_time (Field3)
- updated_time (Field4)
File (files)
- id (Key) — 기본 키 — NOT NULL
- author_id (Key2) — 외래 키 → User.id — NOT NULL
- editor_id (Field)
- title (Field2)
- created_time (Field4)
- updated_time (Field3)
- due_date (Field5)
- url (Field7)
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)
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)
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
- 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)
- sub_type (Field)
Test Attribute (test_attributes)
- id (Key) — 기본 키 — NOT NULL
- control_id (Key2) — 외래 키 → Control.id — NOT NULL
- title (Field)
- created_time (Field2)
Test File (test_file)
- file_id (Key3) — 외래 키 → File.id — NOT NULL
- test_id (Key) — 외래 키 → Test.id — NOT NULL
- assigned_time (Field)
Test Information (test_informations)
- test_id (Key2) — 외래 키 → Test.id — NOT NULL
- test_procedure (Field)
- 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)
- rationale (Field10)
- work_through (Field11)
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
- type (Field)
User (users)
- id (Key) — 기본 키 — NOT NULL
- username (Key2) — NOT NULL
- password (Field2)
- frist_name (Field)
- last_name (Field3)
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)