ER Diagram

Tables (34)

TC_CODE (코드관리)

  • CODE_VALUE (코드유효값) — VARCHAR(100) — Primary key — NOT NULL
  • CODE_GROUP_ID (코드그룹ID) — VARCHAR(10) — Foreign key → TC_CODE_GROUP.CODE_GROUP_ID — NOT NULL
  • CODE_NAME (코드명) — VARCHAR(50) — NOT NULL
  • CODE_UPPER_VALUE (코드상위유효값) — VARCHAR(100)
  • CODE_VALUE_ORDER (코드유효값순서) — INTEGER
  • DESCRIPTION (코드그룹 설명) — VARCHAR(255)
  • USE_YN (사용여부) — VARCHAR(1) — NOT NULL
  • DELETE_YN (삭제여부) — VARCHAR(1) — NOT NULL
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TC_CODE_GROUP (코드그룹관리)

  • CODE_GROUP_ID (코드그룹ID) — VARCHAR(10) — Primary key — NOT NULL
  • CODE_GROUP_NAME (코드그룹명) — VARCHAR(50) — NOT NULL
  • DESCRIPTION (코드그룹 설명) — VARCHAR(255)
  • USE_YN (사용여부) — VARCHAR(1) — NOT NULL
  • DELETE_YN (삭제여부) — VARCHAR(1) — NOT NULL
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TH_JOB_STATUS_HISTORY (JOB 상태 이력)

  • OCCURRENCE_DT (발생일시) — TimeStamp — Primary key — NOT NULL
  • JOB_ID (작업ID) — VARCHAR(20) — Foreign key → TN_JOB.JOB_ID — NOT NULL
  • JOB_STATE (작업진행상태) — VARCHAR(30) — NOT NULL
  • JOB_STATE_MESSAGE (상태메시지) — VARCHAR(1000)
  • TASK_ORDER (실행 TASK 순번) — INTEGER
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TH_NOTIFICATION_HISTORY (알림 메시지 이력)

  • NOTIFICATION_ID (알림ID) — UUID — Primary key — NOT NULL
  • NOTIFICATION_DT (알림발생일시) — TimeStamp — Primary key — NOT NULL
  • NOTIFICATION_SECTION (알림구분) — VARCHAR(10) — NOT NULL
  • NOTIFICATION_MESSAGE (알림메시지) — VARCHAR(1000) — NOT NULL
  • JOB_ID (작업ID) — VARCHAR(20) — NOT NULL
  • TASK_ID (Task ID) — VARCHAR(30) — NOT NULL
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64)
  • UPDATE_DT (수정일시) — TimeStamp

