JTIP

Tables (5)

analysis_results (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • project_data_id (Key2) — INT — Foreign key → project_data.id — NOT NULL
  • analyzer_id (Key3) — INT — Foreign key → users.id — NOT NULL
  • frame_no (Field) — INT
  • base_no (Field2) — INT
  • result (Field3) — JSON — NOT NULL
  • created_at (Field4) — TIMESTAMP

audit_logs (Untitled5)

  • id (Key) — INT — Primary key — NOT NULL
  • user (Field6) — INT
  • action (Field) — VARCHAR(50) — NOT NULL — CREATE / UPDATE / DELETE 등
  • target_table (Field2) — VARCHAR(50)
  • target_id (Field3) — INT
  • detail (Field4) — JSON
  • created_at (Field5) — TIMESTAMP — NOT NULL

project_data (Untitled3)

  • id (Key) — INT — Primary key — NOT NULL
  • project_id (Key2) — INT — Foreign key → projects.id — NOT NULL
  • file_path (Field) — TEXT
  • file_name (Field2) — VARCHAR(255)
  • view_type (Field3) — VARCHAR(10)
  • created_at (Field4) — TIMESTAMP
  • config (Field5) — JSON

projects (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • owner_id (Key2) — INT — Foreign key → users.id — NOT NULL
  • name (Field) — VARCHAR(255) — NOT NULL
  • device_type (Field2) — VARCHAR(100) — NOT NULL
  • description (Field3) — TEXT
  • created_at (Field4) — TIMESTAMP — NOT NULL

users (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • login_id (Field2) — VARCHAR(100) — NOT NULL
  • password_hash (Field) — VARCHAR(255) — NOT NULL
  • name (Field6) — VARCHAR(100)
  • department (Field3) — VARCHAR(255) — NOT NULL
  • is_admin (Field4) — boolean — NOT NULL
  • created_at (Field5) — TIMESTAMP — NOT NULL
  • state (Field7) — VARCHAR(100)