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)