TH_TASK_STATUS_HISTORY (Task 상태 이력)

  • OCCURRENCE_DT (발생일시) — TimeStamp — Primary key — NOT NULL
  • TASK_ID (TASK ID) — VARCHAR(30) — Foreign key → TN_TASK.TASK_ID — NOT NULL
  • JOB_ID (작업ID) — VARCHAR(20) — Foreign key → TN_TASK.JOB_ID — NOT NULL
  • TASK_STATE (TASK 진행상태) — VARCAHR(30) — NOT NULL
  • TASK_STATUS_MESSAGE (상태메시지) — VARCHAR(1000)
  • TOTAL_SIZE (총 용량(byte)) — INTEGER
  • PROGRESS_SIZE (진행 용량(byte)) — INTEGER
  • PROGRESS_RATE (진행률) — NUMERIC(20,14)
  • ELAPSED_TIME (경과시간) — NUMERIC(20,9)
  • REMAIN_TIME (남은시간) — NUMERIC(20,9)
  • READ_ERROR (Read Error) — INTEGER
  • CACHE_SIZE (encase cache 사이즈) — VARCHAR(100)
  • REMAIN_TASK (encase 남은 작업 수) — NUMERIC
  • VELOCITY (진행속도) — NUMERIC
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ANALYSIS_SW (분석SW설치)

  • ANALYSIS_SW_ID (분석SW ID) — VARCHAR(100) — Primary key — NOT NULL
  • ANALYSIS_SW_TYPE (분석SW유형) — VARCHAR(50) — NOT NULL
  • VENDOR_NAME (제조사) — VARCHAR(100)
  • SERIAL_NUMBER (시리얼번호) — VARCHAR(50)
  • IP (IP(URL)) — VARCHAR(100) — NOT NULL
  • MAC_ADDRESS (MAC 주소) — VARCHAR(20) — NOT NULL
  • VERSION (버전) — VARCHAR(50)
  • DESCRIPTION (설명) — VARCHAR(1000)
  • SAMETIME_EXECUTION_COUNT (동시실행제한수) — INTEGER
  • NOW_EXECUTION_COUNT (현재실행수) — INTEGER
  • PROCESSING_ONE_JOB_ID (프로세싱1작업ID) — VARCAHR(20)
  • PROCESSING_ONE_TASK_STAUTS (프로세싱1Task상태) — VARCHAR(10)
  • PROCESSING_ONE_LICENSE (프로세싱1라이선스key) — VARCHAR(100)
  • ASSIGN_LICENSE (지정라이선스 KEY) — VARCHAR(100)
  • DONGLE_GROUP_ID (Dongle그룹ID) — VARCHAR(100)
  • ENCASE_EXECUTION_PATH (encase 실행 위치) — VARCHAR(100)
  • CASE_STORE_PATH (case 저장 위치) — VARCHAR(100)
  • AUTO_SCRIPT_STORE_PATH (자동 script 저장 위치) — VARCHAR(100)
  • EXPORT_FILE_TYPE_STORE_PATH (export 파일 유형별 저장 위치) — VARCHAR(100)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ANALYSIS_WS_SW (Analysis SW설치)

  • ANAYSIS_WS_ID (Analysis 워크스테이션SW ID) — VARCHAR(100) — Primary key — NOT NULL
  • VENDOR_NAME (제조사) — VARCHAR(100)
  • SERIAL_NUMBER (시리얼번호) — VARCHAR(50)
  • IP (IP(URL)) — VARCHAR(100) — NOT NULL
  • MAC_ADDRESS (MAC 주소) — VARCHAR(20) — NOT NULL
  • DESCRIPTION (설명) — VARCHAR(1000)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_CASE (사건 기본)

  • CASE_ID (사건ID) — VARCHAR(20) — Primary key — NOT NULL
  • CASE_NAME (사건명) — VARCHAR(100) — NOT NULL
  • INVESTIGATOR (수사관) — VARCHAR(50) — NOT NULL
  • CASE_NOTE (사건노트) — VARCHAR(1000)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_DONGLE_LICENSE (Dongle license 관리)

  • DONGLE_GROUP_ID (Dongle그룹ID) — VARCHAR(100) — Primary key — NOT NULL
  • DONGLE_SERVER_ID (Dongle서버 ID) — VARCHAR(100) — Foreign key → TN_DONGLE_SERVER.DONGLE_SERVER_ID — NOT NULL
  • ASSIGN_LICENSES (지정라이선스KEYS) — VARCHAR[]
  • USE_YN (사용여부) — VARCHAR(1) — NOT NULL
  • DESCRIPTION (설명) — VARCHAR(1000)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_DONGLE_SERVER (Dongle Server 설치)

  • DONGLE_SERVER_ID (Dongle서버 ID) — VARCHAR(100) — Primary key — NOT NULL
  • DONGLE_SERVER_TYPE (Dongle서버타입) — VARCHAR(30) — NOT NULL
  • VENDOR_NAME (제조사) — VARCHAR(100)
  • MODEL_NUMBER (모델번호) — VARCHAR(100)
  • SERIAL_NUMBER (시리얼번호) — VARCHAR(50)
  • IP (IP(URL)) — VARCHAR(100) — NOT NULL
  • MAC_ADDRESS (MAC 주소) — VARCHAR(20) — NOT NULL
  • DESCRIPTION (설명) — VARCHAR(1000)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE (encase 설정)

  • TASK_ID (TASK ID) — VARCHAR(30) — Foreign key → TN_TASK.TASK_ID — NOT NULL
  • JOB_ID (작업ID) — VARCHAR(20) — Foreign key → TN_TASK.JOB_ID — NOT NULL
  • ANALYSIS_SW_ID (분석SW ID) — VARCHAR(100)
  • IMAGE_FILE_PATH (이미지파일위치) — VARCHAR(100) — NOT NULL
  • RESULT_SAVE_PATH (결과저장위치) — VARCHAR(100) — NOT NULL
  • CASE_NUMBER (case 번호) — VARCHAR(20) — NOT NULL
  • EXAMINER (분석관) — VARCHAR(50) — NOT NULL
  • DESCRIPTION (case 설명) — VARCHAR(1000)
  • ENPROC_FILE_PATH (EnProc Processing 경로) — VARCHAR(200)
  • PROCESSING_TEMPLATE_ID (Processing 템플릿ID) — VARCHAR(100) — Foreign key → TN_ENCASE_TEMPLATE_PROCESS.TEMPLATE_ID
  • EXPORT_GENERAL_TEMPLATE_ID (Export 일반옵션 템플릿ID) — VARCHAR(100) — Foreign key → TN_ENCASE_TEMPLATE_EXPORT.TEMPLATE_ID
  • EXPORT_ADVANCED_TEMPLATE_ID (Export 고급옵션 템플릿ID) — VARCHAR(100) — Foreign key → TN_ENCASE_TEMPLATE_EXPORT.TEMPLATE_ID
  • WORK_VELOCITY_STANDARD (작업속도기준(MB)) — NUMERIC(10,2)
  • DELAY_POLICY (처리지연정책) — VARCHAR(10)
  • DELAY_RESTART_COUNT (처리지연재실행횟수) — INTEGER
  • ERROR_POLICY (오류정책) — VARCHAR(10)
  • ERROR_RESTART_COUNT (오류재실행횟수) — INTEGER
  • FAIL_POLICY (실패정책) — VARCHAR(10)
  • FAIL_RESTART_COUNT (실패재실행횟수) — INTEGER
  • ISSUE_NOTIFICATION (문제알림여부) — VARCHAR(1)
  • COMPLETION_NOTIFICATION (완료알림) — VARCHAR(1)
  • EXPECTATION_TIME (예상시간(hour)) — NUMETIC(10,3)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE_DEFAULT (encase default 설정)

  • ENCASE_DEFAULT_ID (EnCase UUID) — VARCHAR(64) — Primary key — NOT NULL
  • RESULT_SAVE_PATH (결과저장위치) — VARCHAR(100) — NOT NULL
  • WORK_VELOCITY_STANDARD (속도저하기준(MB)) — NUMERIC(10,2)
  • DELAY_POLICY (처리지연정책) — VARCHAR(10)
  • DELAY_RESTART_COUNT (처리지연재실행횟수) — INTEGER
  • ERROR_POLICY (오류정책) — VARCHAR(10)
  • ERROR_RESTART_COUNT (오류재실행횟수) — INTEGER
  • FAIL_POLICY (실패정책) — VARCHAR(10)
  • FAIL_RESTART_COUNT (실패재실행횟수) — INTEGER
  • ISSUE_NOTIFICATION (문제알림여부) — VARCHAR(1)
  • COMPLETION_NOTIFICATION (완료알림) — VARCHAR(1)
  • ENPROC_FILE_PATH (EnProc Processing 경로) — VARCHAR(200)
  • PROCESSING_TEMPLATE_ID (Processing 템플릿ID) — VARCHAR(100) — Foreign key → TN_ENCASE_TEMPLATE_PROCESS.TEMPLATE_ID
  • EXPORT_GENERAL_TEMPLATE_ID (export 일반 option 템플릿ID) — VARCHAR(100) — Foreign key → TN_ENCASE_TEMPLATE_EXPORT.TEMPLATE_ID
  • EXPORT_ADVANCED_TEMPLATE_ID (export 고급 option 템플릿ID) — VARCHAR(100) — Foreign key → TN_ENCASE_TEMPLATE_EXPORT.TEMPLATE_ID
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE_EXPORT_ADVANCED (encase Export 고급옵션 설정)

  • OPERATION_ORDER (연산 순번) — INTEGER — Primary key — NOT NULL
  • TASK_ID (TASK ID) — VARCHAR(30) — Foreign key → TN_ENCASE.TASK_ID — NOT NULL
  • JOB_ID (작업ID) — VARCHAR(20) — Foreign key → TN_ENCASE.JOB_ID — NOT NULL
  • OPERATION (연산자) — VARCHAR(10) — NOT NULL
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE_EXPORT_ADVANCED_DETAIL (encase Export 고급옵션 세부설정)

  • FILTER_ORDER (필터 순번) — INTEGER — Primary key — NOT NULL
  • OPERATION_ORDER (연산 순번) — INTEGER — Foreign key → TN_ENCASE_EXPORT_ADVANCED.OPERATION_ORDER — NOT NULL
  • TASK_ID (TASK ID) — VARCHAR(30) — Foreign key → TN_ENCASE_EXPORT_ADVANCED.TASK_ID — NOT NULL
  • JOB_ID (작업ID) — VARCHAR(20) — Foreign key → TN_ENCASE_EXPORT_ADVANCED.JOB_ID — NOT NULL
  • FILTER_NOT_YN (NOT 연산 여부) — VARCHAR(1)
  • FILTER_CATEGORY (필터 카테고리) — VARCHAR(30) — NOT NULL
  • CONDITION (조건) — VARCHAR(30) — NOT NULL
  • FILTER_FIELD (필터 항목) — VARCHAR(100)
  • FILTER_VALUE (필터 유효값) — VARCHAR[]
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE_EXPORT_GENERAL (encase Export 일반옵션 설정)

  • FILE_CATEGORY (파일 카테고리) — VARCHAR(30) — Primary key — NOT NULL
  • TASK_ID (TASK ID) — VARCHAR(30) — Foreign key → TN_ENCASE.TASK_ID — NOT NULL
  • JOB_ID (작업ID) — VARCHAR(20) — Foreign key → TN_ENCASE.JOB_ID — NOT NULL
  • FILE_EXTENSION (파일확장자) — VARCHAR[] — NOT NULL
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE_PROCESS (encase Processing 설정)

  • TASK_ID (TASK ID) — VARCHAR(30) — Foreign key → TN_ENCASE.TASK_ID — NOT NULL
  • JOB_ID (작업ID) — VARCHAR(20) — Foreign key → TN_ENCASE.JOB_ID — NOT NULL
  • RECOVER_FOLDERS (Recover Folders) — VARCHAR(1)
  • FILE_SIGNATURE_ANALYSIS (File signature analysis) — VARCHAR(1)
  • PROTECTED_FILE_ANALYSIS (Protected file analysis) — VARCHAR(1)
  • THUMBNAIL_CREATION (Thumbnail creation) — VARCHAR(1)
  • MEDIA_ANALYSIS (Media Analysis) — VARCHAR(1)
  • EXIF_PARSER (Exif parser) — VARCHAR(1)
  • HASH_ANALYSIS (Hash analysis) — VARCHAR(1)
  • EXPAND_COMPOUND_FILES (Expand Compound Files) — VARCHAR(1)
  • FIND_EMAIL (Find email) — VARCHAR(1)
  • FIND_INTERNET_ARTIFACTS (Find Internet artifacts) — VARCHAR(1)
  • SOCIAL_MEDIA_PARSER (Social Media Parser) — VARCHAR(1)
  • SEARCH_FOR_KEYWORDS (Search for keywords) — VARCHAR(1)
  • INDEX_TEXT_AND_METADATA (Index text and metadata) — VARCHAR(1)
  • OCR — VARCHAR(1)
  • SYSTEM_INFO_PARSER (System info parser) — VARCHAR(1)
  • FILE_CARVER (File carver) — VARCHAR(1)
  • WINDOWS_EVENT_LOG_PARSER (Windows event log parser) — VARCHAR(1)
  • WINDOWS_ARTIFACT_PARSER (Windows artifact parser) — VARCHAR(1)
  • UNIX_LOGIN (Unix login) — VARCHAR(1)
  • LINUX_SYSLOG_PARSER (Linux syslog parser) — VARCHAR(1)
  • OS_X_ARTIFACT_PARSER (OS X Artifact parser) — VARCHAR(1)
  • SNAPSHOT (Snapshot) — VARCHAR(1)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE_TEMPLATE_EXPORT (encase 템플릿 Export 설정)

  • TEMPLATE_ID (템플릿ID) — VARCHAR(64) — Primary key — NOT NULL
  • OPTION_TYPE (옵션구분) — VARCHAR(10) — NOT NULL
  • TEMPLATE_NAME (템플릿명) — VARCHAR(100) — NOT NULL
  • DESCRIPTION (설명) — VARCHAR(1000)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE_TEMPLATE_EXPORT (encase 템플릿 Export설정)

  • TEMPLATE_ID (템플릿ID) — UUID — Primary key — NOT NULL

