bis

Tables (8)

CalibrationFile (Untitled5)

  • calibration_file_id (PK) — Primary key — NOT NULL
  • dataset_id (FK) — Primary key — NOT NULL
  • type ((DARK/WHITE))
  • file_path
  • created_at
  • dataset_id (pk) — Foreign key → dataset.dataset_id — NOT NULL
  • project_id (fk) — Foreign key → dataset.project_id — NOT NULL

ProcessingJob (Untitled6)

  • job_id (PK) — Primary key — NOT NULL
  • dataset_id (FK) — Primary key — NOT NULL
  • process_type ((RADIENCE/REFLECTANCE/INDEX))
  • status ((REQUESTED/PROCESSING/DONE/FAIL))
  • requested_at
  • completed_at
  • user_id (pk) — Foreign key → user.user_id
  • dataset_id (pk2) — Foreign key → dataset.dataset_id — NOT NULL
  • project_id (fk) — Foreign key → dataset.project_id — NOT NULL

RawFile (Untitled4)

  • raw_file_id (PK) — Primary key — NOT NULL
  • dataset_id (FK) — Primary key — NOT NULL
  • file_type
  • file_path
  • file_size
  • created_at
  • dataset_id (pk) — Foreign key → dataset.dataset_id — NOT NULL
  • project_id (fk) — Foreign key → dataset.project_id — NOT NULL

ResultImage (Untitled7)

  • result_image_id (PK) — Primary key — NOT NULL
  • job_id (FK) — Primary key — NOT NULL
  • image_type ((RGB/BAND/INDEX))
  • wavelength_r
  • wavelength_g
  • wavelength_b
  • file_path
  • created_at
  • Field
  • job_id (PK2) — Foreign key → ProcessingJob.job_id — NOT NULL
  • dataset_id (FK2) — Foreign key → ProcessingJob.dataset_id — NOT NULL

ResultSpectrum (Untitled8)

  • result_spectrum_id (PK) — Primary key — NOT NULL
  • job_id (FK) — Primary key — NOT NULL
  • spectrum_type ((PIXEL/ROI_AVG))
  • x
  • y
  • roi_json
  • file_path
  • created_at
  • job_id (PK2) — Foreign key → ProcessingJob.job_id — NOT NULL
  • dataset_id (FK2) — Foreign key → ProcessingJob.dataset_id — NOT NULL

dataset (Untitled3)

  • dataset_id (pk) — Primary key — NOT NULL
  • project_id (fk) — Primary key — NOT NULL
  • project_id
  • name
  • camera_model
  • wavelength_start
  • wavelength_end
  • created_at
  • project_id (project_id2) — Foreign key → project.project_id

project (Untitled2)

  • project_id — Primary key
  • user_id
  • name
  • description
  • created_at
  • user_id (pk) — Foreign key → user.user_id

user (Untitled)

  • user_id (pk) — Primary key
  • name
  • email
  • created_at