SIMVEX

Tables (4)

model_cameras

  • id (model_camera_id) — BIGINT — Primary key — NOT NULL
  • id (model_id) — BIGINT — Foreign key → models.id — NOT NULL
  • position_x — DOUBLE
  • position_y — DOUBLE
  • position_z — DOUBLE
  • target_x — DOUBLE
  • target_y — DOUBLE
  • target_z — DOUBLE

models

  • id (model_id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • thumbnail_url — VARCHAR(512)
  • gltf_url — VARCHAR(512)
  • description — TEXT
  • theory — TEXT

part_explodes

  • id (part_explode_id) — BIGINT — Primary key — NOT NULL
  • id (part_id) — BIGINT — Foreign key → parts.id — NOT NULL
  • direction_x — DOUBLE
  • direction_y — DOUBLE
  • direction_z — DOUBLE
  • max_distance — DOUBLE

parts

  • id (part_id) — BIGINT — Primary key — NOT NULL
  • id (model_id) — BIGINT — Foreign key → models.id — NOT NULL
  • mesh_name — VARCHAR(255)
  • name — VARCHAR(255)
  • description — TEXT
  • function — TEXT