1h10HS2F

1DROP SCHEMA IF EXISTS hello_schema CASCADE;
2
3CREATE SCHEMA IF NOT EXISTS hello_schema;
4
5CREATE TABLE IF NOT EXISTS hello_schema.couriers(
6    courier_id SERIAL PRIMARY KEY,
7    courier_type TEXT,
8    regions INTEGER[],
9    working_hours TEXT[][]
10);
11
12CREATE TABLE IF NOT EXISTS hello_schema.users (
13    name TEXT PRIMARY KEY,
14    count INTEGER DEFAULT(1)
15);
16
17
18
19CREATE TABLE IF NOT EXISTS hello_schema.orders(
20    order_id SERIAL PRIMARY KEY,
21    region INTEGER,
22    weight FLOAT,
23    price INTEGER,
24    delivery_time TEXT[]
25)
26
27