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