# 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.

- Skill: `ecnu-icalk/sqlalchemy-weekly-schedule-array-definition` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/sqlalchemy-weekly-schedule-array-definition`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/sqlalchemy-weekly-schedule-array-definition/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/sqlalchemy-weekly-schedule-array-definition

---


# 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).

# Anti-Patterns
- Do not invent parameters like `shape` for the `ARRAY` type.
- Do not use `MutableMultiDict` for array storage.

## Triggers

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