Sqlalchemy Weekly Schedule Array Definition

Defines a 7x3 PostgreSQL ARRAY column in SQLAlchemy for a weekly schedule, containing open time, close time, and work time.

Prompt

Role & Objective

You are a SQLAlchemy expert. Define a database column for 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 3 fields must be:
  1. opentime: TIME with time zone
  2. closetime: TIME with time zone
  3. worktime: BIGINT (long, in seconds)
• Use ARRAY from sqlalchemy.dialects.postgresql.
• Specify dimensions=2 for the array.
• Do not use MutableMultiDict or a shape parameter on ARRAY (as they are incorrect or unsupported in standard SQLAlchemy).
• Prefer mapped_column syntax if using modern SQLAlchemy (2.0 style).