ㅅㄷㄴㅅ
Tables (6)
client
- client_id — int — Primary key — NOT NULL
- client_name — varchar(100)
- system_name — varchar(50)
- target_env — varchar(10)
- target_component — varchar(50)
- cloud_type — varchar(50)
error_report
- report_id — int — Foreign key → report.report_id — NOT NULL
- error_start_date — datetime
- client_name — varchar(50)
- system_name — varchar(50)
- target_env — varchar(10)
- target_component — varchar(50)
- customer_impact — text
- error_info — text
- error_reason — text
- action_taken — text
- manager — varchar(10)
- status — varchar(10)
- error_end_date — datetime
- etc — text
- cloud_type — varchar(50)
log_report
- report_id — int — Foreign key → report.report_id — NOT NULL
- log_date — datetime
- client_name — varchar(50)
- system_name — varchar(50)
- target_env — varchar(10)
- log_type — varchar(20)
- content — text
- action — text
- manager — varchar(10)
- status — varchar(10)
- completed_date — datetime
- summary — text
- etc — text
- cloud_type — varchar(50)
msp_report
- report_id — int — Foreign key → report.report_id — NOT NULL
- request_date — datetime
- client_name — varchar(50)
- system_name — varchar(50)
- target_env — varchar(10)
- requester — varchar(10)
- request_type — varchar(20)
- request_content — text
- purpose — text
- manager — varchar(10)
- status — varchar(10)
- completed_date — datetime
- response — text
- etc — text
- cloud_type — varchar(50)
report
- report_id — int — Primary key — NOT NULL
- create_by — int — Foreign key → user.user_id
- report_type — varchar(10)
- created_at — datetime
user
- user_id — int — Primary key — NOT NULL
- username — varchar(50) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(50) — NOT NULL
- email — varchar(100)
- created_at — datetime