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