Перейти к содержанию

payments

Колонки

колонка тип not null default
id "uuid" ✅ "gen_random_uuid"()
user_id "uuid" ✅ ``
provider "text" ✅ ``
charge_id "text" ✅ ``
currency "text" ✅ ``
amount integer ✅ ``
product_kind "text" ✅ ``
product_code "text" ✅ ``
credits_added integer ✅ 0
created_at timestamp with time zone ✅ "now"()

Ограничения

  • CONSTRAINT "payments_charge_id_key" UNIQUE ("charge_id")
  • CONSTRAINT "payments_pkey" PRIMARY KEY ("id")
  • CONSTRAINT "payments_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "public"."users"("id") ON DELETE CASCADE

Внешние ключи

  • (user_id) → users(id)