0..*
cmr 0..*
0..*
mainChemical 0..1
0..*
safetyIcons 0..*
0..*
safetyStatements 0..*
0..*
chemical 1
0..*
role 1
0..*
chemical 1
0..*
methodOfUse 0..1
0..*
purpose 0..1
0..*
type 0..1
0..*
container 1
0..1
container 0..1
0..*
container 1
0..*
container 1
0..*
cmr 0..*
chemical_chemical
id: integer
name: string
casNumber: string
chemical_formula: string
description: text
adrClasses: string
standardProduct: smallint
physicalState: smallint
isZZS: boolean
dateCreated: datetime
lastUpdate: datetime
ehs_link: text
main_chemical_id: FK
chemical_chemical_mailing_recipient
id: integer
type: string
title: string
description: string
chemical_chemical_role
id: integer
dateCreated: datetime
lastUpdate: datetime
comment: text
status: smallint
inApprovalFlow: smallint
chemical_id: FK
role_id: FK
user_id: FK
chemical_cmr
id: integer
name: string
chemical_container
id: integer
description: text
dateCreated: datetime
lastUpdate: datetime
deletedAt: datetime
dateExpire: datetime
date_opened: datetime
date_arrived: datetime
dateMarkedForRemoval: datetime
sub_location: string
order_number: string
supplier: string
concentration: string
amount: string
amountUnit: string
type_id: FK
methodOfUse_id: FK
purpose_id: FK
user_id: FK
chemical_id: FK
location_id: FK
project_id: FK
chemical_container_changelog
id: integer
dateCreated: datetime
type: integer
message: text
container_id: FK
user_id: FK
chemical_container_external_label
id: integer
qrCodeContent: string
label: string
description: string
orderNumber: string
sequence: string
dateCreated: datetime
lastUpdate: datetime
container_id: FK
chemical_container_method_of_use
id: integer
name: string
description: text
dateCreated: datetime
lastUpdate: datetime
chemical_container_purpose
id: integer
name: string
description: text
dateCreated: datetime
lastUpdate: datetime
chemical_container_scanned
id: integer
dateCreated: datetime
container_id: FK
user_id: FK
chemical_container_type
id: integer
name: string
label_id: FK
chemical_container_user
id: integer
dateCreated: datetime
deletedAt: datetime
comment: text
container_id: FK
user_id: FK
chemical_main_chemical
id: integer
name: string
code: string
dateCreated: datetime
requireMSDS: smallint
lastUpdate: datetime
chemical_role
id: integer
title: string
description: text
sequence: integer
chemical_safety_icon
id: integer
class: string
description: text
mimeType: string
extension: string
fileSize: integer
width: integer
height: integer
dateCreated: datetime
lastUpdate: datetime
image: blob
hash: string
chemical_safety_statement
id: integer
dateCreated: datetime
lastUpdate: datetime
number: string
statement: text