<?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>
|