Database Schema Definition

[davideme]

Overview

Define and document the database schemas for both SQL (MySQL/PostgreSQL) and MongoDB implementations.

Tasks

• Create SQL schema definitions for the Lamp entity
• Create MongoDB schema/document structure for the Lamp entity
• Document migration approaches for each language implementation
• Ensure schema supports the minimal properties (id, status)
• Add database setup instructions for local development

Acceptance Criteria

• SQL schema files (DDL) for both MySQL and PostgreSQL
• MongoDB schema documentation
• README with setup instructions
• Documentation of any differences between implementations

Notes

• Keep schema simple with minimal properties for v1
• Ensure consistent approach across all language implementations