이슈관리

테이블 (5)

ex_issue_master (이슈_옵션)

  • issue_no — varchar(20) — 기본 키 — NOT NULL
  • customer_company_id — varchar(5) — 외래 키 → sys_user.user_id — NOT NULL
  • rq_no — varchar(20)
  • issue_type_cd — varchar(20)
  • issue_status_cd — varchar(20) — NOT NULL
  • issue_rq_type_cd — varchar(20)
  • issue_rq_path_cd — varchar(20)
  • registrant_id — varchar(20)
  • registrant_company_id — varchar(5)
  • registrant_department_id — varchar(20)
  • registrant_email_address — varchar(80)
  • registrant_company_phone_no — varchar(14)
  • registrant_mobile_phone_no — varchar(14)
  • requestor_company_id — varchar(5)
  • requestor_department_id — varchar(20)
  • requestor_email_address — varchar(80)
  • requestor_company_phone_no — varchar(14)
  • requestor_mobile_phone_no — varchar(14)
  • rq_title_name — varchar
  • rq_contents — text
  • rq_datetime — date
  • attach_file_id — varchar(500)
  • registrant_datetime — date
  • requestor_finish_desired_date — date
  • issue_priority_cd — varchar(20)
  • reception_contents — text
  • finish_estimate_date — date
  • issue_solve_method_contents — text
  • requirement_agree_details — text
  • plan_start_date — date
  • plan_end_date — date
  • hist_reviewer_id — varchar(80)
  • hist_checker_id — varchar(80)
  • supplier_reviewer_id — varchar(80)
  • customer_issue_checker_id — varchar(80)
  • result_customer_issue_chkr_id — varchar(80)
  • transact_start_date — date
  • transact_end_date — date
  • result_details — text
  • result_checks_opinion_contents — text
  • finish_datetime — date
  • update_date — date
  • related_people_id — character
  • issue_contact_id — varchar(20)
  • requestor_id — varchar(20)
  • group_id — varchar

ex_issue_subtask (이슈_서브태스크)

  • sub_issue_no — varchar(20) — 기본 키 — NOT NULL
  • issue_no (issue_no2) — varchar(20) — 외래 키 → ex_issue_master.issue_no — NOT NULL
  • user_id — varchar(80) — 외래 키 → ex_issue_master.customer_company_id — NOT NULL
  • sub_detail — text
  • registrant_id — varchar(80)
  • registrant_datetime — timestamp
  • transact_start_date — date
  • transact_end_date — date

ex_sys_email_trns_log (메일발송 로그)

  • seq_no — numeric(10) — 기본 키 — NOT NULL
  • registrant_id — varchar(80) — 외래 키 → sys_user.user_id — NOT NULL
  • email_title_name — varchar(200)
  • email_contents — text
  • note_contents — text
  • email_transmit_yn_cd — varchar(20)
  • receiver_email_group_name — varchar(2000)
  • transmitter_email_group_name — varchar(2000)
  • register_datetime — timestamp
  • changer_id — varchar(80)
  • change_datetime — timestamp

sys_code (공통코드)

  • common_system_id — varchar(20) — 기본 키 — NOT NULL
  • common_cd_id — varchar(20) — 외래 키 → ex_issue_master.issue_no — NOT NULL
  • user_id — varchar(80) — 외래 키 → ex_issue_master.customer_company_id — NOT NULL
  • common_cd_name — varchar(80)
  • high_common_system_id — varchar(20)
  • use_start_date — date
  • use_end_date — date
  • note_contents — text
  • registrant_id — varchar(80)
  • register_datetime — timestamp
  • changer_id — varchar(80)
  • change_datetime — timestamp
  • sort_seq — numeric(10)
  • jira_cd — varchar(500)
  • issue_type_cd — varchar(20)
  • column_nm — varchar(100)
  • etc1 — varchar(100)
  • etc2 — varchar(100)
  • etc3 — varchar(100)
  • common_cd_name_tmp — varchar(80)

sys_user (그룹사 유저)

  • user_id — varchar(80) — 기본 키 — NOT NULL
  • company_id — varchar(5)
  • user_name — varchar(40)
  • password_contents — text
  • phone_no — varchar(14)
  • mobile_phone_no — varchar(14)
  • email_address — varchar(80)
  • use_yn_cd — varchar(20)
  • approve_yn_cd — varchar(20)
  • approver_id — varchar(80)
  • approve_datetime — timestamp
  • password_missing_yn_cd — varchar(20)
  • registrant_id — varchar(80)
  • register_datetime — timestamp
  • changer_id — varchar(80)
  • change_datetime — timestamp
  • department_id — varchar(20)
  • approach_authority_id — varchar(20)
  • jira_use_yn_cd — varchar(20)
  • bitbucket_use_yn_cd — varchar(20)
  • grp_yn_cd — varchar(20)
  • if_yn_cd — varchar(1)