SQL Developer
Создай таблицу orders
orders
id
user_id
order_date
amount
status
created_at
Ответы
```sql
CREATE TABLE orders (
id BIGSERIAL PRIMARY KEY,
user_id BIGINT NOT NULL REFERENCES users(id) ON DELETE RESTRICT,
order_date DATE NOT NULL DEFAULT CURRENT_DATE,
amount NUMERIC(12,2) NOT NULL CHECK (amount >= 0),
status TEXT NOT NULL CHECK (status IN ('new','paid','cancelled','refunded')),
created_at TIMESTAMPTZ NOT NULL DEFAULT now()
);
```