dd

Tables (5)

GEOMETRY (geometry)

  • scene_id — UUID — Foreign key → Untitled.scene_id — NOT NULL
  • scene_geometry_json — JSON
  • scene_simplified_geometry_json — JSON

IMAGE (images)

  • scene_id — UUID — Foreign key → Untitled.scene_id — NOT NULL
  • scene_image_json — JSON
  • scene_resized_image_json — JSON

STORAGE_GEOMETRY (geometries)

  • geometry_id — UUID — Primary key — NOT NULL
  • url — VARCHAR
  • simplified_url — VARCHAR
  • hash — VARCHAR

STORAGE_IMAGE (distinct_images)

  • image_id — UUID — Primary key — NOT NULL
  • url — VARCHAR
  • resized_url — VARCHAR
  • hash — VARCHAR

Untitled

  • scene_id — UUID — Primary key — NOT NULL
  • Field