TN_ENCASE_TEMPLATE_EXPORT_ADVANCED (encase 템플릿 Export 고급옵션 설정)

  • OPERATION_ORDER (연산자 순번) — INTEGER — Primary key — NOT NULL
  • TEMPLATE_ID (템플릿ID) — VARCHAR(64) — Foreign key → TN_ENCASE_TEMPLATE_EXPORT.TEMPLATE_ID — NOT NULL
  • OPERATION (연산자) — VARCHAR(10) — NOT NULL
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE_TEMPLATE_EXPORT_ADVANCED_DTL (encase 템플릿 Export 고급옵션 세부설정)

  • FILTER_ORDER (필터 순번) — INTEGER — Primary key — NOT NULL
  • OPERATION_ORDER (연산자 순번) — INTEGER — Foreign key → TN_ENCASE_TEMPLATE_EXPORT_ADVANCED.OPERATION_ORDER — NOT NULL
  • TEMPLATE_ID (템플릿ID) — VARCHAR(64) — Foreign key → TN_ENCASE_TEMPLATE_EXPORT_ADVANCED.TEMPLATE_ID — NOT NULL
  • FILTER_NOT_YN (NOT 연산 여부) — VARCHAR(1)
  • FILTER_CATEGORY (필터 카테고리) — VARCHAR(30) — NOT NULL
  • CONDITION (조건) — VARCHAR(30) — NOT NULL
  • FILTER_FIELD (필터 항목) — VARCHAR(100) — NOT NULL
  • FILTER_VALUE (필터 유효값) — VARCHAR[]
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE_TEMPLATE_EXPORT_GENERAL (encase 템플릿 Export 일반옵션 설정)

  • FILE_CATEGORY (파일카테고리) — VARCHAR(50) — Primary key — NOT NULL
  • TEMPLATE_ID (템플릿ID) — VARCHAR(64) — Foreign key → TN_ENCASE_TEMPLATE_EXPORT.TEMPLATE_ID — NOT NULL
  • FILE_EXTENSION (파일확장자) — VARCHAR[] — NOT NULL
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ENCASE_TEMPLATE_PROCESS (CopyOfencase 템플릿 Export설정)

  • TEMPLATE_ID (템플릿ID) — UUID — Primary key — NOT NULL

