Колонки
| колонка |
тип |
not null |
default |
id |
"uuid" |
✅ |
"gen_random_uuid"() |
code |
"text" |
|
`` |
user_id |
"uuid" |
|
`` |
created_at |
timestamp with time zone |
✅ |
"now"() |
Ограничения
CONSTRAINT "promo_redemptions_code_user_id_key" UNIQUE ("code", "user_id")
CONSTRAINT "promo_redemptions_pkey" PRIMARY KEY ("id")
CONSTRAINT "promo_redemptions_code_fkey" FOREIGN KEY ("code") REFERENCES "public"."promo_codes"("code") ON DELETE CASCADE
CONSTRAINT "promo_redemptions_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE
Внешние ключи
- (code) → promo_codes(code)
- (user_id) → users(id)