---

mc@mcris-ad-293a:~/Загрузки/Distr/Ironlogic$ sqlite3 db/database.sqlite ".schema Identifiers" ".schema Employees" ".schema DepartmentsHasEmployees" ".schema Entities" ".schema PassPoints" ".schema Controllers" ".schema Schedules"
CREATE TABLE `Identifiers` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `number` VARCHAR(255) NOT NULL, `pinCode` INTEGER, `modeType` INTEGER, `length` INTEGER, `validFrom` BIGINT, `validTo` BIGINT, `active` INTEGER, `accessTypeSource` VARCHAR(255), `isGuest` TINYINT(1) NOT NULL DEFAULT 0, `isActiveInTheZone` TINYINT(1) DEFAULT 0, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `employeeId` INTEGER REFERENCES `Employees` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, `identifierTypeId` INTEGER DEFAULT 2 REFERENCES `IdentifierTypes` (`id`) ON DELETE SET NULL ON UPDATE CASCADE);
CREATE TABLE `Employees` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `fullName` VARCHAR(255) NOT NULL, `shortName` VARCHAR(255) DEFAULT '', `sex` INTEGER, `birthday` BIGINT, `position` VARCHAR(255) DEFAULT '', `personalNumber` VARCHAR(255), `comment` VARCHAR(255), `description` TEXT, `imgDist` VARCHAR(255), `accessTypeSource` VARCHAR(255) NOT NULL, `inGroup` TINYINT(1) NOT NULL DEFAULT 0, `isGuest` TINYINT(1) NOT NULL DEFAULT 1, `state` INTEGER NOT NULL DEFAULT 0, `personalRate` DOUBLE PRECISION DEFAULT 0, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL);
CREATE TABLE `DepartmentsHasEmployees` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `employeeId` INTEGER REFERENCES `Employees` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, `departmentsId` INTEGER REFERENCES `Departments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE);
CREATE TABLE `Entities` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` VARCHAR(255) NOT NULL, `comment` VARCHAR(255), `color` VARCHAR(255), `isPeriodInheritance` TINYINT(1), `deletedDate` BIGINT, `state` INTEGER NOT NULL DEFAULT 0, `rate` DOUBLE PRECISION DEFAULT 0, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `parentId` INTEGER REFERENCES `Entities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE);
CREATE TABLE `PassPoints` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` VARCHAR(255), `state` TINYINT(1) NOT NULL DEFAULT 0, `isActiveInsTitle` TINYINT(1) NOT NULL DEFAULT 0, `isActiveOutTitle` TINYINT(1) NOT NULL DEFAULT 0, `insZoneTitle` VARCHAR(255), `outZoneTitle` VARCHAR(255), `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `controllerId` INTEGER NOT NULL REFERENCES `Controllers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, `insideEntityId` INTEGER REFERENCES `Entities` (`id`) ON DELETE SET NULL ON UPDATE CASCADE, `outsideEntitysId` INTEGER REFERENCES `Entities` (`id`) ON DELETE SET NULL ON UPDATE CASCADE);
CREATE TABLE `Controllers` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `idOnBus` INTEGER NOT NULL, `type` VARCHAR(255) NOT NULL, `name` VARCHAR(255), `desc` VARCHAR(255), `state` VARCHAR(255), `inverseDirection` TINYINT(1) NOT NULL, `serial` VARCHAR(255) UNIQUE, `lockOpenTime` INTEGER DEFAULT 4, `waitForOpenTime` INTEGER DEFAULT 4, `waitForLoseTime` INTEGER DEFAULT 4, `fireMode` INTEGER DEFAULT 0, `securMode` INTEGER DEFAULT 0, `blockMode` INTEGER DEFAULT 0, `utcTimeZoneId` INTEGER DEFAULT 0, `clearMemory` TINYINT(1) NOT NULL DEFAULT 0, `activeGeneralTime` TINYINT(1) NOT NULL DEFAULT 1, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `converterId` INTEGER NOT NULL REFERENCES `Converters` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, `entityId` INTEGER REFERENCES `Entities` (`id`) ON DELETE SET NULL ON UPDATE CASCADE);
CREATE TABLE `Schedules` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `dayStartTime` INTEGER NOT NULL, `dayEndTime` INTEGER NOT NULL, `lunchStartTime` INTEGER NOT NULL, `lunchEndTime` INTEGER NOT NULL, `shortDay` INTEGER NOT NULL, `shortDayEndTime` INTEGER NOT NULL, `startEarly` INTEGER NOT NULL, `startLate` INTEGER NOT NULL, `endEarly` INTEGER NOT NULL, `endLate` INTEGER NOT NULL, `outOfOffice` INTEGER NOT NULL, `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, `departmentId` INTEGER REFERENCES `Departments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE);
mc@mcris-ad-293a:~/Загрузки/Distr/Ironlogic$ for t in Identifiers Employees Departments DepartmentsHasEmployees Entities PassPoints Controllers Schedules; do echo "$t: $(sqlite3 db/database.sqlite "SELECT COUNT(*) FROM $t")"; done
Identifiers: 133
Employees: 180
Departments: 0
DepartmentsHasEmployees: 0
Entities: 3
PassPoints: 8
Controllers: 8
Schedules: 0
mc@mcris-ad-293a:~/Загрузки/Distr/Ironlogic$