app.report_schedules
TableRow level security on
Scheduled delivery of a report as PDF, CSV or .xlsx (Section 4.6.4), to org members only.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.report_definitions on insert; never accepted from the caller and never changed.References app.organizations.id |
| report_definition_id | uuid | No | Report delivered.References app.report_definitions.id |
| cadence | app.schedule_cadence | No | Daily, Weekly or Monthly. |
| local_hour | smallint | No | Local hour of delivery in time_zone. |
| weekday | smallint | Yes | ISO weekday (1 Monday) for weekly delivery. |
| month_day | smallint | Yes | Day of the month (1 to 28) for monthly delivery. |
| time_zone | text | No | IANA time zone the schedule is read in. |
| export_format | app.export_format | No | Attached file format. |
| next_run_at | timestamp with time zone | No | Next delivery time, kept by the database. |
| paused_at | timestamp with time zone | Yes | When the schedule was paused. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |