PHP Classes

File: doc/db_schema.schemaxml

Recommend this page to a friend!
  Classes of Uldis Nelsons   D3 PHP Activity Log   doc/db_schema.schemaxml   Download  
File: doc/db_schema.schemaxml
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: D3 PHP Activity Log
Track of changes in objects of given model objects
Author: By
Last change:
Date: 2 years ago
Size: 3,958 bytes
 

Contents

Class file image Download
<?xml version="1.0" encoding="UTF-8"?> <schemadesigner version="6.5"> <source> <database charset="latin1" collation="latin1_swedish_ci">blankon_20200506</database> </source> <canvas zoom="100"> <tables> <table name="d3a_action" view="colnames"> <left>198</left> <top>235</top> <width>104</width> <height>97</height> <sql_create_table>CREATE TABLE `d3a_action` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1</sql_create_table> </table> <table name="d3a_activity" view="colnames"> <left>414</left> <top>86</top> <width>133</width> <height>199</height> <sql_create_table>CREATE TABLE `d3a_activity` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `sys_company_id` smallint(5) unsigned NOT NULL, `user_id` smallint(5) unsigned DEFAULT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `sys_model_id` tinyint(3) unsigned NOT NULL, `model_id` int(10) unsigned NOT NULL, `action_id` smallint(5) unsigned NOT NULL, `data` text, PRIMARY KEY (`id`), KEY `action_id` (`action_id`), KEY `sys_company_id` (`sys_company_id`), KEY `sys_model_id` (`sys_model_id`), CONSTRAINT `d3a_activity_ibfk_1` FOREIGN KEY (`action_id`) REFERENCES `d3a_action` (`id`), CONSTRAINT `d3a_activity_ibfk_2` FOREIGN KEY (`sys_company_id`) REFERENCES `d3c_company` (`id`), CONSTRAINT `d3a_activity_ibfk_3` FOREIGN KEY (`sys_model_id`) REFERENCES `sys_models` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1</sql_create_table> </table> <table name="d3c_company" view="colnames"> <left>616</left> <top>105</top> <width>189</width> <height>296</height> <sql_create_table>CREATE TABLE `d3c_company` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `regcode` char(30) NOT NULL COMMENT 'Registration number', `sepa` char(20) DEFAULT NULL COMMENT 'VAT', `name` varchar(255) NOT NULL COMMENT 'Name', `legal_type` enum('Juridical person','Natural person') NOT NULL DEFAULT 'Juridical person' COMMENT 'Legal Type', `type_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Type', `country_id` tinyint(3) unsigned DEFAULT NULL COMMENT 'Country', `address` varchar(255) DEFAULT NULL COMMENT 'Address', `office_address` text COMMENT 'Office Address', `status` enum('PARTNER','AUTH','CLOSED') DEFAULT NULL COMMENT 'Status', `reg_partnet_company_id` smallint(5) unsigned DEFAULT NULL COMMENT 'RegistredPartner', `comunication_language_id` tinyint(3) unsigned DEFAULT NULL COMMENT 'Comunication language', `deleted` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Deleted', `deleted_at` int(11) unsigned DEFAULT NULL COMMENT 'Deleted At', PRIMARY KEY (`id`), KEY `reg_partnet_company_id` (`reg_partnet_company_id`), KEY `type_id` (`type_id`), KEY `country_id` (`country_id`), KEY `d3c_company_ibfk_comLang` (`comunication_language_id`), CONSTRAINT `d3c_company_ibfk_1` FOREIGN KEY (`reg_partnet_company_id`) REFERENCES `d3c_company` (`id`), CONSTRAINT `d3c_company_ibfk_2` FOREIGN KEY (`country_id`) REFERENCES `cl_countries` (`id`), CONSTRAINT `d3c_company_ibfk_comLang` FOREIGN KEY (`comunication_language_id`) REFERENCES `cl_language` (`id`), CONSTRAINT `d3c_company_ibfk_type` FOREIGN KEY (`type_id`) REFERENCES `d3c_type` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=404 DEFAULT CHARSET=utf8</sql_create_table> </table> <table name="sys_models" view="colnames"> <left>198</left> <top>112</top> <width>105</width> <height>114</height> <sql_create_table>CREATE TABLE `sys_models` ( `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT, `table_name` varchar(256) NOT NULL COMMENT 'Table', `class_name` varchar(256) DEFAULT NULL COMMENT 'Class', PRIMARY KEY (`id`), UNIQUE KEY `table_name` (`table_name`,`class_name`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=ascii</sql_create_table> </table> </tables> </canvas> </schemadesigner>