create table if not exists devcloud.deployment
(
    id            int auto_increment
        primary key,
    name          varchar(23)                         not null,
    deployed_time timestamp default CURRENT_TIMESTAMP not null,
    access_url    varchar(127)                        not null,
    pipeline_id   int                                 null,
    constraint deployment_pipeline_id_fk
        foreign key (pipeline_id) references devcloud.pipelinePO (id)
);

