create table address (
       id uuid not null,
        addressExtra varchar(255),
        city varchar(255),
        contextId uuid,
        contextType int4,
        rs int4 default 0,
        street varchar(255),
        t0 timestamp,
        userId uuid,
        zip varchar(255),
        primary key (id)
    );

    create table backoffice_delete (
       id uuid not null,
        deletedJsonObject TEXT,
        info varchar(255),
        t0 timestamp,
        type varchar(255),
        primary key (id)
    );

    create table backoffice_delete_log (
       id uuid not null,
        actionInfo TEXT,
        authId uuid,
        authUser varchar(255),
        t0 timestamp,
        type varchar(255),
        primary key (id)
    );

    create table bulk_mail (
       id uuid not null,
        currentStatus int4,
        nextStatus int4,
        partner varchar(255),
        records int4,
        t0 timestamp,
        year int4,
        primary key (id)
    );

    create table bulk_mail_item (
       id uuid not null,
        idBonus uuid,
        idBulkMailing uuid,
        t0 timestamp,
        primary key (id)
    );

    create table car (
       id uuid not null,
        connectorType int4,
        firstNameConfirmed boolean default NULL,
        firstRegistration boolean default false,
        imageIsPermit varchar(255),
        lastCompanyNameConfirmed boolean default NULL,
        noKeywordsFound boolean,
        openAiAddress varchar(255),
        openAiAttemptNr int4 default 0,
        openAiConfirmedAddress boolean default false,
        openAiConfirmedAttemptNr int4 default 0,
        openAiConfirmedVin boolean default false,
        openAiConsumed boolean default false,
        openAiFirstName varchar(255),
        openAiLastAttempt timestamp,
        openAiLastCompanyName varchar(255),
        openAiMotorType varchar(255),
        openAiPermitValidFrom varchar(255),
        openAiReCheckConfirmedAddress boolean default false,
        openAiReCheckConfirmedMotor boolean default false,
        openAiReCheckConfirmedPaperFormat boolean default false,
        openAiReCheckConfirmedSeal boolean default false,
        openAiReCheckConfirmedVin boolean default false,
        openAiVin varchar(255),
        openAiVinMatch int4 default 0,
        paperFormatHasStamp boolean,
        permitFormat varchar(255),
        permitId varchar(255),
        permitOrientation varchar(255),
        postProcessAddressStatus boolean,
        postProcessConfirmedMessage TEXT,
        postProcessImageIsPermit boolean,
        postProcessMessage TEXT,
        postProcessMotorTypeStatus boolean,
        postProcessPermitOrientationOk boolean,
        postProcessReCheckConfirmedStatus int4 default 0,
        postProcessSealStatus boolean,
        postProcessStatus int4,
        postProcessVinStatus boolean,
        rs int4 default 0,
        stringMatch boolean,
        t0 timestamp,
        title varchar(255),
        useType int4 default 1,
        userId uuid,
        userName varchar(255),
        verified boolean default false not null,
        vin varchar(255),
        primary key (id)
    );

    create table charging_station (
       id uuid not null,
        rs int4 default 0,
        t0 timestamp,
        userId uuid,
        primary key (id)
    );

    create table charging_station_bonus (
       id uuid not null,
        backendComment TEXT,
        backendImport boolean,
        backendPartnerComment TEXT,
        bonusType int4 default 3,
        bonusValue float8 default 0,
        carId uuid,
        chargingStationId varchar(255),
        chargingStationManufacturer varchar(255),
        chargingStationPorts int4,
        chargingStationPower float8,
        city varchar(255),
        connectorType int4,
        connectorTypeLabel varchar(255),
        currentStatus int4,
        currentStatusDate timestamp,
        currentStatusUserId uuid,
        currentStatusUserName varchar(255),
        dateFrom date,
        dateTo date,
        extraCharhingInfo TEXT,
        finCheckRecordCreated boolean default false,
        finCheckRecordDeleted boolean default false,
        finCheckRecordExist boolean default false,
        flatRate boolean default false,
        lastOpenedById uuid,
        lastOpenedByUserName varchar(255),
        lastOpenedDate timestamp,
        openAiConfirmedVin boolean default false,
        ownerAgreement boolean default false,
        partner varchar(255),
        powerUsed float8,
        rs int4 default 0,
        street varchar(255),
        t0 timestamp,
        useType int4,
        userId uuid,
        vatId varchar(255),
        vin varchar(255),
        zip varchar(255),
        primary key (id)
    );

    create table charging_station_bonus_status (
       id uuid not null,
        bonusId uuid,
        processedForMailing boolean,
        processedForMailingDate timestamp,
        status int4,
        t0 timestamp,
        userId uuid,
        userName varchar(255),
        primary key (id)
    );

    create table charging_station_connector (
       id uuid not null,
        description TEXT,
        frontendVisible boolean default false not null,
        rs int4 default 0,
        t0 timestamp,
        title varchar(255),
        primary key (id)
    );

    create table faq (
       id uuid not null,
        description TEXT,
        frontendVisible boolean not null,
        sortOrder int4,
        title varchar(255),
        primary key (id)
    );

    create table file (
       id uuid not null,
        carId uuid,
        fileContentType varchar(255),
        fileName varchar(255),
        filePath varchar(255),
        fileType varchar(255),
        rs int4,
        t0 timestamp,
        tempId uuid,
        userId uuid,
        vin varchar(255),
        primary key (id)
    );

    create table fincheck_history (
       id uuid not null,
        contextId uuid,
        finCheckResponse TEXT,
        overlappingDate TEXT,
        status int4,
        t0 timestamp,
        type varchar(255),
        vin varchar(255),
        primary key (id)
    );

    create table mail_partner_attachment (
       id uuid not null,
        bonusDataNotConfirmed TEXT,
        bonusDataUbaConfirmed TEXT,
        bonusDataUbaNotConfirmed TEXT,
        falseDataMail TEXT,
        newCar TEXT,
        nextYearInvitation TEXT,
        partner varchar(255),
        registerKeycloakNew TEXT,
        registerNewVin TEXT,
        verifyBonusData TEXT,
        verifyBonusDataReminder TEXT,
        year int4,
        primary key (id)
    );

    create table mail_partner_files (
       id uuid not null,
        fileName varchar(255),
        mailName varchar(255),
        partner varchar(255),
        path varchar(255),
        rs int4 default 0,
        t0 timestamp,
        type varchar(255),
        primary key (id)
    );

    create table mail_partner_smtp_config (
       id uuid not null,
        bccEmail varchar(255),
        fromEmailAddress varchar(255),
        hostname varchar(255),
        partnerKey varchar(255),
        password bytea,
        port int4,
        rs int4 default 0,
        startTLSOptions varchar(255),
        userName varchar(255),
        primary key (id)
    );

    create table mail_partner_types (
       id uuid not null,
        rs int4 default 0,
        title varchar(255),
        type varchar(255),
        primary key (id)
    );

    create table mailing (
       id uuid not null,
        attempts int default 0 not null,
        consumed boolean,
        contextId uuid,
        email varchar(255),
        oAuthId uuid,
        partnerId uuid,
        sendAttachments boolean,
        sendFailed boolean,
        t0 timestamp,
        type varchar(255),
        userId uuid,
        primary key (id)
    );

    create table mailing_verification (
       id uuid not null,
        consumed boolean not null,
        consumedTime timestamp,
        mailingId uuid,
        t0 timestamp,
        primary key (id)
    );

    create table openai_history (
       id uuid not null,
        contextId uuid,
        openAIRequest TEXT,
        openAIResponse TEXT,
        t0 timestamp,
        type varchar(255),
        vin varchar(255),
        primary key (id)
    );

    create table partner (
       id uuid not null,
        activeYear int4,
        appHeaderTitle varchar(255),
        bccEmail varchar(255),
        bonusTitle varchar(255),
        bonusType int4 default 3,
        bonusTypeNextYear int4 default 3,
        bonusValue float8 default 0,
        bonusValueNextYear float8 default 0,
        colorScheme varchar(255),
        contactEmail varchar(255),
        dataProtectionLink varchar(255),
        extraFieldsDefinition TEXT,
        fromEmail varchar(255),
        frontendVisible boolean default false not null,
        hotlinePhoneNr varchar(255),
        htmlPageTitle varchar(255),
        imgHeader TEXT,
        imgSubHeader TEXT,
        imprintHtml TEXT,
        imprintLink varchar(255),
        key varchar(255),
        mailSigniture TEXT,
        mailSignitureHasInlineLogo boolean default false not null,
        mailTemplateHasHeaderLogo boolean default false not null,
        partnerBonusTitle TEXT,
        partnerBonusTitleNextYear TEXT,
        paysOutBonus boolean default false not null,
        rs int4 default 0,
        standardLogin boolean default false not null,
        t0 timestamp,
        termsConditionsLink varchar(255),
        termsConditionsLinkCompany varchar(255),
        title varchar(255),
        url varchar(255),
        userCanRegisterBonus boolean default false not null,
        userCanRegisterBonusNextYear boolean default false not null,
        primary key (id)
    );

    create table partner_user (
       id uuid not null,
        t0 timestamp,
        verified boolean not null,
        partnerId uuid,
        userId uuid,
        primary key (id)
    );

    create table user_auth (
       id uuid not null,
        authId uuid,
        authType int4 default 1,
        rs int4 default 0,
        t0 timestamp,
        userId uuid,
        primary key (id)
    );

    create table user_auth_otp (
       id uuid not null,
        consumed boolean,
        email varchar(255),
        t0 timestamp,
        token int8,
        primary key (id)
    );

    create table user_auth_standard (
       id uuid not null,
        password bytea,
        rs int4 default 0,
        t0 timestamp,
        t1 timestamp,
        userId uuid,
        userName varchar(255),
        verified boolean,
        primary key (id)
    );

    create table user_auth_vin (
       id uuid not null,
        rs int4 default 0,
        t0 timestamp,
        t1 timestamp,
        userId uuid,
        userName varchar(255),
        verified boolean,
        vin varchar(255),
        primary key (id)
    );

    create table user_basic_data (
       id uuid not null,
        birthday date,
        companyRegistrationNo varchar(255),
        companyTitle varchar(255),
        companyVatNo varchar(255),
        contactEmail varchar(255),
        customerType int4 default 1,
        email varchar(255),
        firstName varchar(255),
        gdprExternal boolean,
        gender int4,
        lastName varchar(255),
        partner varchar(255),
        phoneNr varchar(255),
        rs int4 default 0,
        t0 timestamp,
        t1 timestamp,
        titleSuffix varchar(255),
        titleSuffixReal varchar(255),
        userAgreesWithTermsAndConditions boolean,
        primary key (id)
    );

    create table user_sepa (
       id uuid not null,
        account bytea,
        bic varchar(255),
        fullName varchar(255),
        rs int4,
        t0 timestamp,
        userId uuid,
        primary key (id)
    );
