/ db / create.sql
create.sql
 1  create table public.home_entries (
 2    id bigint generated by default as identity not null,
 3    "order" numeric not null,
 4    title text null,
 5    image_url text null,
 6    content json null,
 7    constraint home_entries_pkey primary key (id),
 8    constraint home_entries_order_key unique ("order")
 9  ) TABLESPACE pg_default;
10  
11  create table public.agents (
12    id bigint generated by default as identity not null,
13    "order" numeric not null,
14    image_url text null,
15    name text not null,
16    content text[] null,
17    links json[] null,
18    description text null,
19    constraint agents_pkey primary key (id),
20    constraint agents_order_key unique ("order")
21  ) TABLESPACE pg_default;
22  
23  create table public.partners (
24    id bigint generated by default as identity not null,
25    title text not null,
26    description text null,
27    image_url text null,
28    constraint partners_pkey primary key (id),
29    constraint partners_title_key unique (title)
30  ) TABLESPACE pg_default;