ITSM
Tables (10)
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