create table public.case_line_items (
       case_line_item_id int8 not null,
        asset_c varchar(255),
        case_c varchar(255),
        createdAt timestamp,
        sales_order_sap_c varchar(255),
        salesforce_id varchar(255),
        updatedAt timestamp,
        primary key (case_line_item_id)
    );

    create table public.clients (
       client_id int8 not null,
        createdAt timestamp,
        salesforce_id varchar(255),
        sap_client_id varchar(255),
        sap_functional_location_id varchar(255),
        tax_number int8,
        updatedAt timestamp,
        primary key (client_id)
    );

    create table public.equipments (
       equipment_id int8 not null,
        createdAt timestamp,
        equipment_number varchar(255),
        product_code varchar(255),
        salesforce_id varchar(255),
        serial_number varchar(255),
        updatedAt timestamp,
        primary key (equipment_id)
    );

    create table public.matmas (
       matmas_id int8 not null,
        createdAt timestamp,
        product_code varchar(255),
        salesforce_id varchar(255),
        updatedAt timestamp,
        primary key (matmas_id)
    );

    create table public.notifications (
       notification_id int8 not null,
        createdAt timestamp,
        salesforce_id varchar(255),
        sap_notification_number_c varchar(255),
        updatedAt timestamp,
        primary key (notification_id)
    );

    create table public.sap_documents (
       sap_document_id int8 not null,
        createdAt timestamp,
        doc_num int8,
        documentType varchar(255),
        status varchar(255),
        updatedAt timestamp,
        xml_document TEXT,
        primary key (sap_document_id)
    );
create sequence case_line_items_seq start 1 increment 50;
create sequence clients_seq start 1 increment 50;
create sequence equipments_seq start 1 increment 50;
create sequence matmas_seq start 1 increment 50;
create sequence notifications_seq start 1 increment 50;
create sequence sap_documents_seq start 1 increment 50;

    drop table if exists public.case_line_items cascade;

    drop table if exists public.clients cascade;

    drop table if exists public.equipments cascade;

    drop table if exists public.matmas cascade;

    drop table if exists public.notifications cascade;

    drop table if exists public.sap_documents cascade;

    drop sequence if exists case_line_items_seq;

    drop sequence if exists clients_seq;

    drop sequence if exists equipments_seq;

    drop sequence if exists matmas_seq;

    drop sequence if exists notifications_seq;

    drop sequence if exists sap_documents_seq;