url

Tables (12)

Analysis_Code (CopyOfUntitled3)

  • Key (analysis_id) — Primary key — NOT NULL
  • Field (name)
  • Field (app_class_1)
  • Field (app_class_2)
  • Field (app_class_3)
  • Key (equip_id) — Foreign key → Equipment_Code.Key — NOT NULL
  • Field (analysis_purpose)

Equipment_Code (Untitled2)

  • Key (equip_id) — Primary key — NOT NULL
  • Field (name) — NOT NULL
  • Field (model_name) — NOT NULL
  • Field (app_class_1)
  • Field (app_class_2)
  • Field (app_class_3)

Insitution (Untitled6)

  • Key (institution_id) — text — Primary key — NOT NULL
  • Field (name) — text — NOT NULL

Material_Alias (MaterialAlias)

  • PK (alias_id) — text — Primary key — NOT NULL
  • PK (mat_id) — text — Foreign key → Material_Code.PK — NOT NULL
  • Field (mat_alias) — text — NOT NULL
  • Field (alias_type) — text — NOT NULL
  • Field (is_default) — boolean — NOT NULL

Material_Code (Material)

  • PK (mat_id) — text — Primary key — NOT NULL
  • Field (mat_name) — text — NOT NULL
  • Field (mat_chemical_formula) — text — NOT NULL
  • PK (mat_group_id) — text — Foreign key → Material_Group.PK — NOT NULL
  • Field (mat_type) — enum — NOT NULL
  • Field (mat_form) — enum — NOT NULL
  • Field (app_class_1) — text
  • Field (app_class_2) — text
  • Field (app_class_3) — text

Material_Group (MaterialGroup)

  • PK (mat_group_id) — text — Primary key — NOT NULL
  • Field (mat_group_name) — text — NOT NULL

Material_Inventory (Untitled4)

  • PK (stock_in_id) — text — Primary key — NOT NULL
  • PK (mat_id) — text — Foreign key → Material_Code.PK — NOT NULL
  • Key (provider_id) — text — Foreign key → Provider_Code.Key — NOT NULL
  • Field (stock_in_data) — text — NOT NULL
  • Field (quantity) — int — NOT NULL

Material_Property (Untitled7)

  • Key (property_id) — Primary key — NOT NULL
  • PK (mat_id) — text — Foreign key → Material_Code.PK — NOT NULL
  • Key (user_id) — Foreign key → User.Key — NOT NULL
  • Field (property_name) — text — NOT NULL
  • Field (property_value) — text — NOT NULL
  • Field (property_unit) — text — NOT NULL
  • Field (data_type) — text — NOT NULL

Process_Code (Untitled3)

  • Key (process_id) — Primary key — NOT NULL
  • Field (name)
  • Field (app_class_1)
  • Field (app_class_2)
  • Field (app_class_3)
  • Key (equip_id) — Foreign key → Equipment_Code.Key — NOT NULL

Provider_Code (Untitled)

  • Key (provider_id) — text — Primary key — NOT NULL
  • Field (name) — text — NOT NULL
  • Field (address) — text — NOT NULL
  • Field (email) — text — NOT NULL
  • Field (phone) — text — NOT NULL

Simulation_Code (CopyOfCopyOfUntitled3)

  • Key (analysis_id) — Primary key — NOT NULL
  • Field (name)
  • Field (app_class_1)
  • Field (app_class_2)
  • Field (app_class_3)
  • Key (equip_id) — Foreign key → Equipment_Code.Key — NOT NULL
  • Field (simulation_purpose)
  • Field (simulation_type) — enum

User (Untitled5)

  • Key (user_id) — Primary key — NOT NULL
  • Key (institution_id) — text — Foreign key → Insitution.Key
  • Field (name) — text — NOT NULL
  • Field (username) — text — NOT NULL
  • Field (password) — text — NOT NULL
  • Field (is_approved) — boolean — NOT NULL
  • Field (email) — text — NOT NULL
  • Field (phone_number) — text — NOT NULL
  • Field (access_level) — enum — NOT NULL
  • Field (role) — enum — NOT NULL