IDMS
Tables (12)
ACCESS_LOGS (접근 기록)
- log_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL — AUTO_INCREMENT
- unit_id (Key22) — BIGINT — Foreign key → User.unit_id — NOT NULL — AUTO_INCREMENT
- company_id (Key3) — BIGINT — Foreign key → User.company_id — NOT NULL — AUTO_INCREMENT
- user_id (Field) — BIGINT
- ip_address (Field2) — VARCHAR
- user_agent (Field3) — VARCHAR
- login_at (Field4) — DATETIME — NOT NULL
ASSET (방산 자산)
- asset_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- asset_name (Field) — VARCHAR — NOT NULL
- serial_no (Field2) — VARCHAR — NOT NULL
- asset_type (Field3) — VARCHAR — NOT NULL
- unit_id (Field4) — BIGINT — NOT NULL
- status (Field5) — ENUM — NOT NULL
- description (Field6) — TEXT
- created_at (Field7) — DATETIME — NOT NULL
- updated_at (Field8) — DATETIME
DEFENSE_COMPANY (방산회사)
- company_id (Key) — Primary key — NOT NULL — AUTO_INCREMENT
- company_name (Field) — NOT NULL
- business_no (Field2)
- contact_email (Field3)
- created_at (Field4) — NOT NULL
FAULT_ATTACHMENT (고장 신고 첨부파일)
- attachment_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- fault_id (Key2) — BIGINT — Foreign key → FAULT_REPORT.fault_id — NOT NULL — AUTO_INCREMENT
- file_name (Field2) — VARCHAR — NOT NULL
- file_path (Field3) — VARCHAR — NOT NULL
- file_type (Field4) — VARCHAR
- file_size (Field5) — BIGINT
- uploaded_at (Field6) — DATETIME — NOT NULL
FAULT_REPORT (오류 보고)
- fault_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- asset_id (Field) — BIGINT — NOT NULL
- reporter_id (Field2) — BIGINT — NOT NULL
- fault_occurred_at (Field3) — DATETIME — NOT NULL
- symptom_detail (Field4) — TEXT — NOT NULL
- urgency (Field5) — ENUM — NOT NULL
- status (Field6) — ENUM — NOT NULL
- created_at (Field7) — DATETIME — NOT NULL
MAINTENANCE_HISTORY (정비 이력)
- history_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- asset_id (Key2) — BIGINT — Foreign key → ASSET.asset_id — NOT NULL — AUTO_INCREMENT
- request_id (Field2) — BIGINT — NOT NULL
- fault_summary (Field3) — TEXT — NOT NULL
- action_summary (Field4) — TEXT — NOT NULL
- completed_at (Field5) — DATETIME — NOT NULL
MAINTENENACE_ACTIONS (정비)
- action_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- request_id (Field) — BIGINT — NOT NULL
- worker_id (Field2) — BIGINT — NOT NULL
- action_detail (Field3) — TEXT — NOT NULL
- replacec_parts (Field4) — TEXT
- note (Field5) — TEXT
- is_completed (Field6) — BOOLEAN — NOT NULL
- action_at (Field7) — DATETIME — NOT NULL
MAINTENENCE_REQUEST (정비 요청)
- request_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- fault_id (Key2) — BIGINT — Foreign key → FAULT_REPORT.fault_id — NOT NULL — AUTO_INCREMENT
- action_id (Key3) — BIGINT — Foreign key → MAINTENENACE_ACTIONS.action_id — NOT NULL — AUTO_INCREMENT
- company_id (Field2) — BIGINT
- request_status (Field3) — ENUM — NOT NULL
- scheduled_date (Field4) — DATE
- created_at (Field5) — DATETIME — NOT NULL
- completed_at (Field6) — DATETIME
MILITARY_UNIT (부대명)
- unit_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- unit_name (Field) — VARCHAR — NOT NULL
- location (Field2) — VARCHAR
- created_at (Field3) — DATETIME — NOT NULL
Notification (알림)
- notification_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL — AUTO_INCREMENT
- unit_id (Key22) — BIGINT — Foreign key → User.unit_id — NOT NULL — AUTO_INCREMENT
- company_id (Key3) — BIGINT — Foreign key → User.company_id — NOT NULL — AUTO_INCREMENT
- title (Field2) — VARCHAR
- message (Field3) — TEXT
- is_read (Field4) — BOOLEAN
- created_at (Field5) — DATETIME
SYSTEM_LOG (시스템 로그)
- system_log_id (Key) — BIGIINT — Primary key — NOT NULL — AUTO_INCREMENT
- user_id (Key2) — BIGINT — Foreign key → User.user_id — NOT NULL — AUTO_INCREMENT
- unit_id (Key22) — BIGINT — Foreign key → User.unit_id — NOT NULL — AUTO_INCREMENT
- company_id (Key3) — BIGINT — Foreign key → User.company_id — NOT NULL — AUTO_INCREMENT
- user_id (Field) — BIGINT
- action_type (Field2) — VARCHAR — NOT NULL
- action_detail (Field3) — TEXT
- created_at (Field4) — DATETIME — NOT NULL
User (사용자)
- user_id (Key) — BIGINT — Primary key — NOT NULL — AUTO_INCREMENT
- unit_id (Key2) — BIGINT — Foreign key → MILITARY_UNIT.unit_id — NOT NULL — AUTO_INCREMENT
- company_id (Key3) — BIGINT — Foreign key → DEFENSE_COMPANY.company_id — NOT NULL — AUTO_INCREMENT
- login_id (Field) — VARCHAR — NOT NULL
- password_hash (Field2) — VARCHAR — NOT NULL
- name (Field3) — VARCHAR — NOT NULL
- email (Field4) — VARCHAR — NOT NULL
- phone (Field5) — VARCHAR — NOT NULL
- role (Field6) — ENUM — NOT NULL
- is_active (Field9) — BOOLEAN — NOT NULL
- created_at (Field10) — DATETIME — NOT NULL
- updated_at (Field11) — DATETIME — NOT NULL