졸프
테이블 (6)
Analysis_information (Untitled5)
- id (Key) — 기본 키 — NOT NULL
- analysis_location (Field2)
- analysis_manager (Field3)
- analysis_tool (Field4)
- analysis_list (Field5)
- analysis_process (Field6)
- analysis_result (Field7)
- analysis_file_path (Field8)
- a_hash_validation_status (Field9)
- complete_status (Field)
- evidence_id (Key3) — 외래 키 → Evidence.id — NOT NULL
Case (Untitled2)
- id (Key) — 기본 키 — NOT NULL
- case_number (Field)
- case_type (Field5)
- case_overview (Field10)
- present_stair (Field2)
- doc_file_path (증거파일)
- case_occur_location (Field6)
- case_occur_date (Field7)
- commission_period (Field8)
- commission_date (Field9)
- related_person_info (Field11)
Evidence (Untitled3)
- id (Key) — 기본 키 — NOT NULL
- hash_value (Field)
- evidence_name (Field12)
- responsible_member (Field2)
- type (Field3)
- evidence_user (Field10)
- model_name (Field4)
- collect_location (Field5)
- store_location (Field6)
- unique_number (Field7)
- manufactory_date (Field8)
- collect_date (Field9)
- sign_file_path (Field11)
- case_id (Key2) — 외래 키 → Case.id — NOT NULL
Member (Untitled)
- id (Key) — 기본 키 — NOT NULL
- login_email (Field)
- login_password (Field2)
- member_name (Field4)
- case_number (담당사건번호)
MemberCase (Untitled6)
- id (Key) — 기본 키 — NOT NULL
- member_id (Key2) — 외래 키 → Member.id — NOT NULL
- case_id (Key3) — 외래 키 → Case.id — NOT NULL
- authority (Field)
Transfer_information (Untitled4)
- id (Key) — 기본 키 — NOT NULL
- case_number (Field)
- t_hash_validation_status (Field13)
- departure_location (Field2)
- departure_date (Field9)
- arrival_location (Field3)
- arrival_date (Field8)
- sender (Field4)
- sender_contact (발신자연락처)
- receiver (Field5)
- receiver_contact (Field6)
- transfer_manager (Field7)
- transfer_manager_contact (Field10)
- responsible_member (Field11)
- responsible_member_sign (Field12)
- image_file_path (증거이미지)
- evidence_id (Key2) — 외래 키 → Evidence.id — NOT NULL