io.odysz.semantic.meta.syn_exchange_buf.sqlite.ddl Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of semantic.DA Show documentation

JDBC Data Access with Semantics Support

There is a newer version: 1.5.3

-- drop table if exists syn_change_buf;
create table if not exists syn_exchange_buf (
    peer        varchar2(12) not null, -- session peer
    changeId    varchar2(12) not null, -- chage.cid, domain unique change ID, not auto key (copied)
    pagex       int          not null default 0,
    -- bellows are not used
    /*
    entfk       varchar2(12) not null, -- entity fk, redundant for convenient, not for synchronizing
    domain      varchar2(12) not null,
    tabl        varchar2(64) not null, -- e.g. 'h_photos'
    crud        char(1)      NOT NULL,
    synoder     varchar2(64) not null, -- changer
    uids        text         not null, -- for h_photos.device:fullpath, or composed PK for resouce's id, not null?
    nyquence    long         not null,
    updcols     varchar2(256)
    */

    -- constraint  syn_change_pk PRIMARY KEY (peer, entfk, domain, tabl, crud, synoder, nyquence)
    constraint  syn_change_pk PRIMARY KEY (peer, changeId, pagex)
);