# schema_

name_: Master_
type_: table
sql_:
  CREATE TABLE Master_ (id_ INTEGER PRIMARY KEY,type_ TEXT,validate_ INTEGER,verMajor_ INTEGER,verMinor_ INTEGER)


name_: ArchiveHead_
type_: table
sql_:
  CREATE TABLE ArchiveHead_ (id_ INTEGER PRIMARY KEY,type_ TEXT,archiveType_ INTEGER,dataType_ INTEGER,flags_ INTEGER,archiveId_ TEXT,linkedId_ TEXT,version_ INTEGER,versionCount_ BIGINT,taskId_ TEXT,computerId_ TEXT,creationTime_ TEXT)


name_: Slice_
type_: table
sql_:
  CREATE TABLE Slice_ (id_ INTEGER PRIMARY KEY,type_ TEXT,sliceId_ TEXT,parentId_ TEXT,index_ TEXT,sliceType_ INTEGER,flags_ INTEGER,name_ TEXT,description_ TEXT,rating_ INTEGER,dataCreationTime_ TEXT,volumeCreationTime_ TEXT,totalFilesSize_ BIGINT,videoCategoryFilesSize_ BIGINT,audioCategoryFilesSize_ BIGINT,pictureCategoryFilesSize_ BIGINT,documentCategoryFilesSize_ BIGINT,otherCategoryFilesSize_ BIGINT,systemCategoryFilesSize_ BIGINT,totalFilesCount_ INTEGER,videoCategoryFilesCount_ INTEGER,audioCategoryFilesCount_ INTEGER,pictureCategoryFilesCount_ INTEGER,documentCategoryFilesCount_ INTEGER,otherCategoryFilesCount_ INTEGER,systemCategoryFilesCount_ INTEGER)


name_: Volume_
type_: table
sql_:
  CREATE TABLE Volume_ (id_ INTEGER PRIMARY KEY,type_ TEXT,volumeId_ TEXT,index_ INTEGER,flags_ INTEGER,volumeSize_ TEXT,userName_ TEXT,password_ TEXT,uri_ TEXT,deviceInstanceId_ TEXT,partitionId_ TEXT)


name_: SliceCreation_
type_: table
sql_:
  CREATE TABLE SliceCreation_ (id_ INTEGER PRIMARY KEY,type_ TEXT,creationTime_ TEXT,flags_ INTEGER,creationId_ TEXT,logName_ TEXT)


name_: ProtectedArchive_
type_: table
sql_:
  CREATE TABLE ProtectedArchive_ (id_ INTEGER PRIMARY KEY,type_ TEXT,archiveId_ TEXT,archiveType_ INTEGER,dataType_ INTEGER,uri_ TEXT)


name_: OnlineArchive_
type_: table
sql_:
  CREATE TABLE OnlineArchive_ (id_ INTEGER PRIMARY KEY,type_ TEXT,name_ TEXT,archiveSize_ TEXT,sessionStatus_ INTEGER,archiveType_ INTEGER,archiveOSType_ INTEGER,diskBackup_ INTEGER,entirePcBackup_ INTEGER,encrypted_ INTEGER,magicBox_ INTEGER,notarized_ INTEGER,nonstop_ INTEGER,versionsStatus_ INTEGER,versionsCount_ INTEGER,lastVersion_ TEXT,dataCenterId_ TEXT,dataCenterName_ TEXT,dataCenterCountryName_ TEXT,dataCenterCountryId_ TEXT,computerId_ TEXT,chassis_ INTEGER,displayName_ TEXT,creationTime_ TEXT,totalFilesSize_ BIGINT,videoCategoryFilesSize_ BIGINT,audioCategoryFilesSize_ BIGINT,pictureCategoryFilesSize_ BIGINT,documentCategoryFilesSize_ BIGINT,otherCategoryFilesSize_ BIGINT,systemCategoryFilesSize_ BIGINT,totalFilesCount_ INTEGER,videoCategoryFilesCount_ INTEGER,audioCategoryFilesCount_ INTEGER,pictureCategoryFilesCount_ INTEGER,documentCategoryFilesCount_ INTEGER,otherCategoryFilesCount_ INTEGER,systemCategoryFilesCount_ INTEGER)


name_: MountArchive_
type_: table
sql_:
  CREATE TABLE MountArchive_ (id_ INTEGER PRIMARY KEY,type_ TEXT,letter_ TEXT,uri_ TEXT,archiveId_ TEXT,password_ TEXT)


name_: LocalMobileArchive_
type_: table
sql_:
  CREATE TABLE LocalMobileArchive_ (id_ INTEGER PRIMARY KEY,type_ TEXT,taskId_ TEXT,name_ TEXT,model_ TEXT,osType_ INTEGER,osVersion_ TEXT,status_ INTEGER,lastBackupTime_ BIGINT,lastPairingTime_ BIGINT,lastReportTime_ BIGINT,archiveSize_ BIGINT,deviceType_ INTEGER,encrypted_ INTEGER,includeDataTypes_ TEXT,lastQRScanTime_ BIGINT)


name_: Odc065d781a9bf0f887c446bf3338d
type_: table
sql_:
  CREATE TABLE Odc065d781a9bf0f887c446bf3338d (OnlineArchive1_ INTEGER UNIQUE,OnlineArchiveGroup2_ INTEGER)


name_: O81731d55dc21473542f252762a567
type_: index
sql_:
  CREATE INDEX O81731d55dc21473542f252762a567 ON ArchiveGroup_ArchiveHead_ (ArchiveGroup1_,ArchiveHead2_)


name_: O86e2f818f9e18b0ddd0f0119359d3
type_: index
sql_:
  CREATE INDEX O86e2f818f9e18b0ddd0f0119359d3 ON ArchiveHead_SliceCreation_ (ArchiveHead1_,SliceCreation2_)


name_: Oc40d61cf04ea0d24cbad5974b312d
type_: index
sql_:
  CREATE INDEX Oc40d61cf04ea0d24cbad5974b312d ON Odc065d781a9bf0f887c446bf3338d (OnlineArchiveGroup2_)


name_: O038faa5013c2383bdfd885ccf0881
type_: index
sql_:
  CREATE INDEX O038faa5013c2383bdfd885ccf0881 ON Odc065d781a9bf0f887c446bf3338d (OnlineArchive1_,OnlineArchiveGroup2_)


