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