111
테이블 (14)
check_lists
- check_list_index — BIGSERIAL
- check_list_code — VARCHAR(30) — NOT NULL
- payload_code — VARCHAR(30) — NOT NULL
- check_list_description — VARCHAR(255) — NOT NULL
- check_list_registered_time — TIMESTAMP(0) — NOT NULL
- check_list_last_update_time — TIMESTAMP(0) — NOT NULL
- check_list_delete_flag — BOOLEAN — NOT NULL
- check_list_large_categories — VARCHAR(255) — NOT NULL
- check_list_medium_categories — VARCHAR(255) — NOT NULL
diagnostic_tool_results_management
- check_list_result_index — BIGSERIAL
- project_code — VARCHAR(30) — NOT NULL
- checklist_code — VARCHAR(30) — NOT NULL
- payload_code — VARCHAR(30) — NOT NULL
- check_list_result_status — VARCHAR(30) — NOT NULL
- check_list_result_score — BIGINT
- check_list_result_evaluators_comment — VARCHAR(500) — ARCHAR(500
- check_list_result_management_comment — VARCHAR(500) — ARCHAR(500
evaluators_management
- eva_index — BIGSERIAL
- project_code — VARCHAR(30) — NOT NULL
- eva_assigned — VARCHAR(50) — NOT NULL
- eva_affiliation — VARCHAR(50) — NOT NULL
- eva_name — VARCHAR(50) — NOT NULL
- eva_number — VARCHAR(50) — NOT NULL
- eva_etc — VARCHAR(255)
event_notifications_management
- noti_index — BIGSERIAL
- noti_body — VARCHAR(500) — NOT NULL
- noti_created — TIMESTAMP — NOT NULL
- noti_read — BOOLEAN — NOT NULL
- user_id — VARCHAR(30) — NOT NULL
faq_management
- faq_id — BIGSERIAL
- user_id — VARCHAR(50) — NOT NULL
- faq_title — VARCHAR(255) — NOT NULL
- faq_content — TEXT — NOT NULL
- faq_registered_time — TIMESTAMP — NOT NULL
- faq_file — VARCHAR(255)
- faq_last_modified_at — TIMESTAMP — NOT NULL
issue_comment
- comment_index — BIGSERIAL
- issue_code — VARCHAR(30) — NOT NULL
- issue_comment_body — TEXT — NOT NULL
- issue_comment_created — TIMESTAMP — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
issue_management
- issue_index — BIGSERIAL
- issue_code — VARCHAR(30) — NOT NULL
- project_code — VARCHAR(30) — NOT NULL
- issue_title — VARCHAR(255) — NOT NULL
- issue_body — TEXT — NOT NULL
- issue_created — TIMESTAMP — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
payloads
- payload_index — BIGSERIAL
- payload_code — VARCHAR(30) — NOT NULL
- payload_name — VARCHAR(50) — NOT NULL
- payload_description — VARCHAR(255) — NOT NULL
- payload_registered_time — TIMESTAMP(0) — NOT NULL
- payload_last_modified_time — TIMESTAMP(0) — NOT NULL
- payload_delete_flag — BOOLEAN — NOT NULL
qna_management
- qna_id — BIGSERIAL
- qna_code — VARCHAR(30) — NOT NULL
- qna_title — VARCHAR(255) — NOT NULL
- qna_content — TEXT — NOT NULL
- qna_answer — TEXT
- qna_registered_time — TIMESTAMP — NOT NULL
- qna_file — VARCHAR(255)
- qna_answer_registered_time — TIMESTAMP — NOT NULL
reference_room
- room_id — BIGSERIAL
- writer_id — VARCHAR(50) — NOT NULL
- room_title — VARCHAR(255) — NOT NULL
- room_content — TEXT — NOT NULL
- room_registered_time — TIMESTAMP — NOT NULL
- room_last_modified_at — TIMESTAMP — NOT NULL
- room_file — VARCHAR(255)
security_conformance_verification_application_management
- scvam_index — BIGSERIAL
- applicant_code — VARCHAR(50) — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- applicant_unit_name — VARCHAR(100) — NOT NULL
- applicant_department_name — VARCHAR(100) — NOT NULL
- applicant_manager_name — VARCHAR(50) — NOT NULL
- applicant_phone_number — VARCHAR(20) — NOT NULL
- applicant_project_name — VARCHAR(100) — NOT NULL
- applicant_email — VARCHAR(100) — NOT NULL
- applicant_purpose_of_introduction — VARCHAR(500) — NOT NULL
- applicant_is_security_result_applied — BOOLEAN — NOT NULL
- applicant_contract_date — DATE — NOT NULL
- applicant_introduction_date — DATE — NOT NULL
- product_name — VARCHAR(100) — NOT NULL
- product_type — VARCHAR(100) — NOT NULL
- product_firmware_version — VARCHAR(50) — NOT NULL
- product_hash_value — VARCHAR(255)
- product_quantity — INTEGER — NOT NULL
- product_has_verified_crypto_module — BOOLEAN — NOT NULL
- product_crypto_module_name — VARCHAR(100)
- product_crypto_verification_number — VARCHAR(50)
- manufacturer_company_name — VARCHAR(100) — NOT NULL
- manufacturer_ceo_name — VARCHAR(50) — NOT NULL
- manufacturer_address — VARCHAR(200) — NOT NULL
- manufacturer_manager_name — VARCHAR(50) — NOT NULL
- manufacturer_phone_number — VARCHAR(20) — NOT NULL
- manufacturer_contact_phone_number — VARCHAR(20) — NOT NULL
- manufacturer_contact_mobile_number — VARCHAR(20) — NOT NULL
- manufacturer_email — VARCHAR(100) — NOT NULL
- supplementation_reason — VARCHAR(500)
- application_status — VARCHAR(10) — NOT NULL
security_conformity_validation_management
- project_index — BIGSERIAL
- project_code — VARCHAR(30) — NOT NULL
- project_name — VARCHAR(30) — NOT NULL
- application_code — VARCHAR(30) — NOT NULL
- project_start_date — TIMESTAMP — NOT NULL
- project_finish_date — TIMESTAMP
- project_status — VARCHAR(20) — NOT NULL
- project_request — BOOLEAN — NOT NULL
- project_evaluators — BOOLEAN — NOT NULL
- project_description — VARCHAR(500)
- project_retention_reason — VARCHAR(500)
- tool_result_opinion — TEXT
- tool_finish — BOOLEAN — NOT NULL
- project_result_description — TEXT
- project_result — BOOLEAN
system_event_logs
- event_index — BIGSERIAL
- event_occurrence_time — TIMESTAMP(0) — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- event_name — VARCHAR(100) — NOT NULL
- event_details — VARCHAR(1000) — NOT NULL
- event_status — VARCHAR(20) — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- ip_address — VARCHAR(50)
- FAILURE — 'LOCKED'))
사용자 (users)
- user_index — BIGSERIAL — 기본 키
- user_id — VARCHAR(50) — NOT NULL
- user_password — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- user_email — VARCHAR(100) — NOT NULL
- user_phone_number — VARCHAR(50) — NOT NULL
- user_privilege — VARCHAR(20) — NOT NULL
- user_military_rank — VARCHAR(50) — NOT NULL
- user_applicant_unit_name — VARCHAR(50) — NOT NULL
- user_applicant_department_name — VARCHAR(50) — NOT NULL
- user_account_created_at — TIMESTAMP(0) — NOT NULL
- user_last_login_at — TIMESTAMP(0)
- user_last_modified_at — TIMESTAMP(0)
- user_is_account_locked — BOOLEAN — NOT NULL
- user_login_attempt_count — INT — NOT NULL
- user_is_temporary_password — BOOLEAN — NOT NULL
- user_password_expiration_date — TIMESTAMP(0) — NOT NULL