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