TN_ENCASE_TEMPLATE_PROCESS (encase 템플릿 Processing 설정)

  • TEMPLATE_ID (템플릿ID) — VARCHAR(64) — Primary key — NOT NULL
  • TEMPLATE_NAME (템플릿명) — VARCHAR(100) — NOT NULL
  • DESCRIPTION (설명) — VARCHAR(1000)
  • ENPROC_FILE_PATH (EnProc Processing 경로) — VARCHAR(200)
  • RECOVER_FOLDERS (Recover Folders) — VARCHAR(1)
  • FILE_SIGNATURE_ANALYSIS (File signature analysis) — VARCHAR(1)
  • PROTECTED_FILE_ANALYSIS (Protected file analysis) — VARCHAR(1)
  • THUMBNAIL_CREATION (Thumbnail creation) — VARCHAR(1)
  • MEDIA_ANALYSIS (Media Analysis) — VARCHAR(1)
  • EXIF_PARSER (Exif parser) — VARCHAR(1)
  • HASH_ANALYSIS (Hash analysis) — VARCHAR(1)
  • EXPAND_COMPOUND_FILES (Expand Compound Files) — VARCHAR(1)
  • FIND_EMAIL (Find email) — VARCHAR(1)
  • FIND_INTERNET_ARTIFACTS (Find Internet artifacts) — VARCHAR(1)
  • SOCIAL_MEDIA_PARSER (Social Media Parser) — VARCHAR(1)
  • SEARCH_FOR_KEYWORDS (Search for keywords) — VARCHAR(1)
  • INDEX_TEXT_AND_METADATA (Index text and metadata) — VARCHAR(1)
  • OCR — VARCHAR(1)
  • SYSTEM_INFO_PARSER (System info parser) — VARCHAR(1)
  • FILE_CARVER (File carver) — VARCHAR(1)
  • WINDOWS_EVENT_LOG_PARSER (Windows event log parser) — VARCHAR(1)
  • WINDOWS_ARTIFACT_PARSER (Windows artifact parser) — VARCHAR(1)
  • UNIX_LOGIN (Unix login) — VARCHAR(1)
  • LINUX_SYSLOG_PARSER (Linux syslog parser) — VARCHAR(1)
  • OS_X_ARTIFACT_PARSER (OS X Artifact parser) — VARCHAR(1)
  • SNAPSHOT (Snapshot) — VARCHAR(1)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_FALCON (falcon 설정)

  • TASK_ID (TASK ID) — VARCHAR(30) — Foreign key → TN_TASK.TASK_ID — NOT NULL
  • JOB_ID (작업ID) — VARCHAR(20) — Foreign key → TN_TASK.JOB_ID — NOT NULL
  • REPRODUCE_SW_ID (복제SW ID) — VARCHAR(100) — NOT NULL
  • EVIDENCE_NAME (증거파일명) — VARCHAR(100) — NOT NULL
  • EVIDENCE_NUMBER (증거물번호) — VARCHAR(20) — NOT NULL
  • OPERATION_TYPE (작업 종류) — VARCHAR(10) — NOT NULL
  • ORIGINAL_PORT (원본 매체 포트(Bay)) — VARCHAR(50)
  • ORIGINAL_MODEL (원본 매체 모델) — VARCHAR(100)
  • ORIGINAL_SIZE (원본 매체 용량(Size)) — DOUBLE
  • ORIGINAL_SERIAL_NUMBER (원본 매체 시리얼번호) — VARCHAR(50)
  • ORIGINAL_PUSH_PATH (Push 원본 Path) — VARCHAR(100)
  • RESULT_SAVE_PATH (결과저장위치) — VARCHAR(100) — NOT NULL
  • IMAGE_FORMAT (이미지파일포맷) — VARCAHR(30)
  • SEGMENT_SIZE (분할크기) — VARCHAR(30)
  • ORIGINAL_HASH_VERIFICATION (원본해시검증) — VARCHAR(30)
  • MANUSCRIPT_HASH_VERIFICATION (사본해시검증) — VARCHAR(30)
  • SKIP_SECTOR_SIZE (스킵섹터크기) — VARCHAR(30)
  • FILE_VERIFY (PUSH 파일검증) — VARCHAR(30)
  • WORK_VELOCITY_STANDARD (작업속도기준(MB)) — NUMERIC(10,2)
  • DELAY_POLICY (처리지연정책) — VARCHAR(10)
  • DELAY_RESTART_COUNT (처리지연재실행횟수) — INTEGER
  • ERROR_POLICY (오류정책) — VARCHAR(10)
  • ERROR_RESTART_COUNT (오류재실행횟수) — INTEGER
  • FAIL_POLICY (실패정책) — VARCHAR(10)
  • FAIL_RESTART_COUNT (실패재실행횟수) — INTEGER
  • ISSUE_NOTIFICATION (문제알림여부) — VARCHAR(1)
  • COMPLETION_NOTIFICATION (완료알림) — VARCHAR(1)
  • EXPECTATION_TIME (예상시간(hour)) — NUMETIC(10,3)
  • MOUNT_PATH (bay 마운트 경로) — VARCHAR(100)
  • FOLDERS (파티션 폴더 목록) — VARCHAR[]
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_FALCON_DEFAULT (falcon default 설정)

  • FALCON_DEFAULT_ID (Falcon UUID) — VARCHAR(64) — Primary key — NOT NULL
  • OPERATION_TYPE (작업 종류) — VARCHAR(30)
  • RESULT_SAVE_PATH (결과저장위치) — VARCHAR(100) — NOT NULL
  • IMAGE_FORMAT (이미지파일포맷) — VARCHAR(30)
  • SEGMENT_SIZE (분할크기) — VARCHAR(30)
  • ORIGINAL_HASH_VERIFICATION (원본해시검증타입) — VARCHAR(30)
  • MANUSCRIPT_HASH_VERIFICATION (사본해시검증타입) — VARCHAR(30)
  • SKIP_SECTOR (스킵섹터크기) — VARCHAR(30)
  • FILE_VERIFY (PUSH 파일검증) — VARCHAR(30)
  • WORK_VELOCITY_STANDARD (속도저하기준(MB)) — NUMERIC(10,2)
  • DELAY_POLICY (처리지연정책) — VARCHAR(10)
  • DELAY_RESTART_COUNT (처리지연재실행횟수) — INTEGER
  • ERROR_POLICY (오류정책) — VARCHAR(10)
  • ERROR_RESTART_COUNT (오류재실행횟수) — INTEGER
  • FAIL_POLICY (실패정책) — VARCHAR(10)
  • FAIL_RESTART_COUNT (실패재실행횟수) — INTEGER
  • ISSUE_NOTIFICATION (문제알림여부) — VARCHAR(1)
  • COMPLETION_NOTIFICATION (완료알림) — VARCHAR(1)
  • EXPECTATION_TIME (예상시간) — NUMERIC(10,3)
  • MOUNT_PATH (bay 마운트 경로) — VARCHAR(100)
  • FOLDERS (파티션 폴더 목록) — VARCHAR[]
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_JOB (작업기본)

  • JOB_ID (작업ID) — VARCHAR(20) — Primary key — NOT NULL
  • CASE_ID (사건ID) — VARCHAR(20) — Foreign key → TN_CASE.CASE_ID — NOT NULL
  • ROOT_JOB_ID (Field) — VARCHAR(20) — NOT NULL
  • JOB_NAME (작업명) — VARCHAR(100) — NOT NULL
  • JOB_DESCRIPTION (설명) — VARCHAR(1000)
  • EXAMINER (분석관) — VARCHAR(50) — NOT NULL
  • INVESTIGATOR (수사관) — VARCHAR(50)
  • EXPECTATION_TIME (예상시간(hour)) — NUMERIC(10,3)
  • COMPLETION_NOTIFICATION (완료알림) — VARCHAR(1)
  • EMAIL_NOTIFICATION (이메일알림) — VARCHAR(1)
  • OS_NOTIFICATION (OS알림) — VARCHAR(1)
  • TASK_COUNT (TASK 건수) — INTEGER
  • JOB_STATUS (작업상태) — VARCHAR(30) — NOT NULL
  • JOB_START_DT (작업시작일시) — TimeStamp
  • JOB_STOP_DT (작업중단일시) — TimeStamp
  • JOB_ERROR_DT (작업오류일시) — TimeStamp
  • JOB_COMPLETION_DT (작업완료일시) — TimeStamp
  • CASE_TYPE (사건유형) — VARCHAR[]
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_LICENSE (license 관리)

  • LICENSE (라이선스 KEY) — VARCHAR(100) — Primary key — NOT NULL
  • LICENSE_NAME (라이선스명) — VARCHAR(300) — NOT NULL
  • ASSIGN_ANALYSIS_SW_ID (지정분석SW ID) — VARCHAR(100)
  • ASSIGN_DONGLE_GROUP_ID (지정Dongle그룹ID) — VARCAHR(100)
  • DESCRIPTION (설명) — VARCHAR(1000)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_MEMBER (사용자관리)

  • MEMBER_ID (사용자ID) — VARCHAR(50) — Primary key — NOT NULL
  • PASSWORD (비밀번호) — VARCHAR(255) — NOT NULL
  • MEMBER_NAME (사용자명) — VARCHAR(50) — NOT NULL
  • EMAIL (이메일) — VARCHAR(50) — NOT NULL
  • MOBILE_TELEPHONE_NUMBER (휴대전화번호) — VARCHAR(15)
  • ROLE (권한) — VARCHAR(30) — Foreign key → TN_ROLE.ROLE — NOT NULL
  • DELETE_YN (삭제여부) — VARCAHR(1) — NOT NULL
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_MENU (메뉴관리)

  • MENU_ID (메뉴ID) — VARCHAR(10) — Primary key — NOT NULL
  • MENU_NAME (메뉴명) — VARCHAR(100) — NOT NULL
  • UPPER_MENU_ID (메뉴상위ID) — VARCHAR(10) — Foreign key → TN_MENU.MENU_ID — NOT NULL
  • MENU_ORDER (메뉴순서) — INTEGER — NOT NULL
  • URL — VARCHAR(255)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_REPRODUCE_SW (복제SW설치)

  • REPRODUCE_SW_ID (복제SW ID) — VARCHAR(100) — Primary key — NOT NULL
  • REPRODUCE_SW_TYPE (복제SW유형) — VARCHAR(50) — NOT NULL
  • VENDOR_NAME (제조사) — VARCHAR(100)
  • SERIAL_NUMBER (시리얼번호) — VARCHAR(50)
  • IP (IP(URL)) — VARCHAR(100) — NOT NULL
  • MAC_ADDRESS (MAC 주소) — VARCHAR(20) — NOT NULL
  • VERSION (버전) — VARCHAR(50)
  • DESCRIPTION (설명) — VARCHAR(1000)
  • SAMETIME_EXECUTION_COUNT (동시실행제한수) — INTEGER
  • NOW_EXECUTION_COUNT (현재실행수) — INTEGER
  • PORT_ONE_JOB_ID (포트1작업ID) — VARCHAR(20)
  • PORT_TWO_JOB_ID (포트2작업ID) — VARCHAR(20)
  • PORT_THREE_JOB_ID (포트3작업ID) — VARCHAR(20)
  • PORT_FOUR_JOB_ID (포트4작업ID) — VARCHAR(20)
  • PORT_FIVE_JOB_ID (포트5작업ID) — VARCHAR(20)
  • PORT_SIX_JOB_ID (포트6작업ID) — VARCHAR(20)
  • PORT_SEVEN_JOB_ID (포트7작업ID) — VARCHAR(20)
  • PORT_EIGHT_JOB_ID (포트8작업ID) — VARCHAR(20)
  • PORT_ONE_TASK_STAUTS (포트1Task상태) — VARCHAR(10)
  • PORT_TWO_TASK_STAUTS (포트2Task상태) — VARCHAR(10)
  • PORT_THREE_TASK_STAUTS (포트3Task상태) — VARCHAR(10)
  • PORT_FOUR_TASK_STAUTS (포트4Task상태) — VARCHAR(10)
  • PORT_FIVE_TASK_STAUTS (포트5Task상태) — VARCHAR(10)
  • PORT_SIX_TASK_STAUTS (포트6Task상태) — VARCHAR(10)
  • PORT_SEVEN_TASK_STAUTS (포트7Task상태) — VARCHAR(10)
  • PORT_EIGHT_TASK_STAUTS (포트8Task상태) — VARCHAR(10)
  • PORT_ONE_EXECUTION_BAY (포트1실행Bay) — VARCHAR(30)
  • PORT_TWO_EXECUTION_BAY (포트2실행Bay) — VARCHAR(30)
  • PORT_THREE_EXECUTION_BAY (포트3실행Bay) — VARCHAR(30)
  • PORT_FOUR_EXECUTION_BAY (포트4실행Bay) — VARCHAR(30)
  • PORT_FIVE_EXECUTION_BAY (포트5실행Bay) — VARCHAR(30)
  • PORT_SIX_EXECUTION_BAY (포트6실행Bay) — VARCHAR(30)
  • PORT_SEVEN_EXECUTION_BAY (포트7실행Bay) — VARCHAR(30)
  • PORT_EIGHT_EXECUTION_BAY (포트8실행Bay) — VARCHAR(30)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_ROLE (권한관리)

  • ROLE (권한) — VARCHAR(30) — Primary key — NOT NULL
  • ROLE_NAME (권한명) — VARCHAR(100) — NOT NULL
  • DESCRIPTION (설명) — VARCHAR(1000)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_STORAGE (Storage설치)

  • STORAGE_ID (스토리지ID) — VARCHAR(100) — Primary key — NOT NULL
  • STORAGE_PURPOSE (스토리지용도) — VARCHAR(30)
  • VENDOR_NAME (제조사) — VARCHAR(100)
  • MODEL_NUMBER (모델 번호) — VARCHAR(100)
  • SERIAL_NUMBER (시리얼번호) — VARCHAR(50)
  • IP (IP(URL)) — VARCHAR(100) — NOT NULL
  • MAC_ADDRESS (MAC 주소) — VARCHAR(20) — NOT NULL
  • CAPACITY (용량(GB)) — NUMERIC(10,2)
  • STORAGE_PATH (스토리지접근경로) — VARCHAR(255)
  • MEMBER_ID (사용자ID) — VARCHAR(50)
  • PASSWORD (비밀번호) — VARCHAR(255)
  • DESCRIPTION (설명) — VARCHAR(1000)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_SYSTEM (시스템관리)

  • SYSTEM_ID (시스템ID) — VARCHAR(32) — Primary key — NOT NULL
  • SOLUTION_TYPE (솔루션유형) — VARCHAR(30) — NOT NULL
  • SERIAL_NUMBER (시리얼번호) — VARCHAR(50) — NOT NULL
  • MAC_ADDRESS (MAC 주소) — VARCHAR(20) — NOT NULL
  • IP (IP(URL)) — VARCAHR(100) — NOT NULL
  • SYSTEM_SECRET (시스템ID 비밀번호) — VARCHAR(255) — NOT NULL
  • ROLE (권한) — VARCHAR(30) — Foreign key → TN_ROLE.ROLE — NOT NULL
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL

