· 8 years ago · Dec 22, 2017, 05:28 PM
1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema cps
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema cps
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `cps` DEFAULT CHARACTER SET utf8 ;
15USE `cps` ;
16
17-- -----------------------------------------------------
18-- Table `cps`.`integration_asset`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `cps`.`integration_asset` (
21 `id` INT NOT NULL AUTO_INCREMENT,
22 `AccountId` INT NULL,
23 `CreatedById` VARCHAR(45) NULL,
24 `ProductCode` VARCHAR(45) NULL,
25 `PurchaseDate` DATETIME NULL,
26 `InstallDate` DATETIME NULL,
27 `UsageEndDate` DATETIME NULL,
28 `Description` TEXT NULL,
29 `ProductDescription` TEXT NULL,
30 `Name` VARCHAR(45) NULL,
31 `SerialNumber` VARCHAR(45) NULL,
32 `Price` DECIMAL(10,2) NULL,
33 `Product2Id` VARCHAR(45) NULL,
34 `OwnerId` VARCHAR(45) NULL,
35 `Quantity` VARCHAR(45) NULL,
36 `Status` VARCHAR(45) NULL,
37 `LastModifiedById` VARCHAR(45) NULL,
38 `ProductType` VARCHAR(45) NULL,
39 `Model` VARCHAR(45) NULL,
40 `Warehouse` VARCHAR(45) NULL,
41 `AssetNumber` VARCHAR(45) NULL,
42 `IntegrationStatus` VARCHAR(255) NULL,
43 `IntegrationMessage` TEXT NULL,
44 `IntegrationDate` DATETIME NULL,
45 PRIMARY KEY (`id`))
46ENGINE = InnoDB;
47
48
49-- -----------------------------------------------------
50-- Table `cps`.`integration_account`
51-- -----------------------------------------------------
52CREATE TABLE IF NOT EXISTS `cps`.`integration_account` (
53 `id` INT NOT NULL AUTO_INCREMENT,
54 `AccountId` VARCHAR(45) NULL,
55 `CompanyName` VARCHAR(255) NULL,
56 `Name` VARCHAR(255) NULL,
57 `CRCCode` VARCHAR(255) NULL,
58 `S21Code` VARCHAR(255) NULL,
59 `AccountType` VARCHAR(45) NULL,
60 `ContractExpirationDate` DATETIME NULL,
61 `LockBy` VARCHAR(45) NULL,
62 `Lock` TINYINT NULL,
63 `LockDate` DATETIME NULL,
64 `Origin` VARCHAR(255) NULL,
65 `PersonType` VARCHAR(255) NULL,
66 `Phone` VARCHAR(45) NULL,
67 `StateInscription` VARCHAR(255) NULL,
68 `Website` VARCHAR(255) NULL,
69 `Industrytype` VARCHAR(255) NULL,
70 `Emails` VARCHAR(255) NULL,
71 `IntegrationStatus` VARCHAR(255) NULL,
72 `IntegrationMessage` TEXT NULL,
73 `IntegrationDate` DATETIME NULL,
74 `CustomerID` INT NULL,
75 `PlanCode` INT NULL,
76 `PlanDescription` VARCHAR(255) NULL,
77 `Comments` TEXT NULL,
78 PRIMARY KEY (`id`))
79ENGINE = InnoDB;
80
81
82-- -----------------------------------------------------
83-- Table `cps`.`integration_address`
84-- -----------------------------------------------------
85CREATE TABLE IF NOT EXISTS `cps`.`integration_address` (
86 `id` INT NOT NULL AUTO_INCREMENT,
87 `AccountId` VARCHAR(255) NULL,
88 `CustomerCode` VARCHAR(255) NULL,
89 `CodeAdress` VARCHAR(255) NULL,
90 `Type` VARCHAR(255) NULL,
91 `Street` VARCHAR(255) NULL,
92 `Number` VARCHAR(255) NULL,
93 `Complement` VARCHAR(255) NULL,
94 `Neighborhood` VARCHAR(255) NULL,
95 `City` VARCHAR(255) NULL,
96 `State` VARCHAR(255) NULL,
97 `CEP` VARCHAR(255) NULL,
98 `Active` TINYINT NULL,
99 `Origin` VARCHAR(255) NULL,
100 `CRCCode` VARCHAR(255) NULL,
101 `IntegrationStatus` VARCHAR(255) NULL,
102 `IntegrationMessage` TEXT NULL,
103 `IntegrationDate` DATETIME NULL,
104 `Country` VARCHAR(255) NULL,
105 `Principal` TINYINT NULL,
106 PRIMARY KEY (`id`))
107ENGINE = InnoDB;
108
109
110-- -----------------------------------------------------
111-- Table `cps`.`integration_contract`
112-- -----------------------------------------------------
113CREATE TABLE IF NOT EXISTS `cps`.`integration_contract` (
114 `idContract` INT NOT NULL AUTO_INCREMENT,
115 `Id` VARCHAR(45) NULL,
116 `AccountID` VARCHAR(45) NULL,
117 `ContratoID` VARCHAR(45) NULL,
118 `NumeroContrato` VARCHAR(45) NULL,
119 `Sequence` VARCHAR(45) NULL,
120 `ContractTerm` INT NULL,
121 `ContractStyle` VARCHAR(45) NULL,
122 `StartDate` DATETIME NULL,
123 `EndDate` DATETIME NULL,
124 `Status` VARCHAR(45) NULL,
125 `BasePrice` DECIMAL(10,2) NULL,
126 `BillToCode` VARCHAR(45) NULL,
127 `ShipToCode` VARCHAR(45) NULL,
128 `SerialNumberQuantity` INT NULL,
129 `Origin` VARCHAR(45) NULL,
130 `CreatedDate` DATETIME NULL,
131 `CancelDate` DATETIME NULL,
132 `CanceledBy` VARCHAR(255) NULL,
133 `IntegrationStatus` VARCHAR(255) NULL,
134 `IntegrationMessage` TEXT NULL,
135 `IntegrationDate` DATETIME NULL,
136 `Name` VARCHAR(45) NULL,
137 `ContractQuantityServiceLoan` INT NULL,
138 `AvailableQuantityServiceLoan` INT NULL,
139 `ContractQuantityFreeLoan` INT NULL,
140 `AvailableQuantityFreeLoan` INT NULL,
141 `ContractQuatityCleanandCheck` INT NULL,
142 `AvailableQuatityCleanandCheck` INT NULL,
143 `PlanType` VARCHAR(255) NULL,
144 `OrderID` VARCHAR(45) NULL,
145 `Comments` TEXT NULL,
146 PRIMARY KEY (`idContract`))
147ENGINE = InnoDB;
148
149
150-- -----------------------------------------------------
151-- Table `cps`.`integration_contract_item`
152-- -----------------------------------------------------
153CREATE TABLE IF NOT EXISTS `cps`.`integration_contract_item` (
154 `id` INT NOT NULL AUTO_INCREMENT,
155 `IdContratoItem` VARCHAR(45) NULL,
156 `OrderId` VARCHAR(45) NULL,
157 `OrderNumber` VARCHAR(45) NULL,
158 `SerialNumber` VARCHAR(255) NULL,
159 `SerialNumberStatus` VARCHAR(255) NULL,
160 `InstallationDate` DATETIME NULL,
161 `CreatedById` VARCHAR(255) NULL,
162 `CreatedDate` DATETIME NULL,
163 `DELSys21Date` DATETIME NULL,
164 `DelSys21By` VARCHAR(255) NULL,
165 `NumberVisitation` INT NULL,
166 `WarrantyDate` DATETIME NULL,
167 `WarrantyDays` INT NULL,
168 `ContratoId` VARCHAR(255) NULL,
169 `IntegrationStatus` VARCHAR(255) NULL,
170 `IntegrationMessage` TEXT NULL,
171 `IntegrationDate` DATETIME NULL,
172 PRIMARY KEY (`id`))
173ENGINE = InnoDB;
174
175
176-- -----------------------------------------------------
177-- Table `cps`.`integration_product`
178-- -----------------------------------------------------
179CREATE TABLE IF NOT EXISTS `cps`.`integration_product` (
180 `id` INT NOT NULL AUTO_INCREMENT,
181 `ProductId` VARCHAR(45) NULL,
182 `IsActive` TINYINT NULL,
183 `IsDeleted` TINYINT NULL,
184 `Name` VARCHAR(45) NULL,
185 `Stock_` INT NULL,
186 `StockAvalaible` INT NULL,
187 `StockMinimun` INT NULL,
188 `Block` TINYINT NULL,
189 `Blockby` VARCHAR(255) NULL,
190 `BlockMotive` VARCHAR(255) NULL,
191 `ProductType` VARCHAR(255) NULL,
192 `Model` VARCHAR(255) NULL,
193 `IntegrationStatus` VARCHAR(255) NULL,
194 `IntegrationMessage` TEXT NULL,
195 `IntegrationDate` DATETIME NULL,
196 PRIMARY KEY (`id`))
197ENGINE = InnoDB;
198
199
200-- -----------------------------------------------------
201-- Table `cps`.`integration_service`
202-- -----------------------------------------------------
203CREATE TABLE IF NOT EXISTS `cps`.`integration_service` (
204 `id` INT NOT NULL AUTO_INCREMENT,
205 `AccountID` VARCHAR(255) NULL,
206 `ContractNumber` VARCHAR(255) NULL,
207 `SerialNumber` VARCHAR(255) NULL,
208 `ProductCode` VARCHAR(255) NULL,
209 `Model` VARCHAR(255) NULL,
210 `FSRNumber` VARCHAR(255) NULL,
211 `Status` VARCHAR(255) NULL,
212 `AssignedDateTime` DATETIME NULL,
213 `ClosingDateTime` DATETIME NULL,
214 `IntegrationStatus` VARCHAR(255) NULL,
215 `IntegrationMessage` TEXT NULL,
216 `IntegrationDate` DATETIME NULL,
217 `Type` VARCHAR(255) NULL,
218 `Category` VARCHAR(255) NULL,
219 `Event` VARCHAR(255) NULL,
220 `Subject` VARCHAR(255) NULL,
221 `RNSys21Number` VARCHAR(255) NULL,
222 `RNSys21Value` DECIMAL(16,2) NULL,
223 `Franchise` TINYINT NULL,
224 `FranchiseValue` DECIMAL(16,2) NULL,
225 `FreightValue` DECIMAL(16,2) NULL,
226 `OrcamentoStatus` VARCHAR(45) NULL,
227 `CommentsApproval` TEXT NULL,
228 `CommentsTechnical` TEXT NULL,
229 `Observation` TEXT NULL,
230 PRIMARY KEY (`id`))
231ENGINE = InnoDB;
232
233
234SET SQL_MODE=@OLD_SQL_MODE;
235SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
236SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;