이슈관리
테이블 (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)