TN_TASK (Task 기본)

  • TASK_ID (TASK ID) — VARCHAR(30) — Primary key — NOT NULL
  • JOB_ID (작업ID) — VARCHAR(20) — Foreign key → TN_JOB.JOB_ID — NOT NULL
  • TASK_TYPE (TASK유형) — VARCHAR(30) — NOT NULL
  • TASK_ORDER (TASK 작업순서) — INTEGER — NOT NULL
  • TASK_DETAIL_INFO (TASK 상세정보) — JSON
  • TASK_STATUS (Task상태) — VARCHAR(30)
  • REPRODC_TASK_DTL_STATUS (복제Task상세상태) — VARCHAR(50)
  • ANALS_TASK_DTL_STATUS (분석Task상세상태) — VARCHAR(50)
  • CMPRS_TASK_DTL_STATUS (압축Task상세상태) — VARCHAR(50)
  • TASK_START_DT (Task시작일시) — TimeStamp
  • TASK_STOP_DT (Task중단일시) — TimeStamp
  • TASK_ERROR_DT (Task오류일시) — TimeStamp
  • TASK_COMPLETION_DT (Task완료일시) — TimeStamp
  • PROGRESS_RATE (진행률) — NUMERIC(20,14)
  • CREATOR (생성자) — VARCHAR(64) — NOT NULL
  • CREATION_DT (생성일시) — TimeStamp — NOT NULL
  • UPDATE_USER (수정자) — VARCHAR(64) — NOT NULL
  • UPDATE_DT (수정일시) — TimeStamp — NOT NULL