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)