--- OLD TABLES --- Table: base_cliente - Id (double) - Código (double) - Id Cliente (double) - Cliente Nombre (varchar(255)) - Cliente Fecha Alta (varchar(255)) - Cliente Teléfono (varchar(255)) - Cliente Celular (varchar(255)) - Cliente Fax (varchar(255)) - Cliente Tel# Comercial (varchar(255)) - Cliente Email (varchar(255)) - Cliente Direccón (varchar(255)) - Cliente Comentarios (varchar(255)) Table: clientes - IdCliente (bigint unsigned) - clienteNombre (varchar(45)) - clienteApellido (varchar(45)) - clienteTelefono (varchar(45)) - clienteCelular (varchar(45)) - clienteEmail (varchar(45)) - clienteFax (varchar(45)) - clienteTelefonoComercial (varchar(45)) - clienteDireccion (varchar(200)) - clienteComentarios (varchar(500)) - clienteEstado (int) - clienteFechaModificacion (datetime) - clienteUsuModificacion (int) Table: log_clientes - IdCliente (bigint unsigned) - clienteNombre (varchar(45)) - clienteApellido (varchar(45)) - clienteTelefono (varchar(45)) - clienteCelular (varchar(45)) - clienteEmail (varchar(45)) - clienteFax (varchar(45)) - clienteTelefonoComercial (varchar(45)) - clienteDireccion (varchar(200)) - clienteComentarios (varchar(500)) - clienteEstado (int) - clienteFechaModificacion (datetime) - clienteUsuModificacion (int) --- NEW TABLES --- Table: contacto_preferencias - id (bigint unsigned) - atributo_id (bigint unsigned) - contacto_id (bigint unsigned) - valor (varchar(255)) - created_at (timestamp) - updated_at (timestamp) - deleted_at (timestamp) - created_by (bigint unsigned) - deleted_by (bigint unsigned) Table: contacto_propiedad - id (bigint unsigned) - contacto_id (bigint unsigned) - propiedad_id (bigint unsigned) - created_at (timestamp) - updated_at (timestamp) Table: contacto_tipo_contacto - id (bigint unsigned) - contacto_id (bigint unsigned) - tipo_contacto_id (bigint unsigned) - created_at (timestamp) - updated_at (timestamp) Table: contactos - id (bigint unsigned) - nombre (varchar(255)) - apellido (varchar(255)) - telefono (varchar(255)) - email (varchar(255)) - ml_user_id (varchar(255)) - estado_contacto_id (bigint unsigned) - usuario_responsable_id (bigint unsigned) - created_at (timestamp) - updated_at (timestamp) - deleted_at (timestamp) - created_by (bigint unsigned) - deleted_by (bigint unsigned) - observaciones (text) Table: estado_contactos - id (bigint unsigned) - descripcion (varchar(255)) - created_at (timestamp) - updated_at (timestamp) - deleted_at (timestamp) - created_by (bigint unsigned) - deleted_by (bigint unsigned) Table: tipo_contactos - id (bigint unsigned) - descripcion (varchar(255)) - created_at (timestamp) - updated_at (timestamp) - deleted_at (timestamp) - created_by (bigint unsigned) - deleted_by (bigint unsigned)