졸프

테이블 (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