• Home
• io.github.odys-z
• semantic.DA
• 1.4.45
• source code
• syn_node.sqlite.ddl

×

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.

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

-- drop table if exists syn_node;
CREATE TABLE if not exists syn_node (
	org       varchar2(12) NOT NULL,
	synid     varchar2(64) NOT NULL,   -- user input
	nyq       long NOT NULL DEFAULT 0, -- for synchronizing
	nstamp    long NOT NULL DEFAULT 0, -- for stamping new change logs
	domain    varchar2(12),            -- usually org id, null only for new nodes befor joining
	remarks   varchar2(256),
	mac       varchar2(64),
	oper      varchar2(12),
	optime    datetime,
	io_oz_synuid varchar2(25),
	-- this commound pk means the table can not maintained as a parent table by Semantics.DA
	PRIMARY KEY (org, domain, synid)
);