zhywpt-issuer/zhywpt-dps-iasq/resource/table.sql

create table sample_system_info
(
    id          varchar2(32)  not null,
    conf_type   varchar2(20)  not null,
    json_str    varchar2(2000)  not null,
    update_time date not null,
    user_id     varchar2(32)  not null,
    ziped       number(1, 0)  not null
);

create table sample_lock
(
    id          varchar2(32) not null,
    insert_time date not null,
    expire_time date not null,
    node        varchar2(25) not null,
    running     number(1,0) not null,
    constraint sample_lock primary key (id)
);