https://dbdiagram.io/d/WWDT-66bcbd008b4bb5230e1da4cb

Users

• user_id: PK, BIN[UUID], AUTO_INCREMENT
• username: VARCHAR(255), UNIQUE
• email: VARCHAR(255), UNIQUE
• password_hash: VARCHAR(255)
• role: ENUM('USER', 'MANAGER', 'ADMIN', 'SYSTEM_ADMIN')
• created_at: TIMESTAMP
• updated_at: TIMESTAMP

Projects

• project_id: PK, INT, AUTO_INCREMENT
• name: VARCHAR(255)
• description: TEXT
• owner_id: FK, BIN[UUID] (references Users.user_id)
• created_at: TIMESTAMP
• updated_at: TIMESTAMP

Silos

• silo_id: PK, INT, AUTO_INCREMENT
• name: VARCHAR(255)