parameters.md

Parameters

The template uses annotation instead of ZAEANNOTATION, library instead of ZBKLIBRARYASSET, so you use, such as:

• ZAEANNOTATION.ZANNOTATIONSELECTEDTEXT => annotation.ZANNOTATIONSELECTEDTEXT
• ZBKLIBRARYASSET.ZAUTHOR => library.ZAUTHOR

note: A book has one table with ZBKLIBRARYASSET(book info), multiple ZAEANNOTATION(book annotation)

Tables

CREATE TABLE ZAEANNOTATION (
	Z_PK INTEGER PRIMARY KEY,
	Z_ENT INTEGER,
	Z_OPT INTEGER,
	ZANNOTATIONDELETED INTEGER, 
	ZANNOTATIONISUNDERLINE INTEGER,
	ZANNOTATIONSTYLE INTEGER, 
	ZANNOTATIONTYPE INTEGER, 
	ZPLABSOLUTEPHYSICALLOCATION INTEGER, 
	ZPLLOCATIONRANGEEND INTEGER, 
	ZPLLOCATIONRANGESTART INTEGER, 
	ZANNOTATIONCREATIONDATE TIMESTAMP, 
	ZANNOTATIONMODIFICATIONDATE TIMESTAMP, 
	ZANNOTATIONASSETID VARCHAR, 
	ZANNOTATIONCREATORIDENTIFIER VARCHAR,
	ZANNOTATIONLOCATION VARCHAR, 
	ZANNOTATIONNOTE VARCHAR, 
	ZANNOTATIONREPRESENTATIVETEXT VARCHAR, 
	ZANNOTATIONSELECTEDTEXT VARCHAR,
	ZANNOTATIONUUID VARCHAR,
	ZFUTUREPROOFING1 VARCHAR,
	ZFUTUREPROOFING10 VARCHAR,
	ZFUTUREPROOFING11 VARCHAR,
	ZFUTUREPROOFING12 VARCHAR,
	ZFUTUREPROOFING2 VARCHAR,
	ZFUTUREPROOFING3 VARCHAR,
	ZFUTUREPROOFING4 VARCHAR,
	ZFUTUREPROOFING5 VARCHAR,
	ZFUTUREPROOFING6 VARCHAR,
	ZFUTUREPROOFING7 VARCHAR,
	ZFUTUREPROOFING8 VARCHAR,
	ZFUTUREPROOFING9 VARCHAR,
	ZPLSTORAGEUUID VARCHAR,
	ZPLUSERDATA BLOB 
);

CREATE TABLE ZBKLIBRARYASSET (
	Z_PK INTEGER PRIMARY KEY,
	Z_ENT INTEGER,
	Z_OPT INTEGER,
	ZCANREDOWNLOAD INTEGER,
	ZCOMBINEDSTATE INTEGER,
	ZCOMPUTEDRATING INTEGER,
	ZCONTENTTYPE INTEGER, 
	ZDESKTOPSUPPORTLEVEL INTEGER,
	ZDIDRUNFORYOUENDOFBOOKEXPERIENCE INTEGER,
	ZDIDWARNABOUTDESKTOPSUPPORT INTEGER,
	ZFILESIZE INTEGER, 
	ZGENERATION INTEGER,
	ZHASRACSUPPORT INTEGER,
	ZISDEVELOPMENT INTEGER,
	ZISDOWNLOADINGSUPPLEMENTALCONTENT INTEGER,
	ZISEPHEMERAL INTEGER,
	ZISEXPLICIT INTEGER,
	ZISFINISHED INTEGER,
	ZISHIDDEN INTEGER,
	ZISLOCKED INTEGER,
	ZISNEW INTEGER,
	ZISPROOF INTEGER,
	ZISSAMPLE INTEGER,
	ZISSTOREAUDIOBOOK INTEGER,
	ZISSUPPLEMENTALCONTENT INTEGER,
	ZISTRACKEDASRECENT INTEGER,
	ZMETADATAMIGRATIONVERSION INTEGER,
	ZNOTFINISHED INTEGER,
	ZPAGECOUNT INTEGER, 
	ZRATING INTEGER,
	ZSERIESISCLOUDONLY INTEGER,
	ZSERIESISHIDDEN INTEGER,
	ZSERIESNEXTFLAG INTEGER,
	ZSERIESSORTKEY INTEGER,
	ZSORTKEY INTEGER,
	ZSTATE INTEGER,
	ZTASTE INTEGER,
	ZTASTESYNCEDTOSTORE INTEGER,
	ZLOCALONLYSERIESITEMSPARENT INTEGER,
	ZPURCHASEDANDLOCALPARENT INTEGER,
	ZSERIESCONTAINER INTEGER,
	ZSUPPLEMENTALCONTENTPARENT INTEGER,
	ZASSETDETAILSMODIFICATIONDATE TIMESTAMP,
	ZBOOKHIGHWATERMARKPROGRESS FLOAT, 
	ZBOOKMARKSSERVERMAXMODIFICATIONDATE TIMESTAMP,
	ZCREATIONDATE TIMESTAMP, 
	ZDATEFINISHED TIMESTAMP, 
	ZDURATION FLOAT, 
	ZEXPECTEDDATE TIMESTAMP,
	ZFILEONDISKLASTTOUCHDATE TIMESTAMP,
	ZLASTENGAGEDDATE TIMESTAMP,
	ZLASTOPENDATE TIMESTAMP, 
	ZLOCATIONSERVERMAXMODIFICATIONDATE TIMESTAMP,
	ZMODIFICATIONDATE TIMESTAMP, 
	ZPURCHASEDATE TIMESTAMP, 
	ZREADINGPROGRESS FLOAT,
	ZRELEASEDATE TIMESTAMP,
	ZUPDATEDATE TIMESTAMP,
	ZVERSIONNUMBER FLOAT, 
	ZACCOUNTID VARCHAR,
	ZASSETGUID VARCHAR,
	ZASSETID VARCHAR,
	ZAUTHOR VARCHAR,
	ZBOOKDESCRIPTION VARCHAR, 
	ZBOOKMARKSSERVERVERSION VARCHAR,
	ZCOMMENTS VARCHAR, 
	ZCOVERURL VARCHAR, 
	ZCOVERWRITINGMODE VARCHAR,
	ZDATASOURCEIDENTIFIER VARCHAR,
	ZDOWNLOADEDDSID VARCHAR,
	ZEPUBID VARCHAR,
	ZFAMILYID VARCHAR,
	ZGENRE VARCHAR, 
	ZGROUPING VARCHAR,
	ZKIND VARCHAR,
	ZLANGUAGE VARCHAR,
	ZLOCATIONSERVERVERSION VARCHAR,
	ZPAGEPROGRESSIONDIRECTION VARCHAR,
	ZPATH VARCHAR, 
	ZPERMLINK VARCHAR,
	ZPURCHASEDDSID VARCHAR,
	ZSEQUENCEDISPLAYNAME VARCHAR,
	ZSERIESID VARCHAR,
	ZSERIESSTACKIDS VARCHAR,
	ZSORTAUTHOR VARCHAR,
	ZSORTTITLE VARCHAR,
	ZSTOREID VARCHAR,
	ZSTOREPLAYLISTID VARCHAR,
	ZTEMPORARYASSETID VARCHAR,
	ZTITLE VARCHAR,
	ZVERSIONNUMBERHUMANREADABLE VARCHAR,
	ZYEAR VARCHAR 
);