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