SQL Developer
Создай таблицу payments
id
order_id
payment_date
payment_type
paid_amount
Ответы
```sql
CREATE TABLE payments (
id BIGSERIAL PRIMARY KEY,
order_id BIGINT NOT NULL REFERENCES orders(id) ON DELETE CASCADE,
payment_date TIMESTAMPTZ NOT NULL DEFAULT now(),
payment_type TEXT NOT NULL CHECK (payment_type IN ('card','cash','bank_transfer','apple_pay')),
paid_amount NUMERIC(12,2) NOT NULL CHECK (paid_amount > 0)
);
```