Untitled

buzzthedev

Sep 30th, 2024 (edited)

390

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

PostgreSQL 8.24 KB | Software | 0 0

raw download clone embed print report

create table
public.panel_settings (
display_name text not null default 'User'::text,
terms text null default '<ul><li>No refunds given</li></ul>'::text,
id uuid not null default gen_random_uuid (),
discord text null default ''::text,
logo text not null default '/default.svg'::text,
avatar_url text null default '/logo.svg'::text,
created_at timestamp with time zone null default now(),
api_key uuid null default gen_random_uuid (),
api_uses_left smallint not null default '500'::smallint,
license_active boolean not null default false,
subscription_id text null,
settings JSONB DEFAULT '{"currency_prefix": "$"}',
psk TEXT,
sk TEXT,
constraint panel_settings_pkey primary key (id),
constraint panel_settings_api_key_key unique (api_key),
constraint panel_settings_discord_check check ((length(discord) < 30)),
constraint panel_settings_display_name_check check ((length(display_name) < 100)),
constraint panel_settings_logo_check check ((length(logo) < 500)),
constraint panel_settings_terms_check check ((length(terms) < 500)),
constraint panel_settings_uses_left_check check ((api_uses_left < 5000)),
constraint panel_settings_avatar_url_check check ((length(avatar_url) < 1000))
) tablespace pg_default;
create table
public.panel_clients (
id uuid not null default gen_random_uuid (),
created_at timestamp with time zone not null default now(),
username text not null default ''::text,
discord text null,
email text null,
password text null,
avatar_url text null default ''::text,
panel_id uuid not null default auth.uid (),
stripe_id text null,
constraint panel_clients_pkey primary key (id),
constraint panel_clients_panel_id_fkey foreign key (panel_id) references panel_settings (id) on update cascade on delete cascade,
constraint panel_clients_avatar_url_check check ((length(avatar_url) < 10000)),
constraint panel_clients_discord_check check ((length(discord) < 30)),
constraint panel_clients_email_check check ((length(email) < 50)),
constraint panel_clients_username_check check ((length(username) < 30))
) tablespace pg_default;
create table
public.notifications (
id bigint generated by default as identity,
created_at timestamp with time zone not null default now(),
panel_id uuid not null default auth.uid (),
title text null default 'New notification'::text,
message text null,
subject uuid null default gen_random_uuid (),
link text not null default '/notifications'::text,
read boolean null default false,
constraint notifications_pkey primary key (id),
constraint public_notifications_panel_id_fkey foreign key (panel_id) references panel_settings (id) on update cascade on delete cascade,
constraint public_notifications_subject_fkey foreign key (subject) references panel_clients (id) on update cascade on delete cascade
) tablespace pg_default;
create table
public.products (
id bigint generated by default as identity,
creator uuid not null default auth.uid (),
description text null default ''::text,
date_created timestamp with time zone not null default now(),
constraint products_pkey primary key (id),
constraint products_creator_fkey foreign key (creator) references panel_settings (id) on update cascade,
constraint products_description_check check ((length(description) < 36))
) tablespace pg_default;
create table
public.panel_commissions (
created_at timestamp with time zone not null default now(),
title text null default 'New commission'::text,
client uuid null,
total_value numeric null default 0.00,
total_paid numeric null default 0.00,
start_date timestamp with time zone null default now(),
deadline timestamp with time zone null default now(),
status text not null default 'not_started'::text,
id uuid not null default gen_random_uuid (),
panel_id uuid not null default auth.uid (),
tracking_id uuid not null default gen_random_uuid (),
product bigint null,
pinned boolean null default false,
notes text null,
constraint panel_commissions_pkey primary key (id),
constraint panel_commissions_tracking_id_key unique (tracking_id),
constraint panel_commissions_panel_id_fkey foreign key (panel_id) references panel_settings (id) on update cascade on delete cascade,
constraint panel_commissions_client_fkey foreign key (client) references panel_clients (id) on update cascade on delete cascade,
constraint panel_commissions_product_fkey foreign key (product) references products (id) on update cascade on delete restrict,
constraint panel_commissions_notes_check check ((length(notes) < 1500)),
constraint panel_commissions_status_check check ((length(status) < 20))
) tablespace pg_default;
create table
public.panel_quotes (
created_at timestamp with time zone not null default now(),
title text null default 'New quote'::text,
client uuid null,
proposed_amount integer null default 0,
start_date timestamp with time zone not null default now(),
deadline timestamp with time zone not null default now(),
payment_terms text not null default 'custom'::text,
status text not null default 'pending'::text,
id uuid not null default gen_random_uuid (),
panel_id uuid not null default auth.uid (),
constraint panel_quotes_pkey primary key (id),
constraint panel_quotes_client_fkey foreign key (client) references panel_clients (id) on update cascade on delete cascade,
constraint panel_quotes_panel_id_fkey foreign key (panel_id) references panel_settings (id) on update cascade on delete cascade,
constraint panel_quotes_proposed_amount_check check ((proposed_amount < 10000000))
) tablespace pg_default;
create table
public.panel_requests (
created_at timestamp with time zone not null default now(),
description text not null,
offered_amount numeric null default 0.00,
deadline timestamp with time zone null,
status text not null default 'requested'::text,
id uuid not null default gen_random_uuid (),
panel_id uuid not null default auth.uid (),
commission uuid null,
paid boolean not null default false,
constraint panel_requests_pkey primary key (id),
constraint panel_requests_commission_fkey foreign key (commission) references panel_commissions (id) on update cascade on delete cascade,
constraint panel_requests_panel_id_fkey foreign key (panel_id) references panel_settings (id) on update cascade on delete cascade,
constraint panel_requests_description_check check ((length(description) > 0)),
constraint panel_requests_status_check check ((length(status) < 20))
) tablespace pg_default;
create table
public.panel_views (
id bigint generated by default as identity,
data json not null,
panel_id uuid null default auth.uid (),
name text not null default 'New view'::text,
constraint panel_views_pkey primary key (id),
constraint panel_views_panel_id_fkey foreign key (panel_id) references panel_settings (id) on update cascade on delete cascade,
constraint panel_views_name_check check ((length(name) < 30))
) tablespace pg_default;
create table
public.panel_invoices (
created_at timestamp with time zone not null default now(),
amount real null default '0'::real,
link text null,
paid_at timestamp with time zone null,
client uuid null,
title text null,
pinned boolean null default false,
panel_id uuid null default auth.uid (),
id uuid not null default gen_random_uuid (),
due_date timestamp with time zone null,
status text null default 'unpaid'::text,
stripe_invoice_id text null,
memo text null,
type TEXT,
commission UUID,
constraint panel_invoices_pkey primary key (id),
constraint panel_invoices_id_key unique (id),
constraint panel_invoices_client_fkey foreign key (client) references panel_clients (id),
constraint panel_invoices_panel_id_fkey foreign key (panel_id) references panel_settings (id) on update cascade on delete cascade,
constraint fk_commission foreign key (commission) references panel_commissions (id)
) tablespace pg_default;

Add Comment

Please, Sign In to add comment