ITSM

Tables (10)

Priority (일반/긴급 여부)

  • N (Normal)
  • U (Urgent)

Request_category (서비스 요청 카테고리)

  • CR (Change_request)
  • IH (Incident_handling)
  • AM (Account_managerment)
  • OT (Other_task)
  • SD (Self_development)

Request_processing_status (서비스 요청 처리 상태)

  • SR (Service Request)
  • SRA (Service Request Approve)
  • SRR (Service Request Reject)
  • SRIT (Service Request IT)
  • SRITA (Service Request IT Approve)
  • SRITR (Service Request IT Reject)
  • DEL (Deleted)

SR (결재문서)

  • id — Primary key — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL
  • system_id — Foreign key → System.id — NOT NULL
  • sr_file_id — Foreign key → SR_file.id — NOT NULL
  • approver_id — Foreign key → User.id — NOT NULL
  • developer_id — Foreign key → User.id — NOT NULL
  • request_processing_status
  • request_category
  • priority

SR_History (결재히스토리)

  • id — Primary key — NOT NULL
  • sr_id — Foreign key → SR.id — NOT NULL
  • approver_id
  • developer_id
  • last_request_processing_status

SR_file (결재 첨부파일)

  • id — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

System (시스템)

  • id — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Token (토큰)

  • Key — Primary key — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL

User (사용자)

  • id — Primary key — NOT NULL
  • is_manager — BOOL
  • is_IT — BOOL
  • Field
  • Field2
  • Field3

User_Info (사용자 정보)

  • id — Primary key — NOT NULL
  • user_id — Foreign key → User.id — NOT NULL
  • Field
  • Field2