wifi
테이블 (5)
usb 읽기 (tb_usb_read_approval)
- pk (ura_seq) — bigint — 기본 키 — NOT NULL
- Field (ura_type) — nvarchar
- Field (ura_reason) — nvarchar(2000)
- Field (ura_start_date) — datetime
- Field (ura_end_date) — datetime
- Field (ura_manager_memo) — nvarchar(500)
- Field (ura_reg_id) — nvarchar(50)
- Field (ura_regdate) — datetime
- Field (return_api_comment) — nvarchar(200)
- Field (ura_check) — nvarchar(50)
- Key (user_id) — 외래 키 → 로그인유저.Key — NOT NULL
- Key (emp_no) — 외래 키 → 로그인유저.Key — NOT NULL
결재 승인자 정보 (tb_approval_chief_info)
- Key (aci_seq) — bigint — 기본 키 — NOT NULL
- Field (aci_user_id) — varchar(20)
- Field2 (aci_user_nm) — varchar(20)
- Field3 (aci_user_org_cd) — varchar(20)
- Field4 (aci_user_position_nm) — varchar(20)
- Field5 (aci_approval_order) — varchar(20)
- Field6 (aci_approval_type) — varchar(1)
- Field7 (aci_approval_scope) — varchar(1)
- Field8 (aci_approval_status) — varchar(20)
- Field9 (aci_approval_date) — datetime
- Field10 (aci_approval_reason) — nvarchar(4000)
- Field11 (aci_approval_complete) — varchar(1)
- Field12 (aci_approval_complete_date) — datetime
- Field13 (aci_approval_reject_reason) — varchar(50)
- Field14 (aci_mail_yn) — varchar(1)
- Field15 (agi_seq) — varchar(20)
- Field16 (aci_approval_change_target) — varchar(20)
- Key (agi_seq2) — bigint — 외래 키 → 결재선 상태 정보.Key — NOT NULL
결재선 상태 정보 (tb_approval_group_info)
- Key (agi_seq) — bigint — 기본 키 — NOT NULL
- Field (agi_type) — nvarchar
- Field2 (agi_approval_key) — nvarchar
- Field3 (agi_approval_status) — nvarchar
- Field4 (agi_approval_date) — datetime
- Field5 (agi_regdate) — datetime
- Field6 (agi_req_user_id) — nvarchar
- Field7 (agi_req_user_org_nm) — nvarchar
- Field8 (agi_doc_num) — nvarchar
- Field9 (agi_subject) — nvarchar
- pk (ura_seq) — bigint — 외래 키 → usb 읽기.pk — NOT NULL
결재자 정보 (tb_approval_applicant_info)
- Key (aai_seq) — bigint — 기본 키 — NOT NULL
- Field (aai_user_id) — varchar(20)
- Field (aai_user_nm) — varchar(20)
- Field2 (aai_user_org_cd) — varchar(20)
- Field3 (aai_user_position_nm) — varchar(20)
- Field4 (aai_user_order) — varchar(20)
- Field5 (agi_type) — varchar(20)
- Field6 (agi_seq) — varchar(20)
- Field7 (aai_start_date) — datetime
- Field8 (aai_end_date) — datetime
- Field9 (aai_policy_yn) — nvarchar(50)
- Field10 (aai_alarm_send_yn) — char(1)
- Field11 (aai_user_ip) — nvarchar(50)
- Field12 (aai_before_seal) — nvarchar(200)
- Field13 (aai_new_seal) — nvarchar(200)
- Field14 (aai_control_number) — nvarchar(200)
- Field15 (aai_remark) — nvarchar(400)
- Field16 (aai_access_account) — nvarchar(50)
- Field17 (aai_worker_no) — nvarchar(100)
- Field18 (aai_file_nm) — nvarchar(500)
- Field19 (aai_use_type) — nvarchar(50)
- Key (agi_seq2) — bigint — 외래 키 → 결재선 상태 정보.Key — NOT NULL
- Key (user_id2) — 외래 키 → 로그인유저.Key — NOT NULL
- Key (emp_no) — 외래 키 → 로그인유저.Key — NOT NULL
로그인유저 (tb_user_info)
- Key (user_id) — 기본 키 — NOT NULL
- Key (emp_no) — 기본 키 — NOT NULL
- Field (password)
- Field2 (com_cd)
- Field3 (com_nm)
- Field4 (org_cd)
- Field5 (org_nm)
- Field6 (emp_nm)
- Field7 (emp_position_cd)
- Field8 (emp_position_nm)
- Field9 (emp_job_nm)
- Field10 (emp_status_nm)
- Field11 (emp_status_cd)
- Field12 (emp_level)
- Field13 (emp_level_nm)
- Field14 (email)
- Field15 (mobile_no)
- Field16 (tel_no)
- Field17 (job_cd)
- Field18 (job_nm)
- Field19 (ip)
- Field20 (gender)
- Field21 (pwd_error_count)
- Field22 (usage_startdate)
- Field23 (usage_enddate)
- Field24 (exception_yn)
- Field25 (mail_yn)
- Field26 (approval_change_target)
- Field27 (approval_change_yn)
- Field28 (is_updated)
- Field29 (regdate)
- Field30 (sign_path)
- Field31 (user_gb)