servicedesk

Tables (9)

Board (Untitled6)

  • BoardCode (Key) — Primary key — NOT NULL
  • CompanyList (Field)
  • CreateUser (_id)
  • UpdateUser (sabun)
  • Title (user_nm)
  • Contents (higher_nm)
  • AttachFile (higher_cd)
  • ReadingCount (title)
  • PopYN (content)
  • UseYN (company_cd)

Company (Untitled15)

  • CompanyCode (Key) — Primary key — NOT NULL
  • CompanyName (_id)
  • CeoName (group_flag)
  • TelNumber (tel_no)
  • Address (ceo_nm)
  • FaxNumber (use_yn)
  • TelNumber (fax_no)
  • Description (company_nm)
  • TypeCode (bigo)
  • CreatedDate (date_from)
  • UpdatedDate (date_to)
  • UseYN (contract_gubun)

CompanyProcess (Untitled14)

  • CPCode (Key) — Primary key — NOT NULL
  • CompanyCode (Key2) — Foreign key → Company.CompanyCode — NOT NULL
  • HigherCode (Key3) — Foreign key → HigherProcess.HigherCode — NOT NULL

HigherProcess (Untitled13)

  • HigherCode (Key) — Primary key — NOT NULL
  • HigherName (_id)
  • Description (user_flag)
  • CreatedDate (sabun)
  • UpdatedDate (use_yn)
  • UseYN (sort_lvl)

IncidentStatus (Untitled4)

  • StatusCode (status_cd) — Primary key — NOT NULL
  • StatusName (status_nm)

Incient (Untitled10)

  • IncidentCode (Key) — Primary key — NOT NULL
  • StatusCode (status_cd2) — Foreign key → IncidentStatus.StatusCode — NOT NULL
  • RequestUserCode (_id)
  • RequestCompleteDate (request_complete_date)
  • HigherCode (process_cd)
  • LowerCode (sharing_content)
  • StatusCode (reading_cnt)
  • Title (delay_reason)
  • Contents (complete_date)
  • AttachFile (register_sabun)
  • ManagerUserCode (register_num)
  • ManagerComment (status_cd)
  • CompletedComment (valuation)
  • WorkTime (approval_gbn)
  • RequestDate (register_date)
  • CompleteDate (status_nm)
  • CreatedDate (register_mm)
  • UpdatedDate (program_id)
  • DeleteYN (attach_file)

LowerProcess (Untitled9)

  • LowerCode (Key) — Primary key — NOT NULL
  • HigherCode (Key2) — Foreign key → HigherProcess.HigherCode — NOT NULL
  • LowerName (_id)
  • Description (user_flag)
  • CreatedDate (lower_nm)
  • UpdatedDate (register_date)
  • UseYN (company_cd)

MyProcess (Untitled7)

  • MPCode (Key) — Primary key — NOT NULL
  • UserCode (email2) — Foreign key → User.UserCode — NOT NULL
  • HigherCode (Key22) — Foreign key → LowerProcess.HigherCode — NOT NULL
  • LowerCode (Key3) — Foreign key → LowerProcess.LowerCode — NOT NULL

User (users)

  • UserCode (email) — Primary key — NOT NULL
  • CompanyCode (Key) — Foreign key → Company.CompanyCode — NOT NULL
  • UserName (employee_nm)
  • Password (updated_at) — DATE
  • Sabun (Field4)
  • DeptName (Field10) — DATE
  • Title (register_date) — DATE
  • Grade (alarm_minute)
  • MobileTel (dom_addr)
  • Address (dom_post_cd1)
  • CompanyName (userCompany_nm)
  • TeamsYN (teams_yn) — CHAR(1)
  • EmailYN (email_send_yn) — CHAR(1)
  • CreatedDate (password)
  • UpdatedDate (Field)
  • UseStatus (Field2)
  • AccessStatus (Field3)