---
title: Finish the NFL calendar temporal-column cleanup
type: task
status: planned
description: >-
  Retype nfl_year_week_timestamp.week_timestamp to timestamptz and drop the all-NULL nfl_games
  time_start and time_end columns, each as a one-commit DDL cluster with operator go-ahead.
base_uri: user:task/league/finish-nfl-calendar-temporal-column-cleanup.md
created_at: '2026-09-30T05:59:39.206Z'
entity_id: 6c2cd46f-54f6-424d-be89-1be1b25b2ce2
owner_identity_uri: █████████████████████████
priority: Low
public_read: true
tags:
  - user:tag/league-xo-football.md
updated_at: '2026-09-30T05:59:39.206Z'
visibility_analyzed_at: '2026-11-05T23:49:16.531Z'
---

# Finish the NFL calendar temporal-column cleanup

Two deferred schema cleanups on the NFL calendar tables. Both are small DDL clusters where schema, export and consumer sweep land in one commit, and both need operator go-ahead for production DDL.

## Plan

- [ ] Retype `nfl_year_week_timestamp.week_timestamp` to `timestamptz` and remove the `to_timestamp` cast in the KeepTradeCut column definitions; the blocking restructure task is Completed — [[████████████████████████-██-███████████████-███-████-████-████████████]]
- [ ] Operator confirms, then drop the all-NULL `nfl_games.time_start` and `time_end` after re-verifying zero consumers; `date` and `time_eastern` stay — [[████████████████████████-██████-█████████████-███-█████-█████████-████-██████████]]