draft.yaml

models:
  Sample:
    device_id: id foreign nullable
    company_id: id foreign nullable
    reference: string nullable
    solvent_id: id foreign nullable
    molecule_id: id foreign nullable
    spectrum_type: string nullable
    instructions: text nullable
    additional_infofile_id: string nullable
    priority: enum:high,medium,low
    operator_id: id foreign nullable
    relationships:
      belongsToMany: SpectrumType
      belongsTo: Device,Solvent

  Device:
    name: string
    manufacturer: string
    model_no: string
    spectrum_types: string
    relationships:
      belongsToMany: SpectrumType
      HasMany: Sample

  SpectrumType:
    neuclei: string
    dimentionality: enum:1D,2D
    name: string
    relationships:
      belongsToMany: Sample,Device

  Solvent:
    name: string
    description: text nullable
    molecular_formula: string
    molecular_weight: decimal:8,2
    meta_data: jsonb
    relationships:
      HasMany: Sample,Structure