-- Table: public."Providers"

-- DROP TABLE public."Providers";

CREATE TABLE public."Providers"
(
    provider_id integer NOT NULL DEFAULT nextval('"Providers_provider_id_seq"'::regclass),
    provider_name text COLLATE pg_catalog."default" NOT NULL,
    provider_agent text COLLATE pg_catalog."default" NOT NULL,
    provider_post text COLLATE pg_catalog."default" NOT NULL,
    provider_city text COLLATE pg_catalog."default" NOT NULL,
    provider_country text COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT "Providers_pkey" PRIMARY KEY (provider_id)
)

TABLESPACE pg_default;

ALTER TABLE public."Providers"
    OWNER to postgres;



-- Table: public."Medicines"

-- DROP TABLE public."Medicines";

CREATE TABLE public."Medicines"
(
    medicines_id integer NOT NULL DEFAULT nextval('"Medicines_medicines_id_seq"'::regclass),
    medicines_name text COLLATE pg_catalog."default" NOT NULL,
    medicines_group text COLLATE pg_catalog."default" NOT NULL,
    provider_id integer NOT NULL DEFAULT nextval('"Medicines_provider_id_seq"'::regclass),
    units text COLLATE pg_catalog."default" NOT NULL,
    purchase_price money NOT NULL,
    selling_price money NOT NULL,
    CONSTRAINT "Medicines_pkey" PRIMARY KEY (medicines_id)
)

TABLESPACE pg_default;

ALTER TABLE public."Medicines"
    OWNER to postgres;


-- Table: public."Ordered"

-- DROP TABLE public."Ordered";

CREATE TABLE public."Ordered"
(
    order_id integer NOT NULL DEFAULT nextval('"Ordered_order_id_seq"'::regclass),
    medicines_id integer NOT NULL DEFAULT nextval('"Ordered_medicines_id_seq"'::regclass),
    selling_price money NOT NULL,
    amount integer NOT NULL,
    discount character varying(4) COLLATE pg_catalog."default",
    CONSTRAINT "Ordered_pkey" PRIMARY KEY (order_id, medicines_id)
)

TABLESPACE pg_default;

ALTER TABLE public."Ordered"
    OWNER to postgres;


-- Table: public."Orders"

-- DROP TABLE public."Orders";

CREATE TABLE public."Orders"
(
    order_id integer NOT NULL DEFAULT nextval('"Orders_order_id_seq"'::regclass),
    client_id integer NOT NULL DEFAULT nextval('"Orders_client_id_seq"'::regclass),
    employee_id integer NOT NULL DEFAULT nextval('"Orders_employee_id_seq"'::regclass),
    placement_date date NOT NULL,
    selling_date date NOT NULL,
    recipient_name text COLLATE pg_catalog."default" NOT NULL,
    recipient_adress text COLLATE pg_catalog."default" NOT NULL,
    recipient_city text COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT "Orders_pkey" PRIMARY KEY (order_id)
)

TABLESPACE pg_default;

ALTER TABLE public."Orders"
    OWNER to postgres;



-- Table: public."Staff"

-- DROP TABLE public."Staff";

CREATE TABLE public."Staff"
(
    employee_id integer NOT NULL DEFAULT nextval('"Staff_employee_id_seq"'::regclass),
    first_name text COLLATE pg_catalog."default" NOT NULL,
    last_name text COLLATE pg_catalog."default" NOT NULL,
    middle_name text COLLATE pg_catalog."default" NOT NULL,
    employee_post text COLLATE pg_catalog."default" NOT NULL,
    salary money,
    CONSTRAINT "Staff_pkey" PRIMARY KEY (employee_id)
)

TABLESPACE pg_default;

ALTER TABLE public."Staff"
    OWNER to postgres;


-- Table: public."Clients"

-- DROP TABLE public."Clients";

CREATE TABLE public."Clients"
(
    client_id integer NOT NULL DEFAULT nextval('"Clients_client_id_seq"'::regclass),
    client_name text COLLATE pg_catalog."default" NOT NULL,
    client_adress text COLLATE pg_catalog."default" NOT NULL,
    client_city text COLLATE pg_catalog."default" NOT NULL,
    client_phone character varying(15) COLLATE pg_catalog."default",
    CONSTRAINT "Clients_pkey" PRIMARY KEY (client_id)
)

TABLESPACE pg_default;

ALTER TABLE public."Clients"
    OWNER to postgres;