## ADDED Requirements

### Requirement: products table
The database SHALL include a `products` table (unique sku, name, item_type, created_at/updated_at).

#### Scenario: Fresh database
- **WHEN** `db/schema.sql` is applied to an empty database
- **THEN** the `products` table exists with its columns

### Requirement: orders table
The database SHALL include an `orders` table (account reference, status with allowed values, timestamps).

#### Scenario: Fresh database
- **WHEN** `db/schema.sql` is applied to an empty database
- **THEN** the `orders` table exists with its columns

### Requirement: tag product/order columns
The `tags` table SHALL gain nullable `product_id` and `order_id` columns referencing `products(id)` and `orders(id)`, added idempotently for existing databases.

#### Scenario: Existing database migration
- **WHEN** `db/schema.sql` is re-applied to a pre-existing database
- **THEN** the two columns exist, nullable, without error
