-- Script generated by MySQL Compare 1.0.1.4 on 28/02/2020 19:17:33

SET @ORIGINAL_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @ORIGINAL_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @ORIGINAL_SQL_MODE=@@SQL_MODE, SQL_MODE='ALLOW_INVALID_DATES,NO_AUTO_VALUE_ON_ZERO,NO_AUTO_CREATE_USER';

SET @ORIGINAL_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @ORIGINAL_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @ORIGINAL_SQL_MODE=@@SQL_MODE, SQL_MODE='ALLOW_INVALID_DATES,NO_AUTO_VALUE_ON_ZERO,NO_AUTO_CREATE_USER';

CREATE TABLE `ERP`.`cuenta_por_cobrar` (
  `cuenta_por_cobrar_id` bigint(20) NOT NULL auto_increment,
  `comentarios` longtext NOT NULL,
  `created_date` datetime NULL,
  `cuenta_contable_contra_id` bigint(20) NULL,
  `cuenta_contable_id` bigint(20) NULL,
  `departamento_id` bigint(20) NULL,
  `fecha_pago` datetime NULL,
  `fecha_pago_realizado` datetime NULL,
  `fecha_vencimiento` datetime NULL,
  `forma_pago_id` bigint(20) NOT NULL,
  `importe` decimal(19,2) NOT NULL,
  `modified_date` datetime NULL,
  `pendiente` decimal(19,2) NULL,
  `place_id` bigint(20) NULL,
  `referencia` varchar(255) NOT NULL,
  `status` varchar(255) NULL,
  `sucursal_id` bigint(20) NULL,
  `user_id` bigint(20) NULL,
  `uuid` varchar(255) NOT NULL,
  `status_cuenta_por_cobrar_id` bigint(20) NULL,
  `cliente_id` bigint(20) NOT NULL,
  `concepto` varchar(255) NOT NULL,
  PRIMARY KEY (`cuenta_por_cobrar_id`),
  FOREIGN KEY (`cuenta_contable_id`) REFERENCES `ERP`.`cuenta_contable` (`cuenta_contable_id`),
  FOREIGN KEY (`forma_pago_id`) REFERENCES `ERP`.`forma_pago` (`forma_pago_id`),
  FOREIGN KEY (`place_id`) REFERENCES `ERP`.`company` (`place_id`),
  FOREIGN KEY (`status_cuenta_por_cobrar_id`) REFERENCES `ERP`.`status_cuenta_por_cobrar` (`status_cuenta_por_cobrar_id`),
  FOREIGN KEY (`user_id`) REFERENCES `ERP`.`usuario` (`user_id`),
  FOREIGN KEY (`cliente_id`) REFERENCES `ERP`.`cliente` (`cliente_id`),
  KEY `FK1xowyfsrx5g6ldq0l3can55hh`(`cuenta_contable_id`),
  KEY `FKcn24q4mb4pu5x2fhdvm1rieqq`(`forma_pago_id`),
  KEY `FKfhgj9gcqps280avbffxohm9li`(`place_id`),
  KEY `FKj5f80uvuoalexyygscjcg2957`(`status_cuenta_por_cobrar_id`),
  KEY `FKmgg2qdsawj0pkol6x61pkqjli`(`user_id`),
  KEY `FKpq20md35onwx92t8ex4eif62q`(`cliente_id`)
) ENGINE=InnoDB;

SET FOREIGN_KEY_CHECKS=@ORIGINAL_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@ORIGINAL_UNIQUE_CHECKS;
SET SQL_MODE=@ORIGINAL_SQL_MODE;