create index ndx_address_id on address (id);
create index ndx_address_contextId on address (contextId);
create index ndx_address_rs on address (rs);
create index ndx_backoffice_delete_id on backoffice_delete (id);
create index ndx_backoffice_delete_type on backoffice_delete (type);
create index ndx_backoffice_delete_log_id on backoffice_delete_log (id);
create index ndx_backoffice_delete_log_type on backoffice_delete_log (type);
create index ndx_car_id on car (id);
create index ndx_car_rs on car (rs);
create index ndx_car_userId on car (userId);
create index ndx_car_userName on car (userName);
create index ndx_charging_station_id on charging_station (id);
create index ndx_charging_station_userId on charging_station (userId);
create index ndx_charging_station_rs on charging_station (rs);
create index ndx_charging_station_bonus_id on charging_station_bonus (id);
create index ndx_charging_station_bonus_userId on charging_station_bonus (userId);
create index ndx_charging_station_bonus_vin on charging_station_bonus (vin);
create index ndx_charging_station_bonus_rs on charging_station_bonus (rs);
create index ndx_charging_station_bonus_t0 on charging_station_bonus (t0);
create index ndx_charging_station_bonus_status_bonusId on charging_station_bonus_status (bonusId);
create index ndx_charging_station_bonus_status_t0 on charging_station_bonus_status (t0);
create index ndx_charging_station_connector_id on charging_station_connector (id);
create index ndx_charging_station_connector_frontendVisible on charging_station_connector (frontendVisible);
create index ndx_charging_station_connector_rs on charging_station_connector (rs);
create index ndx_faq_frontendVisible on faq (frontendVisible);
create index ndx_faq_sortOrder on faq (sortOrder);
create index ndx_file_id on file (id);
create index ndx_file_userId on file (userId);
create index ndx_file_carId on file (carId);
create index ndx_file_vin on file (vin);
create index ndx_file_fileContentType on file (fileContentType);
create index ndx_file_rs on file (rs);
create index ndx_fincheck_history_id on fincheck_history (id);
create index ndx_mail_partner_attachment_partner on mail_partner_attachment (partner);
create index ndx_mail_partner_attachment_year on mail_partner_attachment (year);
create index ndx_mail_partner_files_partner on mail_partner_files (partner);
create index ndx_mail_partner_files_type on mail_partner_files (type);
create index ndx_mail_partner_smtp_consumed on mail_partner_smtp_config (rs);
create index ndx_mail_partner_types_type on mail_partner_types (type);
create index ndx_mailing_consumed on mailing (consumed);
create index ndx_mailing_verification_mailingId on mailing_verification (mailingId);
create index ndx_mailing_verification_consumed on mailing_verification (consumed);
create index ndx_openai_history_id on openai_history (id);
create index ndx_partner_id on partner (id);
create index ndx_partner_frontendVisible on partner (frontendVisible);
create index ndx_partner_rs on partner (rs);
create index ndx_partner_user_partner_id on partner_user (partnerId);
create index ndx_partner_user_user_id on partner_user (userId);
create index ndx_user_auth_id on user_auth (id);
create index ndx_user_auth_userId on user_auth (userId);
create index ndx_user_auth_authId on user_auth (authId);
create index ndx_user_auth_rs on user_auth (rs);
create index ndx_user_auth_otp_id on user_auth_otp (id);
create index ndx_user_auth_otp_email on user_auth_otp (email);
create index ndx_user_auth_otp_token on user_auth_otp (token);
create index ndx_user_auth_otp_consumed on user_auth_otp (consumed);
create index ndx_user_auth_otp_t0 on user_auth_otp (t0);
create index ndx_user_auth_standard_id on user_auth_standard (id);
create index ndx_user_auth_standard_userName on user_auth_standard (userName);
create index ndx_user_auth_standard_verified on user_auth_standard (verified);
create index ndx_user_auth_standard_rs on user_auth_standard (rs);
create index ndx_user_auth_vin_id on user_auth_vin (id);
create index ndx_user_auth_vin_userName on user_auth_vin (userName);
create index ndx_user_auth_vin_vin on user_auth_vin (vin);
create index ndx_user_auth_vin_verified on user_auth_vin (verified);
create index ndx_user_auth_vin_rs on user_auth_vin (rs);
create index ndx_user_data_id on user_basic_data (id);
create index ndx_user_data_t0 on user_basic_data (t0);
create index ndx_user_sepa_id on user_sepa (id);
create index ndx_user_sepa_userId on user_sepa (userId);
create index ndx_user_sepa_t0 on user_sepa (t0);
create index ndx_user_sepa_rs on user_sepa (rs);

    alter table if exists partner_user 
       add constraint FKta96f59but64hu0sqypvibl08 
       foreign key (partnerId) 
       references partner;

    alter table if exists partner_user 
       add constraint FK69yi1kt7dv5bnu6blqb8oc948 
       foreign key (userId) 
       references user_basic_data;

    alter table if exists partner_user 
       drop constraint if exists FKta96f59but64hu0sqypvibl08;

    alter table if exists partner_user 
       drop constraint if exists FK69yi1kt7dv5bnu6blqb8oc948;

    drop table if exists address cascade;

    drop table if exists backoffice_delete cascade;

    drop table if exists backoffice_delete_log cascade;

    drop table if exists bulk_mail cascade;

    drop table if exists bulk_mail_item cascade;

    drop table if exists car cascade;

    drop table if exists charging_station cascade;

    drop table if exists charging_station_bonus cascade;

    drop table if exists charging_station_bonus_status cascade;

    drop table if exists charging_station_connector cascade;

    drop table if exists faq cascade;

    drop table if exists file cascade;

    drop table if exists fincheck_history cascade;

    drop table if exists mail_partner_attachment cascade;

    drop table if exists mail_partner_files cascade;

    drop table if exists mail_partner_smtp_config cascade;

    drop table if exists mail_partner_types cascade;

    drop table if exists mailing cascade;

    drop table if exists mailing_verification cascade;

    drop table if exists openai_history cascade;

    drop table if exists partner cascade;

    drop table if exists partner_user cascade;

    drop table if exists user_auth cascade;

    drop table if exists user_auth_otp cascade;

    drop table if exists user_auth_standard cascade;

    drop table if exists user_auth_vin cascade;

    drop table if exists user_basic_data cascade;

    drop table if exists user_sepa cascade;