promotions

source

Discount codes — the catalog.

Definition

The promo/discount catalog. `discount_type` is one of `percent`, `flat`, or `free_shipping`; `discount_value` encodes the percent (5–30), flat dollar amount, or 0. `max_redemptions` caps total usage.

9 of 9

Column

Description

Tests · PII

promotion_id

Primary key — BIGSERIAL.

2 tests

code

Display code shown to customers.

2 tests

description

Marketing-facing description. Nullable.

discount_type

`percent` / `flat` / `free_shipping`.

1 test

discount_value

Percent (5–30), flat $ amount, or 0. NUMERIC(10,2).

starts_at

Window start. TIMESTAMPTZ.

ends_at

Window end. Null = no expiry.

max_redemptions

Cap on total redemptions. Null = unlimited.

created_at

Row insert timestamp in the source DB.