• Home
• fr.pacifista.api.support.tickets.service
• pacifista-support-tickets-service
• 1.5.0
• source code
• DISABLED_V1.0.0__init_support_tickets.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.DISABLED_V1.0.0__init_support_tickets.sql Maven / Gradle / Ivy

create table pacifista_support_tickets
(
    id                bigserial primary key,
    created_at        timestamp(6)   not null,
    updated_at        timestamp(6),
    uuid              varchar(255)   not null constraint uk_public_id_pacifista_support_ticket unique,
    object            varchar(255)   not null,
    created_by_name   varchar(255)   not null,
    created_by_id     varchar(255)   not null,
    creation_source   varchar(100)   not null,
    status            varchar(100)   not null,
    type              varchar(100)   not null
);

create table pacifista_support_tickets_messages
(
    id              bigserial primary key,
    created_at      timestamp(6)   not null,
    updated_at      timestamp(6),
    uuid            varchar(255)   not null constraint uk_public_id_pacifista_support_ticket_message unique,
    message         varchar(10000) not null,
    written_by_id   varchar(255)   not null,
    written_by_name varchar(255)   not null,
    ticket_id       bigint         not null constraint link_to_support_ticket_pcfta references pacifista_support_tickets
);