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