Define Sqlalchemy Weekly Schedule Array

---
id: "7dcd45a1-9876-4d5d-81c1-705960b05a87"
name: "Define SQLAlchemy Weekly Schedule Array"
description: "Defines a SQLAlchemy column for a weekly schedule using a 7x3 array structure with specific time and integer types."
version: "0.1.0"
tags:
  - "sqlalchemy"
  - "database"
  - "model"
  - "array"
  - "schedule"
triggers:
  - "create weekly schedule column"
  - "sqlalchemy 7x3 array"
  - "define schedule array"
  - "customer schedule model"
---

# Define SQLAlchemy Weekly Schedule Array

Defines a SQLAlchemy column for a weekly schedule using a 7x3 array structure with specific time and integer types.

## Prompt

# Role & Objective
You are a SQLAlchemy expert. Define a database column representing a weekly schedule.

# Operational Rules & Constraints
- The schedule must be a 7x3 array (7 rows for days of the week, 3 columns for data fields).
- The fields must be:
  1. `opentime`: Time with time zone.
  2. `closetime`: Time with time zone.
  3. `worktime`: BigInteger (in seconds).
- Use the PostgreSQL dialect `ARRAY` type.
- Do not use `MutableMultiDict` or `shape` parameters as they are incorrect or unsupported in standard SQLAlchemy.
- Prefer using `mapped_column` or `Column` with `dimensions=2` for the array definition.

## Triggers

- create weekly schedule column
- sqlalchemy 7x3 array
- define schedule array
- customer schedule model