# Define SQLAlchemy Weekly Schedule Array

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

- Skill: `ecnu-icalk/define-sqlalchemy-weekly-schedule-array` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/define-sqlalchemy-weekly-schedule-array`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/define-sqlalchemy-weekly-schedule-array/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/define-sqlalchemy-weekly-schedule-array

---


# 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