cmnhlue26002p94a92j88hox9	cmnfbhk0b000r12lphsiahfyu	5213351938611@s.whatsapp.net	Flores Gallart Firma Inmobiliaria	Casa en Venta en Zona Centro de Aguascalientes\nhttps://www.easybroker.com/mx/listing/floresgallartf_1/casa-en-venta-en-zona-centro-de-aguascalientes?inviter=floresgallartf_1&source=invite-floresgallartf_1	text	OFFER	{"urgency": "normal", "location": "Zona Centro, Aguascalientes", "contactInfo": "floresgallartf_1 (EasyBroker)", "description": "Casa en venta en Zona Centro de Aguascalientes publicada en EasyBroker", "propertyType": "Casa", "operationType": "Sale"}	\N	\N	2026-04-02 15:05:44.018	2026-04-02 15:03:38.67
cmnhlueh9002r94a9ky468ase	cmnfbhk0b000r12lphsiahfyu	5213351938611@s.whatsapp.net	Flores Gallart Firma Inmobiliaria		text	OTHER	null	\N	\N	2026-04-02 15:05:44.023	2026-04-02 15:03:39.213
cmnhluew2002t94a9va70qlt0	cmnfbhk0b000r12lphsiahfyu	5213351938611@s.whatsapp.net	Flores Gallart Firma Inmobiliaria		text	OTHER	null	\N	\N	2026-04-02 15:05:44.025	2026-04-02 15:03:39.747
cmnhlvv9b002v94a9wzs1yo2w	cmngdnr8300cojquo6jv87m7j	5213351938611@s.whatsapp.net	Flores Gallart Firma Inmobiliaria	FLORES GALLART OFRECE:	text	OFFER	{"contactInfo": "Flores Gallart", "description": "Mensaje incompleto. Flores Gallart anuncia una oferta pero no se especificó el contenido de la propiedad."}	\N	\N	2026-04-02 15:05:59.558	2026-04-02 15:04:47.615
cmnhlvwds003194a9ok0vei2m	cmngdnr8300cojquo6jv87m7j	5213351938611@s.whatsapp.net	Flores Gallart Firma Inmobiliaria		text	OTHER	null	\N	\N	2026-04-02 15:06:20.465	2026-04-02 15:04:49.072
cmngphhgz0085r3879ulnfhey	cmnfbhk0b000r12lphsiahfyu	5214493628095@s.whatsapp.net	Ing. Martin Perez	🌞Buen día Colegas!! \n\n*OFREZCO LOCAL EN RENTA EN DISTRITO SUR PLANTA ALTA* \n$8,316.66 \n✅ 52.87 m2 \n✅ planta alta \n✅ precio más IVA y más mtto	text	OFFER	{"area": 52.87, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Distrito Sur", "maxPrice": 8316.66, "minPrice": 8316.66, "bathrooms": null, "contactInfo": null, "description": "Local en renta en Distrito Sur, planta alta, 52.87 m2. Precio $8,316.66 más IVA y mantenimiento.", "propertyType": "local", "operationType": "Rent"}	\N	\N	2026-04-02 00:04:33.065	2026-04-01 23:57:48.851
cmngpkx3u0087r3877p8kd1q7	cmnfbe18l000n12lpjy6143uf	5214495274717@s.whatsapp.net	Élite Mora Bienes raíces	Hola colegas *solicito* casa en *venta* de $2,000,000 zona centro o norte. Pago con infonavit y recurso propio. Agradecería sus opciones	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "zona centro o norte", "maxPrice": 2000000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Solicita casa en venta de hasta $2,000,000 en zona centro o norte. Pago mixto: crédito INFONAVIT + recurso propio.", "propertyType": "casa", "operationType": "Sale"}	matched	[{"id": "cmnf9agcq00xl5l47ogvdfs3s", "image": "/uploads/inmoapp/45784_1775000200787.jpg", "price": 2404500.0, "title": "JESUS MARIA VENTA CASA AL NORTE DE AGUASCALIENTES.", "reason": "Precio OK $2,404,500 dentro del rango $1,900,000-$2,600,000 | Zona OK norte (Jesús María, norte de AGS) | Tipo OK casa | Op OK venta | 3 rec / 3 baños / 90m²"}, {"id": "cmnf9ahnx00y75l4765l9ju45", "image": "/uploads/inmoapp/45770_1775000202494.jpg", "price": 2550000.0, "title": "LA TOMATINA VENTA CASA CON ALBERCA POR PICACHO AGS.", "reason": "Precio OK $2,550,000 dentro del rango $1,900,000-$2,600,000 | Zona OK centro (Aguascalientes Centro, por Picacho) | Tipo OK casa | Op OK venta | 3 rec / 2 baños / 600m² con alberca"}]	2026-04-02 00:05:19.987	2026-04-02 00:00:29.082
cmngpl2o90089r387ov7a51x5	cmn0uw4rh00257fn2mnwq68ca	5214495274717@s.whatsapp.net	Élite Mora Bienes raíces	Hola colegas *solicito* casa en *venta* de $2,000,000 zona centro o norte. Pago con infonavit y recurso propio. Agradecería sus opciones	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "zona centro o norte", "maxPrice": 2000000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca casa en venta de $2,000,000 en zona centro o norte. Pago con INFONAVIT y recurso propio.", "propertyType": "Casa", "operationType": "Sale"}	matched	[{"id": "cmmuvrihi03zfxjdt9ya8zvvr", "image": "/uploads/inmoapp/38863_1773768158558.jpg", "price": 1990000.0, "title": "ESTRENA CASA AMPLIA EN RESIDENCIAL AL NORTE DE AGUASCALIENTES", "reason": "Precio OK $1,990,000 dentro de presupuesto $2,000,000 | Zona OK norte (Jesús María, al norte de AGS) | Tipo OK casa | Op OK venta"}]	2026-04-02 00:06:15.236	2026-04-02 00:00:36.297
cmngpzuek008hr387mesmunf6	cmn0uw4rh00257fn2mnwq68ca	5214491375171@s.whatsapp.net	T M Adviser Claudia Tiscareño	*SOLICITO*\nRoof, terraza o casa en renta para poner negocio en la terraza y	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": null, "location": null, "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Solicita roof garden, terraza o casa en renta con terraza para instalar un negocio. Mensaje aparentemente incompleto (termina en 'y').", "propertyType": "roof/terraza/casa", "operationType": "Rent"}	no_match	\N	2026-04-02 00:15:16.81	2026-04-02 00:12:05.42
cmngq4kkz008tr3876xcbg9t7	cmn0uw4rh00257fn2mnwq68ca	5214492634793@s.whatsapp.net	Estrella	🏘️ *Solicito CASA EN RENTA*\n* Al poniente, centro, colinas...\n* Presupuesto $7'000\n* Póliza juridica \n* 2 personas \n* Acepten perrita pequeña ya viejita \n* Gracias por sus opciones🙏	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "poniente, centro, colinas", "maxPrice": 7000, "minPrice": 7000, "bathrooms": null, "contactInfo": null, "description": "Buscan casa en renta para 2 personas con perrita pequeña. Requieren póliza jurídica. Zona: poniente, centro o colinas.", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-02 00:20:17.727	2026-04-02 00:15:45.971
cmnkdzakm00bdjk96eh605zz9	cmngdnrak00cqjquoukdkgrov	5214491112665@s.whatsapp.net	Charly Hernández	Buen día, BUSCO LOCAL en renta en Jesús Maria, con mucho flujo peatonal.	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": null, "location": "Jesús María", "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca local en renta en Jesús María con mucho flujo peatonal", "propertyType": "Local comercial", "operationType": "Rent"}	no_match	\N	2026-04-04 13:50:13.125	2026-04-04 13:46:49.03
cmngq5vlf008vr38790z59oan	cmngdnrd100csjquoo37sjyma	5214492634793@s.whatsapp.net	Estrella	🏘️ *Solicito CASA EN RENTA*\n* Al poniente, centro, colinas...\n* Presupuesto $7'000\n* Póliza juridica \n* 2 personas \n* Acepten perrita pequeña ya viejita \n* Gracias por sus opciones🙏	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "poniente, centro, colinas", "maxPrice": 7000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca casa en renta para 2 personas. Acepta póliza jurídica. Requiere que acepten mascota (perrita pequeña). Zona poniente, centro o colinas.", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-02 00:20:51.846	2026-04-02 00:16:46.9
cmnhlvw0o002z94a9cqncjgjk	cmngdnr8300cojquo6jv87m7j	5213351938611@s.whatsapp.net	Flores Gallart Firma Inmobiliaria	Casa en Venta en Zona Centro de Aguascalientes\nhttps://www.easybroker.com/mx/listing/floresgallartf_1/casa-en-venta-en-zona-centro-de-aguascalientes?inviter=floresgallartf_1&source=invite-floresgallartf_1	text	OFFER	{"urgency": "normal", "location": "Zona Centro, Aguascalientes", "contactInfo": "floresgallartf_1 (EasyBroker)", "description": "Casa en venta en Zona Centro de Aguascalientes publicada en EasyBroker", "propertyType": "Casa", "operationType": "Sale"}	\N	\N	2026-04-02 15:06:20.462	2026-04-02 15:04:48.601
cmnhm0frc003794a95rghn924	cmn0uw4rh00257fn2mnwq68ca	5214492131658@s.whatsapp.net	Consorcio Inmobiliario Bo	Busco casa en venta para inversionista pago de contado $2,500,000.00 puede ser algo más \nVersalles Í  / El Dorado.	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Versalles / El Dorado", "maxPrice": 2500000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca casa en venta para inversionista, pago de contado. Presupuesto de $2,500,000 con cierta flexibilidad al alza. Zonas de interés: Versalles o El Dorado.", "propertyType": "Casa", "operationType": "Sale"}	no_match	\N	2026-04-02 15:11:18.823	2026-04-02 15:08:20.809
cmnhnzrsc00054jywwlj7rri9	cmnfbhk0b000r12lphsiahfyu	5214492782782@s.whatsapp.net	CFG Inversiones Inmobiliarias	Solicito casa pequeña , departamento o habitación económico para una persona al norte por favor	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": null, "location": "norte", "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca casa pequeña, departamento o habitación económica para una sola persona, en zona norte", "propertyType": "casa, departamento, habitación", "operationType": "Rent"}	no_match	\N	2026-04-02 16:06:53.922	2026-04-02 16:03:48.972
cmnhvxa640007jk96nqamd18k	cmn0uw4rh00257fn2mnwq68ca	5214491193535@s.whatsapp.net	Liz		image	OTHER	null	\N	\N	2026-04-02 19:50:00.648	2026-04-02 19:45:49.756
cmnhonpzg000r4jywz0nlhnji	cmn0uw4rh00257fn2mnwq68ca	5214491028383@s.whatsapp.net	DL	** SE ACEPTA CASA A CUENTA **\n\nCASA EN VENTA 🍃\n\n📍Entre edén los sabinos y San Joaquín (privada independiente) \nVERGEL LOS CIPRESES\n\nSuperficie : 1777.45m2\n\n**•CASA  225 m2**\n•3 habitaciones con clóset y lámpara ventilador \n•2.5 baños \n\n**JARDIN**\n•1500 m2 de jardín \nBaños de jardín \nFogatero\nPalmas\nÁrboles frutales \nIluminación \nAspersores de riego\nTERRAZA CON AZADOR\n\netc…\n\nDe $5’850’000\n\n  a \n\n**5’490,000**\nPrecio nuevo	text	OFFER	{"area": 225, "extras": {"gardenArea": 1500, "totalLandArea": 1777.45, "acceptsPropertyInExchange": true}, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "Vergel Los Cipreses, entre Edén Los Sabinos y San Joaquín (privada independiente)", "maxPrice": 5490000, "minPrice": 5490000, "bathrooms": 2.5, "contactInfo": null, "description": "Casa en venta en privada independiente. Superficie total 1777.45m2, construcción 225m2. 3 habitaciones con clóset y lámpara ventilador, 2.5 baños. Jardín de 1500m2 con baños, fogatero, palmas, árboles frutales, iluminación, aspersores y terraza con asador. Se acepta casa a cuenta. Precio reducido de $5,850,000 a $5,490,000.", "propertyType": "Casa", "operationType": "Sale"}	\N	\N	2026-04-02 16:48:33.379	2026-04-02 16:22:26.381
cmnhpcabq00154jywzq7nob4e	cmngdnrd100csjquoo37sjyma	5214494610457@s.whatsapp.net	Ventas Inverhouse	Buen dia, InverHouse solicita casa en renta al poniente de la ciudad, presupuesto $9,000 no import	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "poniente de la ciudad", "maxPrice": 9000, "bathrooms": null, "contactInfo": "InverHouse", "description": "InverHouse solicita casa en renta al poniente de la ciudad con presupuesto de $9,000", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-02 16:48:45.624	2026-04-02 16:41:32.486
cmnj3rw6t006ljk96xtvhjc5v	cmnfbjs0q000t12lp6mpl8ngn	5214498040939@s.whatsapp.net	KATYA AGUILAR	*OFREZCO EN RENTA AMUEBLADO*\n\n🏠CASA EN MANGATA RESIDENCIAL \n3 habitaciones con clóset y ventiladores de techo.\n2.5 baños \n$16.000 incluye mantenimiento \nDisponible a partir del 15 de abril \n* No mascotas \n* ⁠póliza jurídica \n* ⁠1 año mínimo de contrato\n\n🏠CASA EN YALTA CAMPESTRE  de dos habitaciones.\nLa principal en planta alta con jacuzzi \n3 baños \nAmplia Terraza\n$18,900 bajo de precio  \n \n\n🏠Casa de 3 habitaciones en RINCON ANDALUZ\n$25,000 renta mensual incluyendo agua, internet y mantenimiento.\n\n🏠Casa en PRIVADA CALICANTOS de 3 habitaciones cada una con vestidor y baño.\nJardín con terraza\nAsador \nCuarto de juegos con mesa de poker.\n$47,500 renta mensual incluye internet y SKY.	text	OFFER	{"urgency": "normal", "currency": "MXN", "listings": [{"notes": "Incluye mantenimiento. Disponible 15 de abril. No mascotas. Póliza jurídica. Contrato mínimo 1 año.", "price": 16000, "bedrooms": 3, "location": "Mangata Residencial", "bathrooms": 2.5}, {"notes": "Habitación principal en planta alta con jacuzzi. Amplia terraza.", "price": 18900, "bedrooms": 2, "location": "Yalta Campestre", "bathrooms": 3}, {"notes": "Incluye agua, internet y mantenimiento.", "price": 25000, "bedrooms": 3, "location": "Rincón Andaluz", "bathrooms": null}, {"notes": "Cada habitación con vestidor y baño. Jardín con terraza, asador, cuarto de juegos con mesa de poker. Incluye internet y SKY.", "price": 47500, "bedrooms": 3, "location": "Privada Calicantos", "bathrooms": 3}], "maxPrice": 47500, "minPrice": 16000, "furnished": true, "contactInfo": null, "description": "Oferta de 4 casas amuebladas en renta en distintos fraccionamientos/residenciales. Precios desde $16,000 hasta $47,500 MXN mensuales.", "propertyType": "Casa", "operationType": "Rent"}	\N	\N	2026-04-03 16:16:26.732	2026-04-03 16:13:21.461
cmnja9rd60077jk96fb59i1cn	cmnfbjs0q000t12lp6mpl8ngn	5214499603816@s.whatsapp.net	Cecilia Lopez	Solicito Casa en venta alrededor de $1,100,000 con credito infonavit y si se spuede que sea de OPORTUNIDAD	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": null, "maxPrice": 1100000, "minPrice": null, "bathrooms": null, "financing": "INFONAVIT", "contactInfo": null, "description": "Solicita casa en venta alrededor de $1,100,000 con crédito INFONAVIT, preferiblemente de oportunidad (precio bajo o negociable).", "propertyType": "Casa", "operationType": "Sale"}	matched	[{"id": "cmnf9c5g501th5l470lcl7uh6", "image": "/uploads/inmoapp/45776_1775000279966.jpg", "price": 1260000.0, "title": "CALLE MICHOACAN OFERTA CASA EN VENTA FRACCIONAMIENTO MEXICO EN AGS", "reason": "Precio $1,260,000 dentro del rango permitido (14.5% sobre presupuesto $1.1M, máx permitido 130% = $1,430,000) | Sin restricción de zona | Tipo OK casa | Op OK venta | Título incluye 'OFERTA' alineado con búsqueda de oportunidad/precio negociable"}, {"id": "cmnf98nrk00055l47hmtl3ier", "image": "/uploads/inmoapp/45935_1775000117089.jpg", "price": 1380000.0, "title": "CASA EN VENTA CASA DE PINTORES", "reason": "Precio $1,380,000 dentro del rango permitido (25.5% sobre presupuesto $1.1M, dentro del máx 130% = $1,430,000) | Sin restricción de zona | Tipo OK casa | Op OK venta | Menor confidence por mayor distancia al presupuesto declarado"}]	2026-04-03 19:20:15.94	2026-04-03 19:15:12.714
cmnja9rnw0079jk96vwx1kxdw	cmn0uw4rh00257fn2mnwq68ca	5214499603816@s.whatsapp.net	Cecilia Lopez	Solicito Casa en venta alrededor de $1,100,000 con credito infonavit y si se spuede que sea de OPORTUNIDAD	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": null, "maxPrice": 1100000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca casa en venta alrededor de $1,100,000 con crédito INFONAVIT, preferentemente propiedad de oportunidad (precio bajo o urgente)", "propertyType": "Casa", "operationType": "Sale"}	no_match	\N	2026-04-03 19:21:29.623	2026-04-03 19:15:13.1
cmnkeiqdg00bhjk96ktchq2jq	cmngdnrfl00cujquogrv21fxg	5214494159086@s.whatsapp.net	Angelica	Buen día. ☀️ \nNecesito CASA EN RENTA S/M, zona San Telmo, Arroyo del Molino. Campanario,  Res. La Paloma… ppto tope, $22,000. \nInf. A mi wapp. 📲	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "San Telmo, Arroyo del Molino, Campanario, Res. La Paloma", "maxPrice": 22000, "minPrice": null, "bathrooms": null, "furnished": false, "contactInfo": "Contacto por WhatsApp (no especificado)", "description": "Busca casa en renta sin muebles (S/M) en zonas San Telmo, Arroyo del Molino, Campanario o Residencial La Paloma. Presupuesto tope $22,000 MXN mensuales. Solicita contacto por WhatsApp.", "propertyType": "Casa", "operationType": "Rent"}	no_match	\N	2026-04-04 14:06:00.654	2026-04-04 14:01:55.972
cmnhpozt600174jyw5ke75czr	cmngdnrd100csjquoo37sjyma	5214494973900@s.whatsapp.net	Sebastian Martinez Ayala	Solicito departamento en renta amueblado en capitala \nSolo por 6 meses\nPierde deposito\nPara jugador de rieleros \nPpto 13 a 15 mil	text	DEMAND	{"area": null, "urgency": "alta", "bedrooms": null, "currency": "MXN", "duration": "6 meses", "location": "Capitala (posiblemente Aguascalientes, dado referencia a Rieleros)", "maxPrice": 15000, "minPrice": 13000, "bathrooms": null, "furnished": true, "contactInfo": null, "description": "Buscan departamento amueblado en renta por 6 meses solamente, para jugador de Rieleros de Aguascalientes. Acepta perder el depósito por la corta duración. Presupuesto de 13,000 a 15,000 MXN mensuales.", "propertyType": "departamento", "operationType": "Rent"}	no_match	\N	2026-04-02 16:55:18.393	2026-04-02 16:51:25.387
cmnhqnwzi001b4jyw9kc76hdn	cmngdnrd100csjquoo37sjyma	5214491239280@s.whatsapp.net	Charly Santi 😜	Solicito casa en renta, *sin amueblar* , *3 recamaras,* *en las siguientes zonas poniente y norponiente,*  *que acepten dos mascotas un criollo mediano y un bulldog inglés,* cliente cuenta con *aval en Ags* , presupuesto máximo *$ 15,000* agradezco opciones en privado	text	DEMAND	{"area": null, "extras": ["sin amueblar", "acepta mascotas", "aval en Ags"], "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "zona poniente y norponiente, Aguascalientes", "maxPrice": 15000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca casa en renta sin amueblar, 3 recámaras, en zonas poniente y norponiente. Acepta mascotas (criollo mediano y bulldog inglés). Cliente cuenta con aval en Aguascalientes. Presupuesto máximo $15,000 MXN.", "propertyType": "casa", "operationType": "Rent"}	matched	[{"id": "cmmuvpzel02srxjdtw8pftaak", "image": "/uploads/inmoapp/43688_1773768087178.jpg", "price": 14500.0, "title": "CASA EN RENTA EN CONDOMINIO PRIVADO AL PONIENTE DE AGUASCALIENTES", "reason": "Precio OK $14,500 dentro de rango $14,250-$19,500 | Zona OK Poniente | Tipo OK Casa | Op OK Renta | Recámaras OK 3 | Sin mención de amueblada en título (posiblemente sin amueblar)"}]	2026-04-02 17:20:29.512	2026-04-02 17:18:34.686
cmnhrik3t001h4jywsgnb783f	cmn0uw4rh00257fn2mnwq68ca	5214492432333@s.whatsapp.net	Century 21 Investra	Buenos días!! \nSolicito casa en venta. \nPresupuesto máximo $4.2mdp\nDe preferencia nueva, 4 recámaras. Espacio para terraza. En coto. \nCrédito autorizado. \nOpciones en privado, gracias!!	text	DEMAND	{"urgency": "normal", "bedrooms": 4, "currency": "MXN", "features": ["nueva", "terraza", "coto", "crédito autorizado"], "maxPrice": 4200000, "description": "Busca casa en venta, nueva, 4 recámaras, con espacio para terraza, en coto (privada). Crédito hipotecario ya autorizado. Presupuesto máximo $4.2 MDP.", "propertyType": "casa", "operationType": "Sale"}	matched	[{"id": "cmmuvoxkt01etxjdtgt7t3wmi", "image": "/uploads/inmoapp/29980_1773768038154.jpg", "price": 4700000.0, "title": "CASA NUEVA EN VENTA EN CONDOMINIO LAS PLAZAS AL NORTE DE AGUASCALIENTES", "reason": "Precio OK $4,700,000 (112% del presupuesto, dentro del rango permitido 95-130%) | Tipo OK casa NUEVA explícito en título | Rec OK 4 recámaras | Coto OK condominio cerrado Las Plazas | Op OK venta | Zona norte Ags (sin restricción de zona indicada por cliente) | Terraza no confirmada en datos pero todos los requisitos principales cubiertos"}]	2026-04-02 17:45:16.982	2026-04-02 17:42:24.329
cmnj3q7av006hjk96pc0ts8r4	cmngdnrd100csjquoo37sjyma	5214497569237@s.whatsapp.net	LD Bienes Raíces	Busco casa en renta, de preferencia amueblada y que se pueda usar solo por un mes! \n\nPpto máximo 9000	text	DEMAND	{"area": null, "urgency": "alta", "bedrooms": null, "currency": "MXN", "location": null, "maxPrice": 9000, "bathrooms": null, "furnished": true, "contactInfo": null, "description": "Busca casa en renta, amueblada, uso temporal de solo un mes, presupuesto máximo $9,000", "propertyType": "casa", "operationType": "Rent", "rentalDuration": "1 mes"}	no_match	\N	2026-04-03 16:15:14.605	2026-04-03 16:12:02.551
cmnhrp4em001n4jywanf7gxj3	cmngdnrd100csjquoo37sjyma	5214495123331@s.whatsapp.net	Mariely Mp	Busco departamento o casa con muebles en el norte o centro. Solo para 1 persona $10/15 mil	text	DEMAND	{"area": null, "extras": ["amueblado"], "urgency": "normal", "bedrooms": 1, "currency": "MXN", "location": "norte o centro", "maxPrice": 15000, "minPrice": 10000, "bathrooms": null, "contactInfo": null, "description": "Busca departamento o casa amueblada en zona norte o centro, para una sola persona, presupuesto de $10,000 a $15,000 MXN mensuales", "propertyType": "departamento o casa", "operationType": "Rent"}	no_match	\N	2026-04-02 17:50:18.823	2026-04-02 17:47:30.574
cmnhrqkf5001p4jywh4wv73uz	cmn0uw4rh00257fn2mnwq68ca	5214491375171@s.whatsapp.net	T M Adviser Claudia Tiscareño	Hola, te envío una opción	text	OTHER	{}	\N	\N	2026-04-02 17:52:35.687	2026-04-02 17:48:37.985
cmnhrrfqc001r4jywjulf1tm8	cmngdnrd100csjquoo37sjyma	5214492014158@s.whatsapp.net	Rogelio Sada	Busco depa de 2 recamaras , cerca de la UAA, que acepte mascotas. Presupuesto max 11 Mil. Agradezco sus opciones.	text	DEMAND	{"area": null, "extras": ["acepta mascotas"], "urgency": "normal", "bedrooms": 2, "currency": "MXN", "location": "cerca de la UAA (Universidad Autónoma de Aguascalientes)", "maxPrice": 11000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca departamento de 2 recámaras cerca de la UAA, que acepte mascotas, presupuesto máximo $11,000 MXN.", "propertyType": "departamento", "operationType": "Rent"}	no_match	\N	2026-04-02 17:52:50.95	2026-04-02 17:49:18.565
cmnjarip8007hjk96h7ffx28n	cmn0uw4rh00257fn2mnwq68ca	5214498958939@s.whatsapp.net	lmeduardolarios	🔍 Solicito casa en Renta de 3 Recámaras, que acepten mascota pequeña... \nZona Canteras o cercana\nPpto $8,500	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "Zona Canteras o cercana", "maxPrice": 8500, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca casa en renta de 3 recámaras que acepte mascota pequeña en zona Canteras o alrededores, presupuesto de $8,500", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-03 19:30:15.35	2026-04-03 19:29:01.292
cmnjarvuh007jjk96qmegge16	cmngdnrd100csjquoo37sjyma	5214498958939@s.whatsapp.net	lmeduardolarios	🔍 Solicito casa en Renta de 3 Recámaras, que acepten mascota pequeña... \nZona Canteras o cercana\nPpto $8,500	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "Zona Canteras o cercana", "maxPrice": 8500, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Buscan casa en renta de 3 recámaras que acepte mascota pequeña, en Zona Canteras o zona cercana, presupuesto de $8,500", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-03 19:30:57.257	2026-04-03 19:29:18.329
cmnjfel2t009djk96s5p2zqmb	cmn0uw4rh00257fn2mnwq68ca	5214498963767@s.whatsapp.net	R&R BIENES Y RAICES	👁️ OFREZCO CASA EN VENTA DE OPORTUNIDAD EN RESIDENCIAL EL EDEN LOS  SABINOS 🏡  $8,500.000 UN MILLON ABAJO DE SU PRECIO DE AVALUO . SE TOMA CASA A CUENTA . INFORMES DIRECTO A MI CEL .	text	OFFER	{"urgency": "normal", "currency": "MXN", "location": "Residencial El Edén Los Sabinos", "maxPrice": 8500000, "contactInfo": "Contacto directo por celular (número no especificado en el mensaje)", "description": "Casa en venta de oportunidad, un millón abajo de su precio de avalúo. Se acepta casa a cuenta como parte de pago.", "propertyType": "Casa", "operationType": "Sale"}	\N	\N	2026-04-03 21:40:19.003	2026-04-03 21:38:55.925
cmnhstbye001t4jyw32zaoewn	cmn0uw4rh00257fn2mnwq68ca	5218112556957@s.whatsapp.net	Vince	*Busco casa en Venta en Residencial Punta del Cielo, coto Punta Coral modelo “Acoral”exclusivamente*	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": null, "location": "Residencial Punta del Cielo, coto Punta Coral", "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca casa en venta en Residencial Punta del Cielo, coto Punta Coral, modelo Acoral exclusivamente", "propertyType": "Casa", "operationType": "Sale"}	no_match	\N	2026-04-02 18:20:15.511	2026-04-02 18:18:46.599
cmnhsug2i001v4jyw2kiz47dp	cmngdnrd100csjquoo37sjyma	5214491239280@s.whatsapp.net	Charly Santi 😜	Solicito casa en renta, *sin amueblar,* *con recamara y baño completo en planta baja* *puede ser al sur, sur poniente, poniente y norte* *2 personas* *que acepten 2 perritos pequeños* , presupuesto del cliente es de *$ 12,000* cliente cuenta con *aval en ags* , agradezco sus opciones en privado	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": 1, "currency": "MXN", "location": "sur, sur poniente, poniente, norte (Aguascalientes)", "maxPrice": 12000, "minPrice": null, "bathrooms": 1, "contactInfo": "responder en privado", "description": "Casa en renta sin amueblar, con recámara y baño completo en planta baja. Para 2 personas con 2 perros pequeños. Cliente cuenta con aval en Aguascalientes.", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-02 18:20:37.815	2026-04-02 18:19:38.586
cmnhsvu2f001x4jyw84d6urta	cmn0uw4rh00257fn2mnwq68ca	5214491375171@s.whatsapp.net	T M Adviser Claudia Tiscareño	*OFREZCO* \nEn VENTA o RENTA \nBodega comercial/industrial NUEVA \nNororiente de Ags.\nRenta: $50,000\nVenta: $7,960,000\nPlanes de financiamiento directo \n-Terreno 690m2 \n-Construcción 576m2\nCeldas fotovoltaicas, estacionamiento techado.	text	OFFER	{"area": 576, "urgency": "normal", "currency": "MXN", "location": "Nororiente de Aguascalientes", "maxPrice": 7960000, "minPrice": 50000, "contactInfo": null, "description": "Bodega comercial/industrial nueva en nororiente de Ags. Terreno 690m2, construcción 576m2. Celdas fotovoltaicas, estacionamiento techado. Planes de financiamiento directo. Renta $50,000 MXN/mes, Venta $7,960,000 MXN.", "propertyType": "Bodega", "operationType": "Both"}	\N	\N	2026-04-02 18:25:11.561	2026-04-02 18:20:43.384
cmnhsz4p3001z4jywtf10vjz7	cmngdnrak00cqjquoukdkgrov	5214494484157@s.whatsapp.net	Marcelita Guardado	*`Buen día. Marce guardado de Zaterra By Alcasia Grupo inmobiliario`🏡 Ofrezco BODEGAS en renta en ex viñedos san marcos*\n*_• $12,000_incluye mantenimiento*\n*_• 50mts2 más mezzanine 25mts dos oficinas*_\n*_• $10,000_incluye mantenimiento*\n*_• 50mts2*_\nLas dos en calle principal	text	OFFER	{"area": "50", "units": [{"area": "50m2 + mezzanine 25m2", "price": 12000, "extras": "dos oficinas, incluye mantenimiento", "currency": "MXN"}, {"area": "50m2", "price": 10000, "extras": "incluye mantenimiento", "currency": "MXN"}], "urgency": "normal", "location": "Ex Viñedos San Marcos", "contactInfo": "Marce - Zaterra By Alcasia Grupo Inmobiliario", "description": "Dos bodegas en renta en calle principal. Opción 1: $12,000/mes, 50m2 + mezzanine 25m2 + dos oficinas, incluye mantenimiento. Opción 2: $10,000/mes, 50m2, incluye mantenimiento.", "propertyType": "bodega", "operationType": "Rent"}	\N	\N	2026-04-02 18:25:23.115	2026-04-02 18:23:17.127
cmnht232q00214jywp5ib7vig	cmn0uw4rh00257fn2mnwq68ca	5214491482109@s.whatsapp.net	Mónica Dávalos	Buenas tardes\n\nOfrezco\n\n🏢Local en renta  en \nPlanta baja en Av  López Mateos cerca del centro. \n\nNo uso de comida. \n\n100 metros\n\n$20,000	text	OFFER	{"area": 100, "urgency": "normal", "currency": "MXN", "location": "Av. López Mateos, cerca del centro, planta baja", "maxPrice": 20000, "minPrice": 20000, "contactInfo": null, "description": "Local en renta en planta baja sobre Av. López Mateos cerca del centro. No permite giro de alimentos. 100 metros cuadrados a $20,000 mensuales.", "propertyType": "local", "operationType": "Rent"}	\N	\N	2026-04-02 18:30:15.152	2026-04-02 18:25:34.994
cmnht240q00254jywrswtx44t	cmn0uw4rh00257fn2mnwq68ca	5214491482109@s.whatsapp.net	Mónica Dávalos		image	OTHER	null	\N	\N	2026-04-02 18:30:15.159	2026-04-02 18:25:36.218
cmnht24dz00274jywrawr7rvf	cmn0uw4rh00257fn2mnwq68ca	5214491482109@s.whatsapp.net	Mónica Dávalos		image	OTHER	null	\N	\N	2026-04-02 18:30:15.161	2026-04-02 18:25:36.696
cmnht24w800294jywuz3p4rmv	cmn0uw4rh00257fn2mnwq68ca	5214491482109@s.whatsapp.net	Mónica Dávalos		image	OTHER	null	\N	\N	2026-04-02 18:30:15.167	2026-04-02 18:25:37.352
cmnht25ay002b4jyw3ffgk3ys	cmn0uw4rh00257fn2mnwq68ca	5214491482109@s.whatsapp.net	Mónica Dávalos		image	OTHER	null	\N	\N	2026-04-02 18:30:15.169	2026-04-02 18:25:37.882
cmnht3son002d4jywwxy6g32l	cmnfbjs0q000t12lp6mpl8ngn	5214491375171@s.whatsapp.net	T M Adviser Claudia Tiscareño	*OFREZCO* \nEn VENTA o RENTA \nBodega comercial/industrial NUEVA \nNororiente de Ags.\nRenta: $50,000\nVenta: $7,960,000\nPlanes de financiamiento directo \n-Terreno 690m2 \n-Construcción 576m2\nCeldas fotovoltaicas, estacionamiento techado.	text	OFFER	{"area": 576, "urgency": "normal", "currency": "MXN", "location": "Nororiente de Aguascalientes", "maxPrice": 7960000, "minPrice": 50000, "contactInfo": null, "description": "Bodega comercial/industrial nueva en nororiente de Ags. Terreno 690m2, construcción 576m2. Celdas fotovoltaicas, estacionamiento techado. Planes de financiamiento directo. Renta $50,000/mes, venta $7,960,000.", "propertyType": "bodega", "operationType": "Both"}	\N	\N	2026-04-02 18:30:24.455	2026-04-02 18:26:54.839
cmnhw98sy000djk96plz5bjt5	cmn0uw4rh00257fn2mnwq68ca	5214495202655@s.whatsapp.net	Alfa&omega	‼️OFREZCO CASA DE 5 HABITACIONES EN RENTA CON OPCIÓN A VENTA EN RESIDENCIAL ALTARIA :$75,000‼️	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": 5, "currency": "MXN", "location": "Residencial Altaria", "maxPrice": 75000, "minPrice": 75000, "bathrooms": null, "contactInfo": null, "description": "Casa en renta con opción a venta en Residencial Altaria. 5 habitaciones. Precio $75,000 (renta mensual probable).", "propertyType": "Casa", "operationType": "Both"}	\N	\N	2026-04-02 20:05:17.794	2026-04-02 19:55:07.858
cmnjikonv009njk9671f7q6uu	cmn0uw4rh00257fn2mnwq68ca	5214491578639@s.whatsapp.net	Alfred Mac		image	OTHER	null	\N	\N	2026-04-03 23:10:00.269	2026-04-03 23:07:39.355
cmnht8qmi002h4jywgy9ng4hr	cmngdnrfl00cujquogrv21fxg	5214491375171@s.whatsapp.net	T M Adviser Claudia Tiscareño	*OFREZCO* \nEn VENTA o RENTA \nBodega comercial/industrial NUEVA \nNororiente de Ags.\nRenta: $50,000\nVenta: $7,960,000\nPlanes de financiamiento directo \n-Terreno 690m2 \n-Construcción 576m2\nCeldas fotovoltaicas, estacionamiento techado.	text	OFFER	{"area": 576, "urgency": "normal", "currency": "MXN", "location": "Nororiente de Aguascalientes", "maxPrice": 7960000, "minPrice": 50000, "contactInfo": null, "description": "Bodega comercial/industrial nueva en nororiente de Ags. Terreno 690m2, construcción 576m2. Celdas fotovoltaicas, estacionamiento techado. Planes de financiamiento directo. Renta: $50,000 MXN/mes, Venta: $7,960,000 MXN.", "propertyType": "bodega", "operationType": "Both"}	\N	\N	2026-04-02 18:35:15.476	2026-04-02 18:30:45.45
cmnht9r85002j4jywptnyhrup	cmngdnr8300cojquo6jv87m7j	5214492782782@s.whatsapp.net	CFG Inversiones Inmobiliarias	Solicito casa en venta al norte por la clínica 3 de preferencia nueva presupuesto 2'500	text	DEMAND	{"urgency": "normal", "currency": "MXN", "location": "norte, zona clínica 3", "maxPrice": 2500000, "contactInfo": null, "description": "Solicita casa en venta al norte de la ciudad, cerca de clínica 3, de preferencia nueva, con presupuesto de 2.5 millones de pesos", "propertyType": "casa", "operationType": "Sale"}	no_match	\N	2026-04-02 18:35:28.247	2026-04-02 18:31:32.885
cmnhtb43e002l4jywup6pv81h	cmnfbjs0q000t12lp6mpl8ngn	5214492782782@s.whatsapp.net	CFG Inversiones Inmobiliarias	Solicito casa en venta al norte por la clínica 3 de preferencia nueva presupuesto 2'500	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "norte, clínica 3", "maxPrice": 2500000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca casa en venta al norte, cerca de clínica 3, de preferencia nueva, con presupuesto de 2,500,000 MXN", "propertyType": "casa", "operationType": "Sale"}	matched	[{"id": "cmnf9agcq00xl5l47ogvdfs3s", "image": "/uploads/inmoapp/45784_1775000200787.jpg", "price": 2404500.0, "title": "JESUS MARIA VENTA CASA AL NORTE DE AGUASCALIENTES.", "reason": "Precio OK $2,404,500 dentro del presupuesto $2,500,000 | Zona OK norte de Aguascalientes (Jesús María) | Tipo OK casa | Op OK venta"}]	2026-04-02 18:35:56.923	2026-04-02 18:32:36.219
cmnhtbdq5002n4jywldvbbczd	cmn0uw4rh00257fn2mnwq68ca	5214492782782@s.whatsapp.net	CFG Inversiones Inmobiliarias	Solicito casa en venta al norte por la clínica 3 de preferencia nueva presupuesto 2'500	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Norte, por la clínica 3", "maxPrice": 2500000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Solicita casa en venta al norte cerca de la clínica 3, de preferencia nueva, con presupuesto de 2.5 millones", "propertyType": "Casa", "operationType": "Sale"}	no_match	\N	2026-04-02 18:37:05.034	2026-04-02 18:32:48.701
cmnjiq76h009pjk96r8agprmn	cmn0uw4rh00257fn2mnwq68ca	5214495857571@s.whatsapp.net	Jorge Kablum Inm		text	OTHER	null	\N	\N	2026-04-03 23:15:00.747	2026-04-03 23:11:56.633
cmnhti0vr002t4jywkklv4qfa	cmngdnrd100csjquoo37sjyma	5214492014158@s.whatsapp.net	Rogelio Sada	🏡 ¡Ofrezco Casa en renta en Valle de Santa Teresa, Aguascalientes!  A dos cuadras de Colosio\n\n💰 $35,000 MXN mensuales  \n🤝 Comisión compartida: \n\n✨ Excelente opción para vivir con comodidad, amplitud y estilo en una de las mejores zonas de la ciudad.  \n\n🔹 Características:  \n• 3 amplias recámaras  \n• 3 baños completos + 1 medio baño  \n• Sala y comedor con diseño contemporáneo  \n• Cocina integral  \n• Área social con palapa y asador (ideal para convivencias)  \n• Cochera para 2 autos con portón moderno  \n• Paneles solares ☀️ (ahorro en energía)  \n• Sistema hidroneumático  \n\n📐 240 m² de construcción  \n📐 380 m² de terreno (12 m de frente x 20 m de fondo)  \n🏡 Casa de 2 niveles, en excelente estado y orientación sur  \n\n📩 Si tienes cliente o te interesa agendar visita, mándame mensaje. ¡Compartimos comisión! https://www.easybroker.com/mx/listing/fernandar_99/residencia-en-renta-con-paneles-solares-y-area-social-valle-de-santa-teresa	text	OFFER	{"area": 240, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "Valle de Santa Teresa, Aguascalientes (a dos cuadras de Colosio)", "maxPrice": 35000, "minPrice": 35000, "bathrooms": 3.5, "contactInfo": null, "description": "Casa 2 niveles en renta. 3 recámaras, 3 baños completos + 1 medio baño, sala-comedor contemporáneo, cocina integral, área social con palapa y asador, cochera 2 autos, paneles solares, sistema hidroneumático. 240m² construcción / 380m² terreno (12x20m frente), orientación sur. Comisión compartida.", "propertyType": "Casa", "operationType": "Rent"}	\N	\N	2026-04-02 18:40:12.989	2026-04-02 18:37:58.648
cmnhtisqr002v4jyw153wr7q4	cmngdnrak00cqjquoukdkgrov	5214491527502@s.whatsapp.net	Erika Ortega	Busco bodega/local al oriente en renta presupuesto a revisar	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": null, "location": "oriente", "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca bodega o local comercial en renta ubicado al oriente. Presupuesto abierto a revisión/negociación.", "propertyType": "bodega/local", "operationType": "Rent"}	matched	[{"id": "cmmuvp3rw01nlxjdte8aaynjg", "image": "/uploads/inmoapp/43627_1773768046189.jpg", "price": 50000.0, "title": "BODEGA INDUSTRIAL EN RENTA O VENTA AL NORORIENTE DE AGUASCALIENTES", "reason": "Tipo OK bodega/local comercial (Business Premises) | Op OK renta | Zona OK nororiente matchea con oriente (coincidencia parcial válida) | Sin presupuesto definido → precio $50,000 MXN aceptable | 689m² amplia superficie comercial"}]	2026-04-02 18:40:22.521	2026-04-02 18:38:34.755
cmnhwmonj000fjk96bqppgyc6	cmn0uw4rh00257fn2mnwq68ca	5214493628095@s.whatsapp.net	Ing. Martin Perez	🌞Buen día Colegas!! \n\n*OFREZCO LOCAL EN RENTA EN DISTRITO SUR PLANTA ALTA* \n$8,316.66 \n✅ 52.87 m2 \n✅ planta alta \n✅ precio más IVA y más mtto	text	OFFER	{"area": 52.87, "urgency": "normal", "currency": "MXN", "location": "Distrito Sur", "maxPrice": 8316.66, "minPrice": 8316.66, "contactInfo": null, "description": "Local en renta en Distrito Sur, planta alta, 52.87 m2. Precio $8,316.66 más IVA y mantenimiento.", "propertyType": "local", "operationType": "Rent"}	\N	\N	2026-04-02 20:10:14.477	2026-04-02 20:05:34.927
cmnhwmy5t000jjk96slh7irzk	cmnfbhk0b000r12lphsiahfyu	5214493628095@s.whatsapp.net	Ing. Martin Perez	🌞Buen día Colegas!! \n\n*OFREZCO LOCAL EN RENTA EN DISTRITO SUR PLANTA ALTA* \n$8,316.66 \n✅ 52.87 m2 \n✅ planta alta \n✅ precio más IVA y más mtto	text	OFFER	{"area": 52.87, "urgency": "normal", "currency": "MXN", "location": "Distrito Sur, planta alta", "maxPrice": 8316.66, "minPrice": 8316.66, "contactInfo": null, "description": "Local en renta en Distrito Sur, planta alta, 52.87 m2, precio $8,316.66 + IVA + mantenimiento", "propertyType": "local", "operationType": "Rent"}	\N	\N	2026-04-02 20:10:39.151	2026-04-02 20:05:47.249
cmni4f29z002njk96tz8mcsqt	cmngdnrd100csjquoo37sjyma	5214491559048@s.whatsapp.net	Toño BR	BUSCO CASA EN RENTA \nSAN GERARDO \nPPTO MAXIMO $8,000.00\nCON POLIZA JURÍDICA	text	DEMAND	{"urgency": "normal", "currency": "MXN", "location": "San Gerardo", "maxPrice": 8000, "description": "Busca casa en renta en San Gerardo, presupuesto máximo $8,000 MXN, requiere póliza jurídica", "propertyType": "Casa", "operationType": "Rent"}	no_match	\N	2026-04-02 23:45:13.12	2026-04-02 23:43:36.264
cmnhu96l900334jyw4csv7jw2	cmnfbjs0q000t12lp6mpl8ngn	5214491690387@s.whatsapp.net	Francisco Báez	✅️🏡 Buena Tarde Francisco Báez Servidor, ✅️✅️ SOLICITO ✅️✅️ Lo mas cerca posible al palenque instalaciones de la feria casa completa presupuesto abierto por toda la temporada de feria entrar desde el 17 de abril salir 11 de mayo, familia de Arandas con gallos de pelea para participar en el palenque \nLes agradezco opciones a mi celular privado 449 169 0387 \nDe antemano gracias ✅️✅️👌	text	DEMAND	{"area": null, "urgency": "alta", "bedrooms": null, "currency": null, "location": "Cerca del palenque / instalaciones de la feria (Aguascalientes, dado el código 449)", "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": {"nombre": "Francisco Báez", "telefono": "449 169 0387"}, "description": "Buscan renta de casa completa lo más cerca posible al palenque de la feria, por toda la temporada ferial. Entrada 17 de abril, salida 11 de mayo. Familia de Arandas con gallos de pelea participando en el palenque. Presupuesto abierto.", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-02 19:05:19.905	2026-04-02 18:59:05.757
cmnhu9kll00374jywvtcwyczm	cmnfbe18l000n12lpjy6143uf	5214494833285@s.whatsapp.net	Horizonte Inmobiliario	Rento casa moderna al norte en calle abierta, a dos cuadras de Colosio y Universidad, amueblada o sin amueblar, ideal para casa u oficinas, sin problemas de estacionamiento, $38,000 \n5 habitaciones, 4.5 baños, estudio, amplia cocina y amplio jardín.\nSe aceptan mascotas, puede facturar.	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": 5, "currency": "MXN", "location": "norte, calle abierta, a dos cuadras de Colosio y Universidad", "maxPrice": 38000, "minPrice": 38000, "bathrooms": 4.5, "contactInfo": null, "description": "Casa moderna en renta al norte, amueblada o sin amueblar, ideal para casa u oficinas. 5 habitaciones, 4.5 baños, estudio, amplia cocina y jardín. Sin problemas de estacionamiento, se aceptan mascotas, puede facturar.", "propertyType": "casa", "operationType": "Rent"}	\N	\N	2026-04-02 19:07:30.532	2026-04-02 18:59:23.913
cmnhu98is00354jywhfwvus4i	cmn0uw4rh00257fn2mnwq68ca	5214491690387@s.whatsapp.net	Francisco Báez	✅️🏡 Buena Tarde Francisco Báez Servidor, ✅️✅️ SOLICITO ✅️✅️ Lo mas cerca posible al palenque instalaciones de la feria casa completa presupuesto abierto por toda la temporada de feria entrar desde el 17 de abril salir 11 de mayo, familia de Arandas con gallos de pelea para participar en el palenque \nLes agradezco opciones a mi celular privado 449 169 0387 \nDe antemano gracias ✅️✅️👌	text	DEMAND	{"area": null, "urgency": "alta", "bedrooms": null, "currency": "MXN", "location": "cerca del palenque / instalaciones de la feria, Aguascalientes", "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": "Francisco Báez, cel 449 169 0387", "description": "Buscan rentar casa completa lo más cerca posible al palenque de la feria de Aguascalientes, para toda la temporada de feria. Entrada 17 de abril, salida 11 de mayo. Familia de Arandas con gallos de pelea. Presupuesto abierto.", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-02 19:06:32.581	2026-04-02 18:59:08.26
cmnhua578003d4jywsntsm6dn	cmngdnrd100csjquoo37sjyma	5214494833285@s.whatsapp.net	Horizonte Inmobiliario	Ofrezco depa amueblado en BEARA, a estrenar, muy moderno, con  minisplit en todas las áreas.\n\n▫️Modelo 3 recámaras, 2.5 baños, 2 cajones de estacionamiento.  $21,800 \n\nAcepta mascotas, puede facturar.	image	OFFER	{"area": null, "parking": 2, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "BEARA", "maxPrice": 21800, "minPrice": 21800, "amenities": ["amueblado", "minisplit", "acepta mascotas", "factura"], "bathrooms": 2.5, "contactInfo": null, "description": "Departamento amueblado a estrenar, moderno, con minisplit en todas las áreas. 3 recámaras, 2.5 baños, 2 cajones de estacionamiento. Acepta mascotas, puede facturar.", "propertyType": "departamento", "operationType": "Rent"}	\N	\N	2026-04-02 19:08:41.158	2026-04-02 18:59:50.612
cmnj3rhay006jjk96sy2cdvem	cmn0uw4rh00257fn2mnwq68ca	5214498040939@s.whatsapp.net	KATYA AGUILAR	*OFREZCO EN RENTA AMUEBLADO*\n\n🏠CASA EN MANGATA RESIDENCIAL \n3 habitaciones con clóset y ventiladores de techo.\n2.5 baños \n$16.000 incluye mantenimiento \nDisponible a partir del 15 de abril \n* No mascotas \n* ⁠póliza jurídica \n* ⁠1 año mínimo de contrato\n\n🏠CASA EN YALTA CAMPESTRE  de dos habitaciones.\nLa principal en planta alta con jacuzzi \n3 baños \nAmplia Terraza\n$18,900 bajo de precio  \n \n\n🏠Casa de 3 habitaciones en RINCON ANDALUZ\n$25,000 renta mensual incluyendo agua, internet y mantenimiento.\n\n🏠Casa en PRIVADA CALICANTOS de 3 habitaciones cada una con vestidor y baño.\nJardín con terraza\nAsador \nCuarto de juegos con mesa de poker.\n$47,500 renta mensual incluye internet y SKY.	text	OFFER	{"urgency": "normal", "currency": "MXN", "listings": [{"notes": "Incluye mantenimiento. Disponible 15 de abril. No mascotas. Póliza jurídica. Mínimo 1 año.", "price": 16000, "bedrooms": 3, "location": "Mangata Residencial", "bathrooms": 2.5}, {"notes": "Recámara principal en planta alta con jacuzzi. Amplia terraza.", "price": 18900, "bedrooms": 2, "location": "Yalta Campestre", "bathrooms": 3}, {"notes": "Incluye agua, internet y mantenimiento.", "price": 25000, "bedrooms": 3, "location": "Rincón Andaluz", "bathrooms": null}, {"notes": "Cada habitación con vestidor y baño. Jardín, terraza, asador, cuarto de juegos con mesa de poker. Incluye internet y SKY.", "price": 47500, "bedrooms": 3, "location": "Privada Calicantos", "bathrooms": 3}], "maxPrice": 47500, "minPrice": 16000, "furnished": true, "contactInfo": null, "description": "Oferta de 4 casas amuebladas en renta en distintas privadas/fraccionamientos residenciales", "propertyType": "Casa", "operationType": "Rent"}	\N	\N	2026-04-03 16:16:11.237	2026-04-03 16:13:02.171
cmnjbsv6w007ljk96423ir1lo	cmngdnrd100csjquoo37sjyma	5214494610457@s.whatsapp.net	Ventas Inverhouse	Buena tarde, InverHouse solicita DEPARTAMENTO SIN MUEBLES EN RENTA AL NORTE 🏡🛋️\n💰 $9,000 MXN solo para 1 pareja, sin mascotas, sin nuños, agradecemos sus opciones.	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Zona Norte", "maxPrice": 9000, "minPrice": null, "bathrooms": null, "contactInfo": "InverHouse", "description": "Departamento sin muebles en renta al norte, para 1 pareja, sin mascotas, sin niños", "propertyType": "departamento", "operationType": "Rent"}	matched	[{"id": "cmmuvryk604kzxjdtbx7b7swv", "image": "/uploads/inmoapp/19541_1773768179389.jpg", "price": 10500.0, "title": "DEPARTAMENTO NUEVO EN RENTA ZONA TEC AL NORTE DE AGUASCALIENTES", "reason": "Precio OK $10,500 dentro del 130% de $9,000 ($11,700 máx) | Zona OK Norte (Zona Tec) | Tipo OK Departamento | Op OK Renta | Sin muebles (no dice 'amueblado' en título)"}, {"id": "cmmuvoss20185xjdtw0rb591b", "image": "/uploads/inmoapp/45284_1773768031932.jpg", "price": 10500.0, "title": "DEPARTAMENTO EN RENTA EN ZONA TEC TERRABIT AL NTE. DE AGUASCALIENTES", "reason": "Precio OK $10,500 dentro del 130% de $9,000 ($11,700 máx) | Zona OK Norte (Zona Tec Terrabit) | Tipo OK Departamento | Op OK Renta | Sin muebles (no dice 'amueblado' en título)"}]	2026-04-03 20:05:15.308	2026-04-03 19:58:03.752
cmnjiqhgo009rjk964w6b7xzo	cmn0uw4rh00257fn2mnwq68ca	5214495857571@s.whatsapp.net	Jorge Kablum Inm		text	OTHER	null	\N	\N	2026-04-03 23:15:00.767	2026-04-03 23:12:09.96
cmnhu9n3300394jywynobx48w	cmnfbe18l000n12lpjy6143uf	5214494833285@s.whatsapp.net	Horizonte Inmobiliario	Ofrezco depa amueblado en BEARA, a estrenar, muy moderno, con  minisplit en todas las áreas.\n\n▫️Modelo 3 recámaras, 2.5 baños, 2 cajones de estacionamiento.  $21,800 \n\nAcepta mascotas, puede facturar.	image	OFFER	{"area": null, "parking": 2, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "BEARA", "maxPrice": 21800, "minPrice": 21800, "bathrooms": 2.5, "furnished": true, "contactInfo": null, "description": "Departamento amueblado a estrenar, muy moderno, con minisplit en todas las áreas. 3 recámaras, 2.5 baños, 2 cajones de estacionamiento. Acepta mascotas, puede facturar.", "petsAllowed": true, "propertyType": "departamento", "operationType": "Rent", "invoicingAvailable": true}	\N	\N	2026-04-02 19:08:03.961	2026-04-02 18:59:27.136
cmnhua3c4003b4jywjmfr02xi	cmngdnrd100csjquoo37sjyma	5214494833285@s.whatsapp.net	Horizonte Inmobiliario	Rento casa moderna al norte en calle abierta, a dos cuadras de Colosio y Universidad, amueblada o sin amueblar, ideal para casa u oficinas, sin problemas de estacionamiento, $38,000 \n5 habitaciones, 4.5 baños, estudio, amplia cocina y amplio jardín.\nSe aceptan mascotas, puede facturar.	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": 5, "currency": "MXN", "location": "norte, calle abierta, a dos cuadras de Colosio y Universidad", "maxPrice": 38000, "minPrice": 38000, "bathrooms": 4.5, "contactInfo": null, "description": "Casa moderna en renta al norte, amueblada o sin amueblar, ideal para casa u oficinas. 5 habitaciones, 4.5 baños, estudio, amplia cocina y amplio jardín. Sin problemas de estacionamiento, se aceptan mascotas, puede facturar.", "propertyType": "casa", "operationType": "Rent"}	\N	\N	2026-04-02 19:08:27.501	2026-04-02 18:59:48.197
cmnhup7gg003f4jywohyed3ro	cmngdnrd100csjquoo37sjyma	5214491118377@s.whatsapp.net	Alberto	Rento departamento nuevo en Vía 422, cerca de Alcazar, 3 habitaciones, 2.5 baños, cajón de estacionamiento cubierto $15,000	text	OFFER	{"parking": "1 cajón cubierto", "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "Vía 422, cerca de Alcazar", "maxPrice": 15000, "minPrice": 15000, "bathrooms": 2.5, "contactInfo": null, "description": "Departamento nuevo en renta en Vía 422, cerca de Alcazar, con 3 habitaciones, 2.5 baños y cajón de estacionamiento cubierto a $15,000/mes", "propertyType": "departamento", "operationType": "Rent"}	\N	\N	2026-04-02 19:15:16.896	2026-04-02 19:11:33.376
cmnhuqdjj003j4jyweo5xsnie	cmn0uw4rh00257fn2mnwq68ca	5214491280002@s.whatsapp.net	Lic Annette Ferrara		image	OTHER	null	\N	\N	2026-04-02 19:15:16.913	2026-04-02 19:12:27.919
cmnj49p2v006njk96hnid04ve	cmngdnrd100csjquoo37sjyma	5214491239280@s.whatsapp.net	Charly Santi 😜	Ofrezco casa en renta amueblada\nEn Abada\nRenta $ 15,500\n2 plantas	image	OFFER	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Abada", "maxPrice": 15500, "minPrice": 15500, "bathrooms": null, "furnished": true, "contactInfo": null, "description": "Casa amueblada en renta, 2 plantas, ubicada en Abada. Precio $15,500 MXN mensuales.", "propertyType": "casa", "operationType": "Rent"}	\N	\N	2026-04-03 16:30:16.951	2026-04-03 16:27:12.056
cmnhuu3j4003n4jywl5vsuya0	cmngdnrd100csjquoo37sjyma	5214495827464@s.whatsapp.net	Adriana de la Mora Bienes Raíces	Hola !!! Oigan alguna opción en \n\nRENTA zona alcazar norte de aguas o norponiente \nPresupuesto hasta $15,000 \nCambio en mayo \n4 personas de familia \nCon aval en aguas \nSin perro \n\nGracias!!! \nAdrianadelamora \n449 582 74 64	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Zona Alcázar Norte, Aguascalientes o norponiente", "maxPrice": 15000, "bathrooms": null, "contactInfo": "Adriana de la Mora, tel: 449 582 74 64", "description": "Familia de 4 personas busca renta en zona Alcázar Norte de Aguascalientes o norponiente. Presupuesto hasta $15,000 MXN. Cambio en mayo. Cuenta con aval en Aguascalientes. Sin mascotas.", "propertyType": "casa o departamento", "operationType": "Rent"}	\N	\N	2026-04-02 19:20:18.091	2026-04-02 19:15:21.568
cmnhuum7g003r4jywsizxs37p	cmn0uw4rh00257fn2mnwq68ca	5214495827464@s.whatsapp.net	Adriana de la Mora Bienes Raíces	Hola !!! Oigan alguna opción en \n\nRENTA zona alcazar norte de aguas o norponiente \nPresupuesto hasta $15,000 \nCambio en mayo \n4 personas de familia \nCon aval en aguas \nSin perro \n\nGracias!!! \nAdrianadelamora \n449 582 74 64	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Zona Alcázar Norte, Aguascalientes o Norponiente de Aguascalientes", "maxPrice": 15000, "minPrice": null, "bathrooms": null, "contactInfo": "Adrianadelamora, 449 582 74 64", "description": "Familia de 4 personas busca renta en zona Alcázar Norte o Norponiente de Aguascalientes. Presupuesto hasta $15,000 MXN. Disponibilidad para cambio en mayo. Cuentan con aval en Aguascalientes. Sin mascotas.", "propertyType": "casa o departamento", "operationType": "Rent"}	\N	\N	2026-04-02 19:25:28.548	2026-04-02 19:15:45.771
cmnhwqjqk000njk96qmswglgt	cmn0uw4rh00257fn2mnwq68ca	5214492131395@s.whatsapp.net	Hilda Glez Bienes Raices	*🙋🏻‍♀️*Solicito casa al norponiente SIN MUEBLES preferente San Angelo 3 o 4 recamras  cliente solo SIN mascotas aval o poliza juridica renta 1 o 15 de Mayo, solo esa zona o afín casa moderna nueva o seminueva tope 25.000 NO ENVIAR OPCIONES ARRIBA NI MENOS DE 20*	text	DEMAND	{"area": null, "urgency": "alta", "bedrooms": "3 o 4", "currency": "MXN", "location": "Norponiente, San Angelo", "maxPrice": 25000, "minPrice": 20000, "bathrooms": null, "contactInfo": null, "description": "Cliente solo sin mascotas busca casa sin muebles en zona norponiente preferentemente San Angelo. Casa moderna, nueva o seminueva. Requiere aval o póliza jurídica. Disponibilidad 1 o 15 de mayo. Rango estricto 20,000-25,000 MXN.", "propertyType": "casa", "operationType": "Rent"}	\N	\N	2026-04-02 20:11:04.642	2026-04-02 20:08:35.18
cmnhwr257000pjk96el9hd7w5	cmnfbjs0q000t12lp6mpl8ngn	5214492131395@s.whatsapp.net	Hilda Glez Bienes Raices	*🙋🏻‍♀️*Solicito casa al norponiente SIN MUEBLES preferente San Angelo 3 o 4 recamras  cliente solo SIN mascotas aval o poliza juridica renta 1 o 15 de Mayo, solo esa zona o afín casa moderna nueva o seminueva tope 25.000 NO ENVIAR OPCIONES ARRIBA NI MENOS DE 20*	text	DEMAND	{"area": null, "urgency": "alta", "bedrooms": "3 o 4", "currency": "MXN", "location": "Norponiente, San Angelo", "maxPrice": 25000, "minPrice": 20000, "bathrooms": null, "contactInfo": null, "description": "Busca casa sin muebles en zona norponiente, preferentemente San Angelo. Cliente solo, sin mascotas. Requiere aval o póliza jurídica. Disponibilidad 1 o 15 de Mayo. Casa moderna, nueva o seminueva. Rango estricto 20,000-25,000 MXN.", "propertyType": "casa", "operationType": "Rent"}	\N	\N	2026-04-02 20:11:14.248	2026-04-02 20:08:59.035
cmni5chlm002rjk96ln6tcaxl	cmn0uw4rh00257fn2mnwq68ca	5214491825411@s.whatsapp.net	Vane	Buenas tardes busco casa en renta en real del molino \nPresupuesto 25,000	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Real del Molino", "maxPrice": 25000, "bathrooms": null, "contactInfo": null, "description": "Busca casa en renta en Real del Molino con presupuesto de $25,000 MXN mensuales", "propertyType": "Casa", "operationType": "Rent"}	no_match	\N	2026-04-03 00:10:13.856	2026-04-03 00:09:35.771
cmnhuu5gj003p4jywzk6tzmem	cmn0uw4rh00257fn2mnwq68ca	5214492611848@s.whatsapp.net	OMG	📢 Asesores inmobiliarios – Excelente oportunidad para compartir\n\nTraemos en venta terreno al norte de Aguascalientes\n\n📍 A unos pasos de la Universidad Autónoma de Aguascalientes\n🎬 Enfrente de Cinépolis Fundición\n🛣️ Acceso inmediato a Segundo Anillo de Circunvalación\n\n📐 Superficie: 3,167 m²\n💰 Precio: $5,400 m²\n🤝 Comisión compartida: 3%\n\nIdeal para desarrolladora (proyecto vertical, departamentos para estudiantes o uso mixto).\nZona con alta demanda y plusvalía.\n\nInteresados mándenme mensaje directo y les comparto información completa.	image	OFFER	{"area": 3167, "urgency": "normal", "currency": "MXN", "location": "Norte de Aguascalientes, cerca de Universidad Autónoma de Aguascalientes, frente a Cinépolis Fundición, acceso a Segundo Anillo de Circunvalación", "maxPrice": 17101800, "minPrice": 17101800, "contactInfo": "Contacto por mensaje directo (no especificado)", "description": "Terreno en venta de 3,167 m² a $5,400/m² (precio total aprox. $17,101,800 MXN). Ideal para desarrolladora: proyecto vertical, departamentos para estudiantes o uso mixto. Comisión compartida del 3%. Alta demanda y plusvalía en la zona.", "propertyType": "terreno", "operationType": "Sale"}	\N	\N	2026-04-02 19:25:17.678	2026-04-02 19:15:24.067
cmnhxdrty0017jk968hqlidka	cmn0uw4rh00257fn2mnwq68ca	5214492053945@s.whatsapp.net	Rosalinda Sanchez Rocha	Solicito casa en Renta zona Alcázar, Stacia, bosques del paraíso, San Cristóbal,  presupuesto máximo $15,000 \n\nAgradezco sus opciones a mi WhatsApp	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Alcázar, Stacia, Bosques del Paraíso, San Cristóbal", "maxPrice": 15000, "minPrice": null, "bathrooms": null, "contactInfo": "Solicita enviar opciones a su WhatsApp (número no especificado)", "description": "Busca casa en renta en las zonas Alcázar, Stacia, Bosques del Paraíso o San Cristóbal con presupuesto máximo de $15,000 MXN mensuales.", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-02 20:34:07.424	2026-04-02 20:26:38.758
cmnhuv3sc003t4jywn8c0ge79	cmnfbjs0q000t12lp6mpl8ngn	5214495827464@s.whatsapp.net	Adriana de la Mora Bienes Raíces	Hola !!! Oigan alguna opción en \n\nRENTA zona alcazar norte de aguas o norponiente \nPresupuesto hasta $15,000 \nCambio en mayo \n4 personas de familia \nCon aval en aguas \nSin perro \n\nGracias!!! \nAdrianadelamora \n449 582 74 64	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Zona Alcázar Norte, Aguascalientes o Norponiente", "maxPrice": 15000, "minPrice": null, "bathrooms": null, "contactInfo": "Adriana de la Mora - 449 582 74 64", "description": "Busca propiedad en renta para 4 personas de familia. Cuenta con aval en Aguascalientes. Sin mascotas. Cambio de domicilio en mayo.", "propertyType": "casa o departamento", "operationType": "Rent"}	no_match	\N	2026-04-02 19:35:12.652	2026-04-02 19:16:08.556
cmnhvctru0001jk96ml3qck55	cmnfbjs0q000t12lp6mpl8ngn	5214494876100@s.whatsapp.net	Armando Silva Chairez	Hola Oralia. Tengo una persona que busca halojamiento para 5 personas del día 1 al\n4 de mayo.	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": null, "location": null, "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": "Oralia (destinatario del mensaje)", "description": "Buscan hospedaje para 5 personas del 1 al 4 de mayo (3-4 noches). Renta temporal / vacacional.", "propertyType": "alojamiento temporal / vacation rental", "operationType": "Rent"}	no_match	\N	2026-04-02 19:36:22.717	2026-04-02 19:29:55.386
cmnj6v1hy006pjk96u20znym4	cmngdnrd100csjquoo37sjyma	5214495123331@s.whatsapp.net	Mariely Mp	Hola! Busco renta zona norte que acepte 4 gatos 😁 $8mil	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "zona norte", "maxPrice": 8000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca propiedad en renta en zona norte, requisito que acepte 4 gatos, presupuesto de $8,000 mensuales", "propertyType": "no especificado", "operationType": "Rent"}	no_match	\N	2026-04-03 17:40:16.937	2026-04-03 17:39:47.158
cmni5eh1i002tjk964od1cr2v	cmngdnr8300cojquo6jv87m7j	5214491083993@s.whatsapp.net	Paty Flores 💐	❇️❇️❇️\nVía Bienes Raíces \n\n*Ofrece*\n\nCapittala \n-Departamento en *planta baja* en *venta*\n2 recámaras\n2 baños completos \n$1.75M\nComisión 4%\nEn *renta*\nA $9.2k\n\nCapittala \n-Casa 3 recámaras en *venta*\n$2.4M\nComisión 4%\n\nInteresados, escribirme en privado. Gracias 😊 \n\n❇️❇️❇️	text	OFFER	{"urgency": "normal", "listings": [{"floor": "planta baja", "bedrooms": 2, "currency": "MXN", "bathrooms": 2, "rentPrice": 9200, "salePrice": 1750000, "commission": "4%", "propertyType": "departamento"}, {"bedrooms": 3, "currency": "MXN", "salePrice": 2400000, "commission": "4%", "propertyType": "casa"}], "location": "Capittala", "contactInfo": "escribir en privado", "description": "Dos propiedades en Capittala: departamento PB 2rec/2baños en venta $1.75M o renta $9.2k, y casa 3 recámaras en venta $2.4M. Comisión 4% en ambas.", "propertyType": ["departamento", "casa"], "operationType": "Both"}	\N	\N	2026-04-03 00:15:18.809	2026-04-03 00:11:08.358
cmni5ejyo002vjk969ozfd508	cmn0uw4rh00257fn2mnwq68ca	5214491083993@s.whatsapp.net	Paty Flores 💐	❇️❇️❇️\nVía Bienes Raíces \n\n*Ofrece*\n\nCapittala \n-Departamento en *planta baja* en *venta*\n2 recámaras\n2 baños completos \n$1.75M\nComisión 4%\nEn *renta*\nA $9.2k\n\nCapittala \n-Casa 3 recámaras en *venta*\n$2.4M\nComisión 4%\n\nInteresados, escribirme en privado. Gracias 😊 \n\n❇️❇️❇️	text	OFFER	{"urgency": "normal", "listings": [{"floor": "planta baja", "bedrooms": 2, "currency": "MXN", "bathrooms": 2, "rentPrice": 9200, "salePrice": 1750000, "commission": "4%", "propertyType": "departamento"}, {"bedrooms": 3, "currency": "MXN", "salePrice": 2400000, "commission": "4%", "propertyType": "casa"}], "location": "Capittala", "contactInfo": "vía privado", "description": "Departamento en planta baja 2rec/2baños en venta $1.75M o renta $9.2k. Casa 3 recámaras en venta $2.4M. Comisión 4% en ambas. Contacto por privado.", "propertyType": ["departamento", "casa"], "operationType": "Both"}	\N	\N	2026-04-03 00:15:29.226	2026-04-03 00:11:12.144
cmnjckb7s007rjk9649brnklf	cmngdnrfl00cujquogrv21fxg	5214499404495@s.whatsapp.net	Rosa María Calderóngarcia		image	OTHER	null	\N	\N	2026-04-03 20:20:00.34	2026-04-03 20:19:24.232
cmnhvicsb0003jk96x6e1ptj4	cmngdnrd100csjquoo37sjyma	5214494610457@s.whatsapp.net	Ventas Inverhouse	Buena tarde colegas 👋😊, Inverhouse ofrece 🏡:\n\nCASA AMUEBLADA EN RENTA AL PONIENTE 🏡🛋️\n💰 $11,620 MXN En Renta\n🛏️ 2 HABITACIONES\n🚿 2 BAÑOS\n🚗 2 ESTACIONAMIENTOS\n________________________________________\nRENTA DE CASA AMUEBLADA EN SAN GERARDO 🏡✨\n💰 $12,000 MXN En Renta\n🛏️ 2 HABITACIONES\n🚿 1 BAÑO\n🚗 2 ESTACIONAMIENTOS	text	OFFER	{"urgency": "normal", "listings": [{"price": 11620, "bedrooms": 2, "currency": "MXN", "bathrooms": 2, "description": "Casa amueblada en renta al Poniente", "parkingSpots": 2}, {"price": 12000, "bedrooms": 2, "currency": "MXN", "location": "San Gerardo", "bathrooms": 1, "description": "Renta de casa amueblada en San Gerardo", "parkingSpots": 2}], "contactInfo": "Inverhouse", "propertyType": "casa", "operationType": "Rent"}	\N	\N	2026-04-02 19:36:50.683	2026-04-02 19:34:13.307
cmnhw2np50009jk96p7qifg8d	cmn0uw4rh00257fn2mnwq68ca	5214494630524@s.whatsapp.net	Bienes Raíces Martha Obregón	Att, ofrezco casa hermosa en Rinconada Bosques \nRENTA!!\n3 recámaras amplias con vestidor y baño \nCocina equipada\nSala y comedor \nGarage\n$70’000.00	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "Rinconada Bosques", "maxPrice": 70000, "minPrice": 70000, "bathrooms": 1, "contactInfo": null, "description": "Casa en renta con 3 recámaras amplias con vestidor y baño, cocina equipada, sala, comedor y garage.", "propertyType": "Casa", "operationType": "Rent"}	\N	\N	2026-04-02 19:50:15.558	2026-04-02 19:50:00.566
cmnhw5gci000bjk96jpxnm06e	cmn0uw4rh00257fn2mnwq68ca	5214491934609@s.whatsapp.net	Hi	✨✨✨✨✨✨Houze Ofrece!!! 🏠en renta \nRuscello $16500\nMonticello $22,000\nGratamira amueblada $16,000\n✨✨✨✨✨✨✨	text	OFFER	{"urgency": "normal", "currency": "MXN", "listings": [{"price": 16500, "location": "Ruscello"}, {"price": 22000, "location": "Monticello"}, {"price": 16000, "location": "Gratamira", "furnished": true}], "location": "Ruscello, Monticello, Gratamira", "maxPrice": 22000, "minPrice": 16000, "contactInfo": "Houze", "description": "Houze ofrece propiedades en renta en tres ubicaciones: Ruscello $16,500, Monticello $22,000 y Gratamira amueblada $16,000", "propertyType": "casa/departamento", "operationType": "Rent"}	\N	\N	2026-04-02 19:55:16.437	2026-04-02 19:52:11.01
cmnhwmxol000hjk96ptauz4p5	cmngdnr8300cojquo6jv87m7j	5214493628095@s.whatsapp.net	Ing. Martin Perez	🌞Buen día Colegas!! \n\n*OFREZCO LOCAL EN RENTA EN DISTRITO SUR PLANTA ALTA* \n$8,316.66 \n✅ 52.87 m2 \n✅ planta alta \n✅ precio más IVA y más mtto	text	OFFER	{"area": 52.87, "urgency": "normal", "currency": "MXN", "location": "Distrito Sur", "maxPrice": 8316.66, "minPrice": 8316.66, "contactInfo": null, "description": "Local en renta en Distrito Sur, planta alta, 52.87 m2. Precio más IVA y mantenimiento.", "propertyType": "local", "operationType": "Rent"}	\N	\N	2026-04-02 20:10:25.505	2026-04-02 20:05:46.629
cmnhwn47v000ljk96ez4cudrw	cmngdnrak00cqjquoukdkgrov	5214493628095@s.whatsapp.net	Ing. Martin Perez	🌞Buen día Colegas!! \n\n*OFREZCO LOCAL EN RENTA EN DISTRITO SUR PLANTA ALTA* \n$8,316.66 \n✅ 52.87 m2 \n✅ planta alta \n✅ precio más IVA y más mtto	text	OFFER	{"area": 52.87, "urgency": "normal", "currency": "MXN", "location": "Distrito Sur", "maxPrice": 8316.66, "minPrice": 8316.66, "contactInfo": null, "description": "Local en renta en Distrito Sur, planta alta, 52.87 m2. Precio $8,316.66 más IVA y mantenimiento.", "propertyType": "local", "operationType": "Rent"}	\N	\N	2026-04-02 20:10:51.472	2026-04-02 20:05:55.1
cmnhwr2t4000rjk96f0dgz30m	cmngdnrd100csjquoo37sjyma	5214492131395@s.whatsapp.net	Hilda Glez Bienes Raices	*🙋🏻‍♀️*Solicito casa al norponiente SIN MUEBLES preferente San Angelo 3 o 4 recamras  cliente solo SIN mascotas aval o poliza juridica renta 1 o 15 de Mayo, solo esa zona o afín casa moderna nueva o seminueva tope 25.000 NO ENVIAR OPCIONES ARRIBA NI MENOS DE 20*	text	DEMAND	{"area": null, "urgency": "alta", "bedrooms": "3-4", "currency": "MXN", "location": "Norponiente, San Angelo", "maxPrice": 25000, "minPrice": 20000, "bathrooms": null, "contactInfo": null, "description": "Busca casa sin muebles en zona norponiente, preferentemente San Angelo. 3 o 4 recámaras. Cliente solo, sin mascotas. Requiere aval o póliza jurídica. Entrada el 1 o 15 de Mayo. Casa moderna, nueva o seminueva. Rango de renta 20,000–25,000 MXN.", "propertyType": "Casa", "operationType": "Rent"}	\N	\N	2026-04-02 20:11:31.803	2026-04-02 20:08:59.896
cmnjjt522009tjk96lxbzpzgz	cmngdnrd100csjquoo37sjyma	5214498679910@s.whatsapp.net	Guadalupe Chavez de Santos	Solicito casa🏡 por temporada de feria para 11 personas (mujeres y hombres) 3 a 4 habitaciones con dos baños presupuesto $35 mil a $40 mil	text	DEMAND	{"area": null, "urgency": "alta", "bedrooms": "3-4", "currency": "MXN", "location": null, "maxPrice": 40000, "minPrice": 35000, "bathrooms": 2, "contactInfo": null, "description": "Buscan casa en renta por temporada de feria para 11 personas (hombres y mujeres), 3 a 4 habitaciones, 2 baños, presupuesto de $35,000 a $40,000 MXN", "propertyType": "Casa", "operationType": "Rent"}	\N	\N	2026-04-03 23:45:14.05	2026-04-03 23:42:13.466
cmnhwuz4x0013jk96i8qy5s6a	cmngdnrfl00cujquogrv21fxg	5214494418195@s.whatsapp.net	Hilda G	*🙋🏻‍♀️*Solicito casa al norponiente SIN MUEBLES preferente San Angelo 3 o 4 recamras  cliente solo SIN mascotas aval o poliza juridica renta 1 o 15 de Mayo, solo esa zona o afín casa moderna nueva o seminueva tope 25.000 NO ENVIAR OPCIONES ARRIBA NI MENOS DE 20*	text	DEMAND	{"area": null, "urgency": "alta", "bedrooms": "3 o 4", "currency": "MXN", "location": "Norponiente, San Angelo (zona afín)", "maxPrice": 25000, "minPrice": 20000, "bathrooms": null, "contactInfo": null, "description": "Cliente solo, sin mascotas, busca casa sin muebles en zona norponiente (preferente San Angelo), moderna o seminueva. Acepta aval o póliza jurídica. Disponibilidad: 1 o 15 de mayo. Rango estricto 20,000–25,000 MXN. No enviar opciones fuera de rango.", "propertyType": "casa", "operationType": "Rent"}	\N	\N	2026-04-02 20:15:13.433	2026-04-02 20:12:01.761
cmnhwv26p0015jk96r8hwruji	cmn0uw4rh00257fn2mnwq68ca	5214494631166@s.whatsapp.net	Claudia De La Garza	Busco Rancho en venta al SUR de Aguascalientes dentro del estado. (Solamente esa ubicación)\nAprox 30 Has\nQue tenga pozo de agua\nUso agrícola \nPpto abierto	text	DEMAND	{"area": "30 hectáreas aprox", "urgency": "normal", "bedrooms": null, "currency": null, "location": "Sur de Aguascalientes, Aguascalientes", "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca rancho en venta al sur del estado de Aguascalientes (exclusivamente esa ubicación). Aproximadamente 30 hectáreas, con pozo de agua, uso agrícola. Presupuesto abierto.", "propertyType": "Rancho", "operationType": "Sale"}	no_match	\N	2026-04-02 20:15:54.154	2026-04-02 20:12:05.713
cmnhxf5m20019jk969p5lp6wc	cmn0uw4rh00257fn2mnwq68ca	5214492053945@s.whatsapp.net	Rosalinda Sanchez Rocha	Solicito casa en venta colonia San Luis, presupuesto $1'100,000.\n\nAgradezco sus opciones a Watshaap	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Colonia San Luis", "maxPrice": 1100000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Solicita casa en venta en colonia San Luis con presupuesto de $1,100,000. Pide opciones por WhatsApp.", "propertyType": "casa", "operationType": "Sale"}	no_match	\N	2026-04-02 20:34:43.964	2026-04-02 20:27:43.274
cmnhykirr001djk966sw894wc	cmngdnrd100csjquoo37sjyma	5214492014158@s.whatsapp.net	Rogelio Sada	Hola, buen día 👋  \n\nEstoy en búsqueda de un departamento en renta con las siguientes características:  \n\n- 2 recámaras  \n- Cerca de la UAA  \n- Que acepte mascotas 🐶  \n- Presupuesto máximo: $11,000 mensuales  \n\nSi alguien tiene alguna opción o conoce de algo disponible, se los agradecería mucho. ¡Gracias!	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": 2, "currency": "MXN", "location": "Cerca de la UAA", "maxPrice": 11000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca departamento en renta con 2 recámaras, que acepte mascotas, cerca de la UAA, presupuesto máximo $11,000 mensuales", "propertyType": "departamento", "operationType": "Rent"}	no_match	\N	2026-04-02 21:01:17.248	2026-04-02 20:59:53.224
cmnhylgw5001fjk96kya8uvmz	cmngdnrd100csjquoo37sjyma	5214492014158@s.whatsapp.net	Rogelio Sada	🏡 ¡Ofrezco Casa en renta en Valle de Santa Teresa, Aguascalientes!  A dos cuadras de Colosio\n\n💰 $35,000 MXN mensuales  \n🤝 Comisión compartida: \n\n✨ Excelente opción para vivir con comodidad, amplitud y estilo en una de las mejores zonas de la ciudad.  \n\n🔹 Características:  \n• 3 amplias recámaras  \n• 3 baños completos + 1 medio baño  \n• Sala y comedor con diseño contemporáneo  \n• Cocina integral  \n• Área social con palapa y asador (ideal para convivencias)  \n• Cochera para 2 autos con portón moderno  \n• Paneles solares ☀️ (ahorro en energía)  \n• Sistema hidroneumático  \n\n📐 240 m² de construcción  \n📐 380 m² de terreno (12 m de frente x 20 m de fondo)  \n🏡 Casa de 2 niveles, en excelente estado y orientación sur  \n\n📩 Si tienes cliente o te interesa agendar visita, mándame mensaje. ¡Compartimos comisión! https://www.easybroker.com/mx/listing/fernandar_99/residencia-en-renta-con-paneles-solares-y-area-social-valle-de-santa-teresa	text	OFFER	{"area": 240, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "Valle de Santa Teresa, Aguascalientes (a dos cuadras de Colosio)", "maxPrice": 35000, "minPrice": 35000, "bathrooms": 3.5, "contactInfo": null, "description": "Casa de 2 niveles en renta. 3 recámaras, 3 baños completos + 1 medio baño, sala y comedor contemporáneo, cocina integral, área social con palapa y asador, cochera para 2 autos, paneles solares, sistema hidroneumático. 240 m² construcción, 380 m² terreno (12x20 m), orientación sur. Comisión compartida.", "propertyType": "Casa", "operationType": "Rent"}	\N	\N	2026-04-02 21:05:11.192	2026-04-02 21:00:37.445
cmnhyshw3001hjk96zutb30rq	cmn0uw4rh00257fn2mnwq68ca	5214494611335@s.whatsapp.net	Alex	Solicito casa📍 zona Sur\nPresupuesto *$1,300,000.* \nCasa libre de gravamen	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Zona Sur", "maxPrice": 1300000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Solicita casa en zona Sur con presupuesto de $1,300,000. Requiere que esté libre de gravamen.", "propertyType": "Casa", "operationType": "Sale"}	no_match	\N	2026-04-02 21:10:14.839	2026-04-02 21:06:05.331
cmnhyzyj3001njk9681yjhge9	cmngdnrd100csjquoo37sjyma	5214492118037@s.whatsapp.net	INNMOVIR- Lic. Eduardo de la Tijera.	Solicito casa en renta hasta 12 mil \nNorte o poniente.\nFamilia de 5 \nCon aval	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Norte o Poniente", "maxPrice": 12000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Solicita casa en renta hasta $12,000 MXN. Familia de 5 personas, cuenta con aval.", "propertyType": "Casa", "operationType": "Rent"}	no_match	\N	2026-04-02 21:15:12.603	2026-04-02 21:11:53.487
cmnhz4xy0001rjk964kearuol	cmn0uw4rh00257fn2mnwq68ca	5214497697073@s.whatsapp.net	Ana Paula	Colegas busco casa en renta en fraccionamiento alcázar presupuesto máximo $9,000 o $9,500, muchas gracias 🙏	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Fraccionamiento Alcázar", "maxPrice": 9500, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca casa en renta en Fraccionamiento Alcázar con presupuesto máximo de $9,000 a $9,500 MXN", "propertyType": "Casa", "operationType": "Rent"}	no_match	\N	2026-04-02 21:20:14.287	2026-04-02 21:15:46.008
cmni06k9t001tjk96pucxfzpu	cmn0uw4rh00257fn2mnwq68ca	5214492782782@s.whatsapp.net	CFG Inversiones Inmobiliarias	Solicito local de unos 250m2 cerca de hospitalesLo quiero para una capilla de velación y una oficina administrativa con exhibición y venta de Ataudes y Urnas todo lo que conlleva el servicio funerario\nPresupuesto a ver opciones	text	DEMAND	{"area": 250, "urgency": "normal", "bedrooms": null, "currency": null, "location": "cerca de hospitales", "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Solicita local comercial de 250m2 cerca de hospitales para instalar capilla de velación, oficina administrativa y exhibición/venta de ataúdes y urnas (servicio funerario completo). Presupuesto flexible a ver opciones.", "propertyType": "local comercial", "operationType": "Both"}	no_match	\N	2026-04-02 21:50:15.41	2026-04-02 21:45:01.216
cmni1lbyt001xjk9624qbb8mk	cmngdnrd100csjquoo37sjyma	5214492014158@s.whatsapp.net	Rogelio Sada	🏢 ¡Ofrezco Departamento en renta - Torre 7Sette, Norte de Aguascalientes! ✨\n\n💡 Perfecto para vivir con comodidad y estilo:\n• Recámara con baño\n• Estudio / opción a 2da recámara pequeña\n• Baño de visitas completo\n• Sala / Comedor / Cocina\n• Estacionamiento\n\n💵 Renta: $18,000 MXN\n\n📩 Interesados, envíen mensaje directo para más info o agendar visita. ¡No dejes pasar esta oportunidad! https://www.easybroker.com/agent/properties/departamento-en-renta-torre-7-sette	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": 1, "currency": "MXN", "location": "Torre 7Sette, Norte de Aguascalientes", "maxPrice": 18000, "minPrice": 18000, "bathrooms": 2, "contactInfo": "Mensaje directo, link: https://www.easybroker.com/agent/properties/departamento-en-renta-torre-7-sette", "description": "Departamento en renta en Torre 7Sette, norte de Aguascalientes. Incluye recámara con baño, estudio/opción a 2da recámara pequeña, baño de visitas completo, sala/comedor/cocina y estacionamiento.", "propertyType": "departamento", "operationType": "Rent"}	\N	\N	2026-04-02 22:25:11.411	2026-04-02 22:24:29.909
cmni24ml2001zjk96xksms8ok	cmnfbjs0q000t12lp6mpl8ngn	5214498907584@s.whatsapp.net	Edgar Rafael Martinez	Se rentan habitaciones cerca de la UAA, para estudiantes o personal empresarial, $7,000. Casa con todos los servicios cocina, lavadora,jardin, limpieza una vez por semana. Pueden rentarse también para temporada de feria. 2,000 pesos diarios.	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "cerca de la UAA, Aguascalientes", "maxPrice": 7000, "minPrice": 2000, "bathrooms": null, "contactInfo": null, "description": "Se rentan habitaciones cerca de la UAA para estudiantes o personal empresarial a $7,000 mensuales. Casa con cocina, lavadora, jardín y limpieza semanal incluida. También disponible para temporada de feria a $2,000 pesos diarios.", "propertyType": "habitación", "operationType": "Rent"}	\N	\N	2026-04-02 22:40:15.77	2026-04-02 22:39:30.134
cmni24qhv0021jk961tz2nf7e	cmn0uw4rh00257fn2mnwq68ca	5214498907584@s.whatsapp.net	Edgar Rafael Martinez	Se rentan habitaciones cerca de la UAA, para estudiantes o personal empresarial, $7,000. Casa con todos los servicios cocina, lavadora,jardin, limpieza una vez por semana. Pueden rentarse también para temporada de feria. 2,000 pesos diarios.	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Cerca de la UAA, Aguascalientes", "maxPrice": 7000, "minPrice": 7000, "bathrooms": null, "contactInfo": null, "description": "Se rentan habitaciones en casa compartida cerca de la UAA, dirigido a estudiantes o personal empresarial. Precio mensual $7,000 MXN. Incluye todos los servicios: cocina, lavadora, jardín y limpieza semanal. Disponible también por temporada de Feria a $2,000 pesos diarios.", "propertyType": "habitación", "operationType": "Rent", "additionalPricing": {"daily": 2000, "context": "temporada de feria", "currency": "MXN"}}	\N	\N	2026-04-02 22:40:29.389	2026-04-02 22:39:35.203
cmnj8qt6e006rjk96lprpncsj	cmnfbjs0q000t12lp6mpl8ngn	5214494908392@s.whatsapp.net	Rafa Diaz  Inmobiliaria Shaype	Busco\nCasa\nVenta\n*Muralia (only)*\nPresupuesto\n*5 millones*\nRequisito Indispensable\n*3 Recámaras con Baño Propio*\nGracias	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "Muralia", "maxPrice": 5000000, "minPrice": null, "bathrooms": 3, "contactInfo": null, "description": "Busca casa en venta exclusivamente en Muralia, presupuesto de 5 millones, requisito indispensable 3 recámaras cada una con baño propio (en suite).", "propertyType": "Casa", "operationType": "Sale"}	no_match	\N	2026-04-03 18:35:16.784	2026-04-03 18:32:28.983
cmnj8y5zv006vjk967jpzhgnp	cmn0uw4rh00257fn2mnwq68ca	5214491129759@s.whatsapp.net	Arq Jesús FD	Buen día.\n\n*SOLICITO:*\n\n* Casa o departamento en *RENTA sin Muebles* d preferencia al *Norte* como *Jesús María* o *Paseos d Aguascalientes* o x esas zonas. *Presupuesto:* $5,000, un poco más o un poco menos xfavor.\n\nOJO: Cualquier información enviarla a mi whapp xfa.\n\nSaludos...	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Norte de Aguascalientes, Jesús María, Paseos de Aguascalientes", "maxPrice": 5500, "minPrice": 4500, "bathrooms": null, "contactInfo": "Solicita que información sea enviada por WhatsApp", "description": "Busca casa o departamento en renta sin muebles, preferentemente al norte de Aguascalientes, en zonas como Jesús María o Paseos de Aguascalientes. Presupuesto aproximado de $5,000 MXN mensuales.", "propertyType": "Casa o Departamento", "operationType": "Rent"}	no_match	\N	2026-04-03 18:40:19.738	2026-04-03 18:38:12.188
cmnjd2ms7007tjk965kdhvvfo	cmnfbjs0q000t12lp6mpl8ngn	5214491552801@s.whatsapp.net	😊 Anna Argelia	🏠 *Solicito casa en renta*\nAl menos 2 recámaras \nPara 2 personas, madre e hija, con un perro chico.\nZonas de interés: sur, centro, centro-norte, centro-poniente, poniente. \nPresupuesto máximo $9,500 incluyendo mantenimiento. \nCliente perfilado. \n\nAgradezco sus opciones\nArgelia Segundo \n449-155-2801	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": 2, "currency": "MXN", "location": "sur, centro, centro-norte, centro-poniente, poniente", "maxPrice": 9500, "minPrice": null, "bathrooms": null, "contactInfo": "Argelia Segundo, 449-155-2801", "description": "Busca casa en renta para 2 personas (madre e hija) con perro chico. Mínimo 2 recámaras. Presupuesto máximo $9,500 incluyendo mantenimiento. Cliente perfilado.", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-03 20:35:11.569	2026-04-03 20:33:39.031
cmnjegfep008ljk964gtxusfz	cmngdnrak00cqjquoukdkgrov	5214492014158@s.whatsapp.net	Rogelio Sada	🔍 ¡Busco local para consultorio!  \n\nEstoy en búsqueda de un local en renta para consultorio de psicología o médico, en el centro de Aguascalientes o zona sur.  \n\n💰 Presupuesto máximo: $5,000 MXN mensuales  \n📐 Requisitos: espacios funcionales y buena ubicación para pacientes  \n\n📩 Si alguien conoce opciones disponibles, por favor envíen mensaje directo. ¡Gracias de antemano por su ayuda!	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Centro de Aguascalientes o zona sur", "maxPrice": 5000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca local en renta para consultorio de psicología o médico. Requiere espacios funcionales y buena ubicación para pacientes.", "propertyType": "local/consultorio", "operationType": "Rent"}	no_match	\N	2026-04-03 21:15:43.248	2026-04-03 21:12:22.273
cmnjkouew00a1jk96f13fgd4z	cmngdnr8300cojquo6jv87m7j	5214499200180@s.whatsapp.net	Alejandro Arechiga		image	OTHER	null	\N	\N	2026-04-04 00:10:22.075	2026-04-04 00:06:52.664
cmnjkoujr00a3jk96w5rv3yjk	cmnfbjs0q000t12lp6mpl8ngn	5214499200180@s.whatsapp.net	Alejandro Arechiga		image	OTHER	null	\N	\N	2026-04-04 00:10:22.077	2026-04-04 00:06:52.839
cmnjoridd00anjk960xyxdyhy	cmnfbjs0q000t12lp6mpl8ngn	5214491440896@s.whatsapp.net	Felipe Aldana	Con quién me comunico. Para ventas de javer	text	QUESTION	{"contactInfo": null, "description": "El remitente pregunta con quién comunicarse en Javer (Consorcio Javer, desarrolladora inmobiliaria) para el área de ventas. No especifica si busca comprar, colaborar como broker o gestionar algo comercial."}	\N	\N	2026-04-04 02:05:15.814	2026-04-04 02:00:55.489
cmni25n0t0023jk96dm34vozg	cmngdnrfl00cujquogrv21fxg	5214491738070@s.whatsapp.net	Inmobiliaria Especializada MyM	⚠️Solicito casa \nen RENTA sin muebles ⚠️\n📍 Zonar sur, (de preferencia en Lomas del Mirador o Morelos 2) \n🏷️Presupuesto de $5 a $7 mil\n2 personas 👥, no mascotas ❌\n📩 WhatsApp.	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Zona sur, Lomas del Mirador o Morelos 2", "maxPrice": 7000, "minPrice": 5000, "bathrooms": null, "contactInfo": "WhatsApp (no especificado)", "description": "Busca casa en renta sin muebles en zona sur, de preferencia en Lomas del Mirador o Morelos 2. Para 2 personas, sin mascotas.", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-02 22:45:10.961	2026-04-02 22:40:17.354
cmni27hrd0025jk96tmluxzxw	cmngdnrd100csjquoo37sjyma	5214491738070@s.whatsapp.net	Inmobiliaria Especializada MyM	⚠️Solicito casa \nen RENTA sin muebles ⚠️\n📍 Zonar sur, (de preferencia en Lomas del Mirador o Morelos 2) \n🏷️Presupuesto de $5 a $7 mil\n2 personas 👥, no mascotas ❌\n📩 WhatsApp.	text	DEMAND	{"urgency": "normal", "currency": "MXN", "location": "Zona sur, Lomas del Mirador o Morelos 2", "maxPrice": 7000, "minPrice": 5000, "contactInfo": "WhatsApp (no especificado)", "description": "Busca casa en renta sin muebles en zona sur, de preferencia en Lomas del Mirador o Morelos 2. Para 2 personas, sin mascotas.", "propertyType": "casa", "operationType": "Rent"}	no_match	\N	2026-04-02 22:45:45.472	2026-04-02 22:41:43.849
cmni2aim80027jk96lsew9ebc	cmngdnrak00cqjquoukdkgrov	5214492014158@s.whatsapp.net	Rogelio Sada	🚀 ¡OFREZCO LOCAL EN RENTA!!!\n\nUbicado en una de las zonas con mayor crecimiento y flujo vehicular de la ciudad, este local es ideal para quienes buscan visibilidad y proyección inmediata.\n\n📍 A pocos metros de Blvd. Zacatecas, dentro de un desarrollo con alta exposición constante.\n\n🔹 Detalles del local:\n• Superficie: 50 m²\n• Estacionamiento: disponibilidad para clientes\n• Equipamiento: aljibe e instalaciones listas para agua y luz\n\n💰 Renta mensual: $13,000\n🧾 Mantenimiento: $1,300 (por definir por administración)\n\n📈 Zona estratégica con alta conectividad, perfecta para negocios que buscan presencia, accesibilidad y crecimiento rápido.\n\n📩 Interesados, envíen mensaje directo para más información o agendar visita. https://www.easybroker.com/agent/mls_properties/local-en-renta-en-punta-norte-ubicacion-estrategica-sobre-blvd-zacatecas	text	OFFER	{"area": 50, "urgency": "normal", "currency": "MXN", "location": "Blvd. Zacatecas (a pocos metros)", "maxPrice": 13000, "contactInfo": "Mensaje directo / https://www.easybroker.com/agent/mls_properties/local-en-renta-en-punta-no", "description": "Local comercial en renta de 50 m² en zona de alto flujo vehicular y crecimiento. Incluye estacionamiento para clientes, aljibe e instalaciones listas para agua y luz. Renta $13,000/mes + mantenimiento $1,300.", "propertyType": "local", "operationType": "Rent"}	\N	\N	2026-04-02 22:46:26.483	2026-04-02 22:44:04.928
cmnj8r0r8006tjk96dna6lpu5	cmn0uw4rh00257fn2mnwq68ca	5214494908392@s.whatsapp.net	Rafa Diaz  Inmobiliaria Shaype	Busco\nCasa\nVenta\n*Muralia (only)*\nPresupuesto\n*5 millones*\nRequisito Indispensable\n*3 Recámaras con Baño Propio*\nGracias	text	DEMAND	{"urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "Muralia", "maxPrice": 5000000, "bathrooms": 3, "contactInfo": null, "description": "Busca casa en venta en Muralia exclusivamente, presupuesto de 5 millones MXN, requisito indispensable 3 recámaras con baño propio", "propertyType": "Casa", "operationType": "Sale"}	no_match	\N	2026-04-03 18:35:50.416	2026-04-03 18:32:38.804
cmni2dyhb0029jk96byhd3bb2	cmngdnrak00cqjquoukdkgrov	5214492014158@s.whatsapp.net	Rogelio Sada	🎣 🎯🔥 ¡Atención colegas!\n\n📣🌟KABLUM presenta LOCAL EN RENTA en la esquina más privilegiada de Aguascalientes, Bosques del Prado Norte, a unos pasos de Av. Colosio. (monte everest esq. montes himalaya)\n\n📐 Superficie: 68 m²\n\n🏪 Características:\n•⁠  ⁠Local en esquina con alta visibilidad\n•⁠  ⁠Flujo constante peatonal y vehicular\n•⁠  ⁠Ubicación premium para posicionamiento de marca\n•⁠  ⁠Ideal para salon boutique, showroom o servicios\n\n💰 Precio: $25,000 + IVA\n\n📲 449 201 4158\nSi tienes clientes interesados, con gusto compartimos comisión 🤝\n\n🔗 Ficha técnica:\nhttps://www.easybroker.com/mx/listing/olmoi_1/me-801-kablum-coworking-business-hub	text	OFFER	{"area": 68, "urgency": "normal", "currency": "MXN", "location": "Bosques del Prado Norte, Aguascalientes (Monte Everest esq. Montes Himalaya, cerca de Av. Colosio)", "maxPrice": 25000, "minPrice": 25000, "contactInfo": "449 201 4158 (KABLUM)", "description": "Local en esquina con alta visibilidad, flujo constante peatonal y vehicular. Ideal para salón boutique, showroom o servicios. Precio $25,000 + IVA. Comparte comisión con colegas.", "propertyType": "Local comercial", "operationType": "Rent"}	\N	\N	2026-04-02 22:50:13.344	2026-04-02 22:46:45.456
cmni2tc1p002jjk96gb3iq1nf	cmngdnrak00cqjquoukdkgrov	5214491527502@s.whatsapp.net	Erika Ortega	Busco local comercial amplio de uno 100m2 aprox, al sur, puede ser santa Mónica, las huertas, la barranca, Pilar Blanco presupuesto a revisar,	text	DEMAND	{"area": "100m2 aprox", "urgency": "normal", "bedrooms": null, "currency": null, "location": "Sur de la ciudad: Santa Mónica, Las Huertas, La Barranca, Pilar Blanco", "maxPrice": null, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca local comercial amplio de aproximadamente 100m2 al sur de la ciudad. Zonas aceptadas: Santa Mónica, Las Huertas, La Barranca, Pilar Blanco. Presupuesto a revisar (abierto a negociación).", "propertyType": "local comercial", "operationType": "Both"}	no_match	\N	2026-04-02 23:00:19.84	2026-04-02 22:58:42.877
cmni3qcr5002ljk96f7kx802e	cmngdnrak00cqjquoukdkgrov	5214492014158@s.whatsapp.net	Rogelio Sada	🔍 ¡Busco local para consultorio!  \n\nEstoy en búsqueda de un local en renta para consultorio de psicología o médico, en el centro de Aguascalientes o zona sur.  \n\n💰 Presupuesto máximo: $5,000 MXN mensuales  \n📐 Requisitos: espacios funcionales y buena ubicación para pacientes  \n\n📩 Si alguien conoce opciones disponibles, por favor envíen mensaje directo. ¡Gracias de antemano por su ayuda!	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Centro de Aguascalientes o zona sur", "maxPrice": 5000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca local en renta para consultorio de psicología o médico. Requiere espacios funcionales y buena ubicación para pacientes.", "propertyType": "local/consultorio", "operationType": "Rent"}	no_match	\N	2026-04-02 23:25:10.383	2026-04-02 23:24:23.441
cmnjkouqa00a5jk961nod91y0	cmnfbjs0q000t12lp6mpl8ngn	5214499200180@s.whatsapp.net	Alejandro Arechiga	$4'450,000 a tratar	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": null, "maxPrice": 4450000, "minPrice": 4450000, "bathrooms": null, "contactInfo": null, "description": "Propiedad en venta a $4,450,000 con precio a tratar. Sin detalles adicionales de tipo o ubicación.", "propertyType": null, "operationType": "Sale"}	\N	\N	2026-04-04 00:10:40.488	2026-04-04 00:06:53.075
cmnjkour500a7jk96pofe7wio	cmngdnr8300cojquo6jv87m7j	5214499200180@s.whatsapp.net	Alejandro Arechiga	$4'450,000 a tratar	text	OTHER	{}	\N	\N	2026-04-04 00:10:50.196	2026-04-04 00:06:53.105
cmnjpb5yi00apjk965n1ec7u0	cmnfbe18l000n12lpjy6143uf	5215639507642@s.whatsapp.net	Tecno Alcance		image	OTHER	null	\N	\N	2026-04-04 02:20:00.546	2026-04-04 02:16:12.522
cmni5irvi002xjk96wxuxqk6m	cmn0uw4rh00257fn2mnwq68ca	5214492131658@s.whatsapp.net	Consorcio Inmobiliario Bo	BUSCO CASA AMUEBLADA AL NORTE CERCA  DE SAMS\nPOR 3 o 4 meses \nSin devolución del deposito	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": null, "duration": "3-4 meses", "location": "Norte, cerca de SAMS", "maxPrice": null, "minPrice": null, "bathrooms": null, "furnished": true, "contactInfo": null, "description": "Busca casa amueblada al norte cerca de SAMS, renta por 3 o 4 meses, sin devolución de depósito", "propertyType": "Casa", "operationType": "Rent"}	matched	[{"id": "cmmuvofm000tvxjdtrp9lx7ty", "image": "/uploads/inmoapp/46402_1773768014868.jpg", "price": 12000.0, "title": "CASA AMUEBLADA EN RENTA VERONA RESIDENCIAL NORPONIENTE DE AGUASCALIENTES", "reason": "Amueblada OK ✓ | Precio OK $12,000 sin restricción de presupuesto | Zona norponiente matchea parcialmente norte (regla explícita) | Tipo OK casa | Op OK renta | Único con las 3 características clave: amueblada + norte + casa en renta"}]	2026-04-03 00:15:44.979	2026-04-03 00:14:29.022
cmni9yjh7003rjk9699hrf0i3	cmngdnrak00cqjquoukdkgrov	5214491028383@s.whatsapp.net	DL	🚨OFREZCO \n\nBodega en RENTA \n📍Jesús María \nA 2 min del centro de Jesús ma \n\nSuperficie 950 m² \nAltura mínima 4 m \nAltura máxima, 5m \nLuz . \nPortón de acceso para carga de descarga . ( tráiler y torton) \nY puertas secundaria a la Bodega. \n\n\nZona de entrada de Jesus Maria . Por Boulevard Alejandro De La Cruz, Saucedo y avenida Solidaridad .\n\n**$35,000**	text	OFFER	{"area": 950, "urgency": "normal", "currency": "MXN", "location": "Jesús María, Boulevard Alejandro De La Cruz / Saucedo / Av. Solidaridad", "maxPrice": 35000, "minPrice": 35000, "contactInfo": null, "description": "Bodega en renta a 2 min del centro de Jesús María. 950 m², altura mínima 4m / máxima 5m, con luz, portón de acceso para carga y descarga (tráiler y tortón) y puerta secundaria.", "propertyType": "Bodega", "operationType": "Rent"}	\N	\N	2026-04-03 02:20:13.735	2026-04-03 02:18:43.098
cmnibap9m0045jk96nqcn9ck9	cmnfbe18l000n12lpjy6143uf	5214491436185@s.whatsapp.net	Mariana Talledos	No vayan a hacer trato con este sujeto fraudulento! \nNo es asesor, vive en la casa de esta misma dirección que viene en la INE, se supone que nos rentaria la planta de arriba de esta misma direccion, y al mismo tiempo rento una de las habitaciones que le había propuesto a mi cliente. Nos recibió el apartado, firmo contrato y nos cobro la renta por adelantado y actuó de la manera más vil y ventajosa, no nos entregó la casa el día que quedó en entregarla y todavía mintió en todo. Quedó en devolver el dinero que se le dió, $25,000 pesos en total, el día de hoy y el muy cabron ya bloqueo a mi cliente y a mí. \nY está en este grupo, su número es +52 449 394 5856\n\nTENGAN MUCHO CUIDADO CON ESTE TIPO DE GENTE SIN VALORES Y TAN DESAGRADABLE!\n\n@57737346039918	image	OTHER	{"description": "Advertencia sobre fraude inmobiliario. No es una oferta ni búsqueda de propiedad."}	\N	\N	2026-04-03 03:00:15.755	2026-04-03 02:56:10.09
cmnj9vzxm006xjk962oakqp6c	cmn0uw4rh00257fn2mnwq68ca	5214495225386@s.whatsapp.net	Inmuebles Especiales bmg	https://www.facebook.com/share/p/17wRPmDTie/	text	OTHER	{}	\N	\N	2026-04-03 19:05:13.619	2026-04-03 19:04:30.635
cmnj9wfh0006zjk96w8mm9axf	cmngdnrd100csjquoo37sjyma	5214497696990@s.whatsapp.net	🧿Stephanie🧿		image	OTHER	null	\N	\N	2026-04-03 19:05:13.623	2026-04-03 19:04:50.772
cmnjdes8q007xjk96se6e5bnu	cmngdnrd100csjquoo37sjyma	5214491963264@s.whatsapp.net	Lore	Buenas tardes solicito casa hasta 40 mil sin muebles \nZona norte\nCalicantos\nHerradura \nCampestre\nEnvíame a mi Watts las propuestas gracias	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Zona norte - Calicantos, Herradura, Campestre", "maxPrice": 40000, "minPrice": null, "bathrooms": null, "contactInfo": "Solicita envío de propuestas por WhatsApp (número no especificado)", "description": "Solicita casa en renta hasta $40,000 MXN sin muebles en zona norte, específicamente en Calicantos, Herradura o Campestre", "propertyType": "Casa", "operationType": "Rent"}	matched	[{"id": "cmmuvoj3f00wtxjdtkwlxru9x", "image": "/uploads/inmoapp/46239_1773768019383.jpg", "price": 39000.0, "title": "AMPLIA RESIDENCIA EN RENTA EN RESIDENCIA ALTARIA AL NTE. DE AGUASCALIENTES", "reason": "Precio OK $39,000 dentro del rango válido $38,000-$40,000 (97.5% del máx) | Zona OK norte (Residencial Altaria al Norte de Aguascalientes, Bulevar a Zacatecas) | Tipo OK casa | Op OK renta | Sin muebles (no indica amueblada) | 4 rec / 4 baños / 400m²"}]	2026-04-03 20:50:32.844	2026-04-03 20:43:05.978
cmnje6el50087jk960wrbzyyn	cmn0uw4rh00257fn2mnwq68ca	5214494908392@s.whatsapp.net	Rafa Diaz  Inmobiliaria Shaype	Busco\nCasa\nVenta\n*Zona Norte*\nPresupuesto\n*5.3 millones Máx.*\nRequisito Indispensable\n*3 Recámaras con Baño Propio*\nGracias	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "location": "Zona Norte", "maxPrice": 5300000, "minPrice": null, "bathrooms": 3, "contactInfo": null, "description": "Busca casa en venta en Zona Norte con presupuesto máximo de 5.3 millones MXN. Requisito indispensable: 3 recámaras cada una con baño propio (3 baños en suite).", "propertyType": "Casa", "operationType": "Sale"}	matched	[{"id": "cmmuvp82q01rtxjdtp13h8i8f", "image": "/uploads/inmoapp/24462_1773768051788.png", "price": 5150000.0, "title": "CASA EN VENTA EN CONDOMINIO ST. ANGELO AL NORPONIENTE DE AGUASCALIENTES", "reason": "Precio OK $5,150,000 dentro de $5,300,000 | Zona OK norponiente matchea norte | Tipo OK casa | Op OK venta | 3 rec con 3 baños (en suite perfecto)"}, {"id": "cmmuvpiqc026lxjdtiiymgcdh", "image": "/uploads/inmoapp/44209_1773768065565.jpg", "price": 5250000.0, "title": "¡SUPER PRECIO!  CASA NUEVA EN VENTA CONDOMINIO ST. ANGELO NORPONIENTE DE AGS.", "reason": "Precio OK $5,250,000 dentro de $5,300,000 | Zona OK norponiente matchea norte | Tipo OK casa | Op OK venta | 3 rec con 4 baños (todas en suite)"}, {"id": "cmmuvp80z01rnxjdt44itimwu", "image": "/uploads/inmoapp/24473_1773768051695.jpg", "price": 5450000.0, "title": "CASA NUEVA EN VENTA EN CONDOMINIO ST. ANGELO AL NORTE DE AGUASCALIENTES", "reason": "Precio OK $5,450,000 (2.8% sobre presupuesto) | Zona OK norte directo | Tipo OK casa | Op OK venta | 4 rec con 4 baños (supera mínimo 3 en suite)"}]	2026-04-03 21:06:16.438	2026-04-03 21:04:34.65
cmnje9w5p008djk96hahztk4m	cmngdnrd100csjquoo37sjyma	5214492014158@s.whatsapp.net	Rogelio Sada	🏢 ¡Ofrezco Departamento en renta - Torre 7Sette, Norte de Aguascalientes! ✨\n\n💡 Perfecto para vivir con comodidad y estilo:\n• Recámara con baño\n• Estudio / opción a 2da recámara pequeña\n• Baño de visitas completo\n• Sala / Comedor / Cocina\n• Estacionamiento\n\n💵 Renta: $18,000 MXN\n\n📩 Interesados, envíen mensaje directo para más info o agendar visita. ¡No dejes pasar esta oportunidad! https://www.easybroker.com/agent/properties/departamento-en-renta-torre-7-sette	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": 1, "currency": "MXN", "location": "Torre 7Sette, Norte de Aguascalientes", "maxPrice": 18000, "minPrice": 18000, "bathrooms": 2, "contactInfo": "Mensaje directo, link: https://www.easybroker.com/agent/properties/departamento-en-renta-torre-7-sette", "description": "Departamento en renta en Torre 7Sette, norte de Aguascalientes. Incluye recámara con baño, estudio/opción a 2da recámara pequeña, baño de visitas completo, sala, comedor, cocina y estacionamiento.", "propertyType": "departamento", "operationType": "Rent"}	\N	\N	2026-04-03 21:10:11.11	2026-04-03 21:07:17.389
cmnjea9s3008fjk9658n3fy9r	cmngdnrd100csjquoo37sjyma	5214492014158@s.whatsapp.net	Rogelio Sada	🏡 ¡Ofrezco Casa en renta en Valle de Santa Teresa, Aguascalientes!  A dos cuadras de Colosio\n\n💰 $35,000 MXN mensuales  \n🤝 Comisión compartida: \n\n✨ Excelente opción para vivir con comodidad, amplitud y estilo en una de las mejores zonas de la ciudad.  \n\n🔹 Características:  \n•⁠  ⁠3 amplias recámaras  \n•⁠  ⁠3 baños completos + 1 medio baño  \n•⁠  ⁠Sala y comedor con diseño contemporáneo  \n•⁠  ⁠Cocina integral  \n•⁠  ⁠Área social con palapa y asador (ideal para convivencias)  \n•⁠  ⁠Cochera para 2 autos con portón moderno  \n•⁠  ⁠Paneles solares ☀️ (ahorro en energía)  \n•⁠  ⁠Sistema hidroneumático  \n\n📐 240 m² de construcción  \n📐 380 m² de terreno (12 m de frente x 20 m de fondo)  \n🏡 Casa de 2 niveles, en excelente estado y orientación sur  \n\n📩 Si tienes cliente o te interesa agendar visita, mándame mensaje. ¡Compartimos comisión! https://www.easybroker.com/mx/listing/fernandar_99/residencia-en-renta-con-paneles-solares-y-area-social-valle-de-santa-teresa	text	OFFER	{"area": 240, "urgency": "normal", "bedrooms": 3, "currency": "MXN", "landArea": 380, "location": "Valle de Santa Teresa, Aguascalientes (a 2 cuadras de Colosio)", "maxPrice": 35000, "minPrice": 35000, "bathrooms": 3.5, "contactInfo": null, "description": "Casa 2 niveles en renta, 3 recámaras, 3 baños completos + 1 medio, sala y comedor contemporáneo, cocina integral, área social con palapa y asador, cochera 2 autos con portón moderno, paneles solares, sistema hidroneumático. 240 m² construcción, 380 m² terreno (12x20 m de frente), orientación sur, excelente estado. Comisión compartida disponible.", "propertyType": "casa", "operationType": "Rent"}	\N	\N	2026-04-03 21:10:25.839	2026-04-03 21:07:35.043
cmnjedkcp008hjk96q0y7467m	cmngdnrd100csjquoo37sjyma	5214492014158@s.whatsapp.net	Rogelio Sada	🎣 🎯🔥 ¡Atención colegas!\n\n📣🌟KABLUM presenta LOCAL EN RENTA en la esquina más privilegiada de Aguascalientes, Bosques del Prado Norte, a unos pasos de Av. Colosio. (monte everest esq. montes himalaya)\n\n📐 Superficie: 68 m²\n\n🏪 Características:\n•⁠  ⁠Local en esquina con alta visibilidad\n•⁠  ⁠Flujo constante peatonal y vehicular\n•⁠  ⁠Ubicación premium para posicionamiento de marca\n•⁠  ⁠Ideal para salon boutique, showroom o servicios\n\n💰 Precio: $25,000 + IVA\n\n📲 449 201 4158\nSi tienes clientes interesados, con gusto compartimos comisión 🤝\n\n🔗 Ficha técnica:\nhttps://www.easybroker.com/mx/listing/olmoi_1/me-801-kablum-coworking-business-hub	text	OFFER	{"area": 68, "urgency": "normal", "currency": "MXN", "location": "Bosques del Prado Norte, Aguascalientes, esquina Monte Everest y Montes Himalaya, cerca de Av. Colosio", "maxPrice": 25000, "minPrice": 25000, "contactInfo": "449 201 4158 - KABLUM", "description": "Local en esquina con alta visibilidad, flujo constante peatonal y vehicular. Ideal para salón boutique, showroom o servicios. Precio $25,000 + IVA. Comparte comisión.", "propertyType": "local", "operationType": "Rent"}	\N	\N	2026-04-03 21:15:15.961	2026-04-03 21:10:08.714
cmnjefq5v008jjk96q2ifli3p	cmngdnrak00cqjquoukdkgrov	5214492014158@s.whatsapp.net	Rogelio Sada	🚀 ¡OFREZCO LOCAL EN RENTA!!!\n\nUbicado en una de las zonas con mayor crecimiento y flujo vehicular de la ciudad, este local es ideal para quienes buscan visibilidad y proyección inmediata.\n\n📍 A pocos metros de Blvd. Zacatecas, dentro de un desarrollo con alta exposición constante.\n\n🔹 Detalles del local:\n• Superficie: 50 m²\n• Estacionamiento: disponibilidad para clientes\n• Equipamiento: aljibe e instalaciones listas para agua y luz\n\n💰 Renta mensual: $13,000\n🧾 Mantenimiento: $1,300 (por definir por administración)\n\n📈 Zona estratégica con alta conectividad, perfecta para negocios que buscan presencia, accesibilidad y crecimiento rápido.\n\n📩 Interesados, envíen mensaje directo para más información o agendar visita. https://www.easybroker.com/agent/mls_properties/local-en-renta-en-punta-norte-ubicacion-estrategica-sobre-blvd-zacatecas	text	OFFER	{"area": 50, "urgency": "normal", "currency": "MXN", "location": "Blvd. Zacatecas, Punta Norte", "maxPrice": 13000, "minPrice": 13000, "contactInfo": "Mensaje directo. EasyBroker: https://www.easybroker.com/agent/mls_properties/local-en-renta-en-punta-no", "description": "Local en renta de 50m² ubicado cerca de Blvd. Zacatecas en desarrollo con alta exposición vehicular. Incluye estacionamiento para clientes, aljibe e instalaciones listas para agua y luz. Mantenimiento $1,300/mes adicional.", "propertyType": "local", "operationType": "Rent"}	\N	\N	2026-04-03 21:15:30.014	2026-04-03 21:11:49.555
cmnjey4ef009bjk96go7egtzy	cmngdnr8300cojquo6jv87m7j	5214493628095@s.whatsapp.net	Ing. Martin Perez	🌞Buen día Colegas!! \n\n*BUSCO DEPARTAMENTO PARA UNA PAREJA EN RENTA EN ZONA CENTRO* \n✅ presupuesto $8,000 máximo \n✅ no tienen niños,  o tienen mascotas, tienen buenos ingresos	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Zona Centro", "maxPrice": 8000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca departamento en renta para una pareja. Presupuesto máximo $8,000 MXN. Sin niños, posiblemente con mascotas (redacción ambigua). Buenos ingresos comprobables.", "propertyType": "departamento", "operationType": "Rent"}	no_match	\N	2026-04-03 21:31:21.746	2026-04-03 21:26:07.815
cmnjkobrp009xjk968tq8jn1i	cmn0uw4rh00257fn2mnwq68ca	5214499200180@s.whatsapp.net	Alejandro Arechiga		image	OTHER	null	\N	\N	2026-04-04 00:10:00.533	2026-04-04 00:06:28.501
cmnjkod1y009zjk962r00jvbq	cmn0uw4rh00257fn2mnwq68ca	5214499200180@s.whatsapp.net	Alejandro Arechiga	$4'450,000 a tratar	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": null, "maxPrice": 4450000, "minPrice": 4450000, "bathrooms": null, "contactInfo": null, "description": "Propiedad en venta a $4,450,000 precio a tratar (negociable). Sin detalles adicionales de tipo o ubicación.", "propertyType": null, "operationType": "Sale"}	\N	\N	2026-04-04 00:10:22.071	2026-04-04 00:06:30.166
cmnjehtsu008njk96gj6228yv	cmngdnrd100csjquoo37sjyma	5214492221173@s.whatsapp.net	Karina	*OFREZCO*\nDepa amueblado Terrabit $12,000\nCasa en Quintas de Monticello $22,000\nCasa amueblada Gratamira $16,000\nEdificio 3 pisos Bosques del Prado Sur $45,000	text	OFFER	{"urgency": "normal", "properties": [{"price": 12000, "currency": "MXN", "location": "Terrabit", "furnished": true, "propertyType": "departamento"}, {"price": 22000, "currency": "MXN", "location": "Quintas de Monticello", "furnished": false, "propertyType": "casa"}, {"price": 16000, "currency": "MXN", "location": "Gratamira", "furnished": true, "propertyType": "casa"}, {"price": 45000, "floors": 3, "currency": "MXN", "location": "Bosques del Prado Sur", "propertyType": "edificio"}], "contactInfo": null, "description": "Se ofrecen 4 propiedades en renta: departamento amueblado en Terrabit ($12,000), casa en Quintas de Monticello ($22,000), casa amueblada en Gratamira ($16,000) y edificio de 3 pisos en Bosques del Prado Sur ($45,000).", "operationType": "Rent"}	\N	\N	2026-04-03 21:16:19.164	2026-04-03 21:13:27.582
cmnjehuyz008pjk964hpk29l0	cmn0uw4rh00257fn2mnwq68ca	5214492221173@s.whatsapp.net	Karina	*OFREZCO*\nDepa amueblado Terrabit $12,000\nCasa en Quintas de Monticello $22,000\nCasa amueblada Gratamira $16,000\nEdificio 3 pisos Bosques del Prado Sur $45,000	text	OFFER	{"urgency": "normal", "currency": "MXN", "properties": [{"price": 12000, "location": "Terrabit", "furnished": true, "description": "Departamento amueblado en Terrabit", "propertyType": "departamento"}, {"price": 22000, "location": "Quintas de Monticello", "furnished": false, "description": "Casa en Quintas de Monticello", "propertyType": "casa"}, {"price": 16000, "location": "Gratamira", "furnished": true, "description": "Casa amueblada en Gratamira", "propertyType": "casa"}, {"price": 45000, "floors": 3, "location": "Bosques del Prado Sur", "furnished": false, "description": "Edificio de 3 pisos en Bosques del Prado Sur", "propertyType": "edificio"}], "contactInfo": null, "operationType": "Rent"}	\N	\N	2026-04-03 21:16:33.739	2026-04-03 21:13:29.099
cmnjehv8j008rjk96ipeft5q6	cmnfbjs0q000t12lp6mpl8ngn	5214492221173@s.whatsapp.net	Karina	*OFREZCO*\nDepa amueblado Terrabit $12,000\nCasa en Quintas de Monticello $22,000\nCasa amueblada Gratamira $16,000\nEdificio 3 pisos Bosques del Prado Sur $45,000	text	OFFER	{"urgency": "normal", "properties": [{"price": 12000, "currency": "MXN", "location": "Terrabit", "furnished": true, "description": "Departamento amueblado en Terrabit", "propertyType": "departamento"}, {"price": 22000, "currency": "MXN", "location": "Quintas de Monticello", "furnished": false, "description": "Casa en Quintas de Monticello", "propertyType": "casa"}, {"price": 16000, "currency": "MXN", "location": "Gratamira", "furnished": true, "description": "Casa amueblada en Gratamira", "propertyType": "casa"}, {"price": 45000, "floors": 3, "currency": "MXN", "location": "Bosques del Prado Sur", "furnished": false, "description": "Edificio de 3 pisos en Bosques del Prado Sur", "propertyType": "edificio"}], "contactInfo": null, "description": "Oferta múltiple de propiedades en renta: departamento amueblado, dos casas (una amueblada) y un edificio de 3 pisos en distintas zonas", "operationType": "Rent"}	\N	\N	2026-04-03 21:16:55.986	2026-04-03 21:13:29.443
cmnjn4syy00a9jk9605nh7wbv	cmnfbjs0q000t12lp6mpl8ngn	5214498907584@s.whatsapp.net	Edgar Rafael Martinez	Se rentan habitaciones cerca de la UAA, para estudiantes o personal empresarial, $7,000. Casa con todos los servicios cocina, lavadora,jardin, limpieza una vez por semana. Pueden rentarse también para temporada de feria. 2,000 pesos diarios.	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "cerca de la UAA, Aguascalientes", "maxPrice": 7000, "minPrice": 2000, "bathrooms": null, "contactInfo": null, "description": "Se rentan habitaciones en casa con servicios completos (cocina, lavadora, jardín, limpieza semanal), dirigidas a estudiantes o personal empresarial. Precio mensual $7,000 MXN. También disponible por temporada de feria a $2,000 MXN por día.", "propertyType": "habitación", "operationType": "Rent"}	\N	\N	2026-04-04 01:20:15.628	2026-04-04 01:15:16.522
cmnjn4x6c00abjk96tdzaoued	cmn0uw4rh00257fn2mnwq68ca	5214498907584@s.whatsapp.net	Edgar Rafael Martinez	Se rentan habitaciones cerca de la UAA, para estudiantes o personal empresarial, $7,000. Casa con todos los servicios cocina, lavadora,jardin, limpieza una vez por semana. Pueden rentarse también para temporada de feria. 2,000 pesos diarios.	text	OFFER	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "cerca de la UAA, Aguascalientes", "maxPrice": 7000, "minPrice": 7000, "bathrooms": null, "priceDaily": 2000, "contactInfo": null, "description": "Se rentan habitaciones en casa completa con todos los servicios: cocina, lavadora, jardín y limpieza una vez por semana. Precio regular $7,000/mes. También disponible para temporada de Feria de San Marcos a $2,000/día. Dirigido a estudiantes de la UAA o personal empresarial.", "propertyType": "habitación", "operationType": "Rent"}	\N	\N	2026-04-04 01:20:32.458	2026-04-04 01:15:21.972
cmnjnhd9400adjk961gsj0488	cmnfbjs0q000t12lp6mpl8ngn	5214491923544@s.whatsapp.net	Cols Asesoria Inmobiliaria	Busco terreno en renta, mínimo 1,500 mts, hasta 50,000, para canchas de futbol al sur, Poniente o norte.	text	DEMAND	{"area": "mínimo 1500 m²", "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "sur, poniente o norte", "maxPrice": 50000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca terreno en renta de mínimo 1,500 m² para instalar canchas de fútbol. Presupuesto máximo $50,000. Zonas aceptadas: sur, poniente o norte.", "propertyType": "terreno", "operationType": "Rent"}	matched	[{"id": "cmnf9cl4f021x5l47r256oz2w", "image": "/uploads/inmoapp/6982_1775000300279.png", "price": 60000.0, "title": "RENTA DE TERRENO PERIODISTAS DE AGS", "reason": "Tipo OK terreno (Land) | Op OK Renta | Área OK 35,000m² >> mínimo 1,500m² | Zona OK norte/norponiente (Periodistas, Ags) | Precio $60,000 = 120% del máx $50,000 — dentro del umbral 130% permitido"}]	2026-04-04 01:30:18.358	2026-04-04 01:25:02.68
cmnjnhen300afjk96zm7nyzdx	cmn0uw4rh00257fn2mnwq68ca	5214491923544@s.whatsapp.net	Cols Asesoria Inmobiliaria	Busco terreno en renta, mínimo 1,500 mts, hasta 50,000, para canchas de futbol al sur, Poniente o norte.	text	DEMAND	{"area": 1500, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "sur, poniente o norte", "maxPrice": 50000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca terreno en renta de mínimo 1,500 m² para canchas de futbol. Precio máximo $50,000. Zonas: sur, poniente o norte.", "propertyType": "terreno", "areaCondition": "mínimo", "operationType": "Rent"}	no_match	\N	2026-04-04 01:31:55.152	2026-04-04 01:25:04.48
cmnjnj1ev00ajjk96kyacmi9a	cmngdnrfl00cujquogrv21fxg	5214491923544@s.whatsapp.net	Cols Asesoria Inmobiliaria	Busco terreno en renta, mínimo 1,500 mts, hasta 50,000, para canchas de futbol al sur, Poniente o norte.	text	DEMAND	{"area": 1500, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "Sur, Poniente o Norte", "maxPrice": 50000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca terreno en renta, mínimo 1,500 m², hasta $50,000/mes, para uso como canchas de fútbol. Acepta zona sur, poniente o norte.", "propertyType": "terreno", "operationType": "Rent"}	no_match	\N	2026-04-04 01:33:04.783	2026-04-04 01:26:20.647
cmnjnhts400ahjk96ycuz5s02	cmngdnr8300cojquo6jv87m7j	5214491923544@s.whatsapp.net	Cols Asesoria Inmobiliaria	Busco terreno en renta, mínimo 1,500 mts, hasta 50,000, para canchas de futbol al sur, Poniente o norte.	text	DEMAND	{"area": 1500, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "sur, poniente o norte (ciudad no especificada)", "maxPrice": 50000, "minPrice": null, "bathrooms": null, "contactInfo": null, "description": "Busca terreno en renta de mínimo 1,500 m² con precio máximo de $50,000 mensuales, destinado a canchas de fútbol. Acepta zona sur, poniente o norte.", "propertyType": "terreno", "areaCondition": "mínimo", "operationType": "Rent"}	no_match	\N	2026-04-04 01:32:31.069	2026-04-04 01:25:24.1
cmnkeinrf00bfjk96l1lejyxl	cmngdnr8300cojquo6jv87m7j	5214494159086@s.whatsapp.net	Angelica	Buen día. ☀️ \nNecesito CASA EN RENTA S/M, zona San Telmo, Arroyo del Molino. Campanario,  Res. La Paloma… ppto tope, $22,000. \nInf. A mi wapp. 📲	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "San Telmo, Arroyo del Molino, Campanario, Residencial La Paloma", "maxPrice": 22000, "minPrice": null, "bathrooms": null, "furnished": false, "contactInfo": "Contacto vía WhatsApp (no especifica número)", "description": "Busca casa en renta sin muebles (S/M) en zonas San Telmo, Arroyo del Molino, Campanario o Residencial La Paloma. Presupuesto tope de $22,000 MXN mensuales.", "propertyType": "Casa", "operationType": "Rent"}	no_match	\N	2026-04-04 14:05:15.802	2026-04-04 14:01:52.587
cmnkejjcg00bjjk962194cvuu	cmn0uw4rh00257fn2mnwq68ca	5214494159086@s.whatsapp.net	Angelica	Buen día. ☀️ \nNecesito CASA EN RENTA S/M, zona San Telmo, Arroyo del Molino. Campanario,  Res. La Paloma… ppto tope, $22,000. \nInf. A mi wapp. 📲	text	DEMAND	{"area": null, "urgency": "normal", "bedrooms": null, "currency": "MXN", "location": "San Telmo, Arroyo del Molino, Campanario, Res. La Paloma", "maxPrice": 22000, "minPrice": null, "bathrooms": null, "contactInfo": "Contacto por WhatsApp (no especificado)", "description": "Busca casa en renta sin muebles (S/M) en zona San Telmo o fraccionamientos cercanos (Arroyo del Molino, Campanario, Res. La Paloma). Presupuesto tope $22,000 MXN.", "propertyType": "Casa", "operationType": "Rent"}	no_match	\N	2026-04-04 14:06:33.754	2026-04-04 14:02:33.521
\.


--
-- Data for Name: WhatsappGroupPublication; Type: TABLE DATA; Schema: public; Owner: -
--

COPY public."WhatsappGroupPublication" (id, "groupId", "propertyId", "messageContent", "imageUrl", status, "scheduledFor", "sentAt", "errorMessage", "clientId", "createdAt", "updatedAt") FROM stdin;
\.


--
-- Data for Name: WhatsappInstance; Type: TABLE DATA; Schema: public; Owner: -
--

COPY public."WhatsappInstance" (id, "instanceName", "instanceId", status, "qrCode", "phoneNumber", "clientId", "createdAt", "updatedAt", purpose) FROM stdin;
cmm6oqimw000hzzj5ijfc671v	CIE	900425d5-b929-4fdd-be02-3178ccff8a88	connected	data:image/png;base64,[BLOB]	5214424749640	cmm1btd7f0001eb4sxk5p9she	2026-02-28 18:59:26.552	2026-04-03 22:47:56.852	sales
cmmuwkzj500251lthpzgtza5u	TM-Adviser	7cfc40b1-2a77-437d-8010-185141cd0c6d	connected	data:image/png;base64,[BLOB]	5214495375070	cmmurs3uk000p11wei2jymzox	2026-03-17 17:45:33.665	2026-04-03 22:50:17.376	sales
cmmce0na0034e3kp4kk1rk84t	Quantum	11158471-b477-4140-be15-2051fb4fc164	disconnected	data:image/png;base64,[BLOB]	5214497270348	cmj1q5wiw00007rh0ddrefqjx	2026-03-04 18:46:00.405	2026-03-22 06:00:22.059	sales
cmnfafqh3000395jrhityw7nk	DESIC	99b0eac8-33f4-486e-8602-ae1aeec7c802	connected	data:image/png;base64,[BLOB]	5214495555109	cmnf8g8ot00xkb9a76wzwllvi	2026-04-01 00:08:46.791	2026-04-03 22:36:05.113	sales
\.


--
-- Name: AIAgentPrompt AIAgentPrompt_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AIAgentPrompt"
    ADD CONSTRAINT "AIAgentPrompt_pkey" PRIMARY KEY (id);


--
-- Name: AIUsageLog AIUsageLog_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AIUsageLog"
    ADD CONSTRAINT "AIUsageLog_pkey" PRIMARY KEY (id);


--
-- Name: AdWalletTransaction AdWalletTransaction_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AdWalletTransaction"
    ADD CONSTRAINT "AdWalletTransaction_pkey" PRIMARY KEY (id);


--
-- Name: AdWallet AdWallet_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AdWallet"
    ADD CONSTRAINT "AdWallet_pkey" PRIMARY KEY (id);


--
-- Name: AgentConfig AgentConfig_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AgentConfig"
    ADD CONSTRAINT "AgentConfig_pkey" PRIMARY KEY (id);


--
-- Name: AgentProfile AgentProfile_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AgentProfile"
    ADD CONSTRAINT "AgentProfile_pkey" PRIMARY KEY (id);


--
-- Name: AgentPromptCustomization AgentPromptCustomization_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AgentPromptCustomization"
    ADD CONSTRAINT "AgentPromptCustomization_pkey" PRIMARY KEY (id);


--
-- Name: Agent Agent_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Agent"
    ADD CONSTRAINT "Agent_pkey" PRIMARY KEY (id);


--
-- Name: AssignmentConfig AssignmentConfig_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AssignmentConfig"
    ADD CONSTRAINT "AssignmentConfig_pkey" PRIMARY KEY (id);


--
-- Name: AssignmentPool AssignmentPool_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AssignmentPool"
    ADD CONSTRAINT "AssignmentPool_pkey" PRIMARY KEY (id);


--
-- Name: BlogKeyword BlogKeyword_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BlogKeyword"
    ADD CONSTRAINT "BlogKeyword_pkey" PRIMARY KEY (id);


--
-- Name: BlogPost BlogPost_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BlogPost"
    ADD CONSTRAINT "BlogPost_pkey" PRIMARY KEY (id);


--
-- Name: BlogSocialShare BlogSocialShare_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BlogSocialShare"
    ADD CONSTRAINT "BlogSocialShare_pkey" PRIMARY KEY (id);


--
-- Name: BlogView BlogView_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BlogView"
    ADD CONSTRAINT "BlogView_pkey" PRIMARY KEY (id);


--
-- Name: BrandColor BrandColor_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BrandColor"
    ADD CONSTRAINT "BrandColor_pkey" PRIMARY KEY (id);


--
-- Name: BrandKit BrandKit_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BrandKit"
    ADD CONSTRAINT "BrandKit_pkey" PRIMARY KEY (id);


--
-- Name: BrandLogo BrandLogo_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BrandLogo"
    ADD CONSTRAINT "BrandLogo_pkey" PRIMARY KEY (id);


--
-- Name: BrandStyleImage BrandStyleImage_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BrandStyleImage"
    ADD CONSTRAINT "BrandStyleImage_pkey" PRIMARY KEY (id);


--
-- Name: CampaignOptimizationLog CampaignOptimizationLog_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CampaignOptimizationLog"
    ADD CONSTRAINT "CampaignOptimizationLog_pkey" PRIMARY KEY (id);


--
-- Name: ClientCourse ClientCourse_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ClientCourse"
    ADD CONSTRAINT "ClientCourse_pkey" PRIMARY KEY (id);


--
-- Name: Client Client_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Client"
    ADD CONSTRAINT "Client_pkey" PRIMARY KEY (id);


--
-- Name: ColleagueConnection ColleagueConnection_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ColleagueConnection"
    ADD CONSTRAINT "ColleagueConnection_pkey" PRIMARY KEY (id);


--
-- Name: ColorPalette ColorPalette_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ColorPalette"
    ADD CONSTRAINT "ColorPalette_pkey" PRIMARY KEY (id);


--
-- Name: ContentComment ContentComment_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ContentComment"
    ADD CONSTRAINT "ContentComment_pkey" PRIMARY KEY (id);


--
-- Name: ContentImage ContentImage_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ContentImage"
    ADD CONSTRAINT "ContentImage_pkey" PRIMARY KEY (id);


--
-- Name: ContentPrompt ContentPrompt_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ContentPrompt"
    ADD CONSTRAINT "ContentPrompt_pkey" PRIMARY KEY (id);


--
-- Name: Content Content_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Content"
    ADD CONSTRAINT "Content_pkey" PRIMARY KEY (id);


--
-- Name: Conversation Conversation_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Conversation"
    ADD CONSTRAINT "Conversation_pkey" PRIMARY KEY (id);


--
-- Name: CourseCategoryLink CourseCategoryLink_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseCategoryLink"
    ADD CONSTRAINT "CourseCategoryLink_pkey" PRIMARY KEY (id);


--
-- Name: CourseCategory CourseCategory_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseCategory"
    ADD CONSTRAINT "CourseCategory_pkey" PRIMARY KEY (id);


--
-- Name: CourseEnrollment CourseEnrollment_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseEnrollment"
    ADD CONSTRAINT "CourseEnrollment_pkey" PRIMARY KEY (id);


--
-- Name: CourseLesson CourseLesson_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseLesson"
    ADD CONSTRAINT "CourseLesson_pkey" PRIMARY KEY (id);


--
-- Name: CourseModule CourseModule_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseModule"
    ADD CONSTRAINT "CourseModule_pkey" PRIMARY KEY (id);


--
-- Name: Course Course_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Course"
    ADD CONSTRAINT "Course_pkey" PRIMARY KEY (id);


--
-- Name: EfestoCommissionConfig EfestoCommissionConfig_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoCommissionConfig"
    ADD CONSTRAINT "EfestoCommissionConfig_pkey" PRIMARY KEY (id);


--
-- Name: EfestoCommission EfestoCommission_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoCommission"
    ADD CONSTRAINT "EfestoCommission_pkey" PRIMARY KEY (id);


--
-- Name: EfestoFacebookGroup EfestoFacebookGroup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoFacebookGroup"
    ADD CONSTRAINT "EfestoFacebookGroup_pkey" PRIMARY KEY (id);


--
-- Name: EfestoProspectActivity EfestoProspectActivity_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoProspectActivity"
    ADD CONSTRAINT "EfestoProspectActivity_pkey" PRIMARY KEY (id);


--
-- Name: EfestoProspect EfestoProspect_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoProspect"
    ADD CONSTRAINT "EfestoProspect_pkey" PRIMARY KEY (id);


--
-- Name: EfestoPublication EfestoPublication_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoPublication"
    ADD CONSTRAINT "EfestoPublication_pkey" PRIMARY KEY (id);


--
-- Name: EfestoRetentionCommission EfestoRetentionCommission_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoRetentionCommission"
    ADD CONSTRAINT "EfestoRetentionCommission_pkey" PRIMARY KEY (id);


--
-- Name: EfestoVideoScript EfestoVideoScript_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoVideoScript"
    ADD CONSTRAINT "EfestoVideoScript_pkey" PRIMARY KEY (id);


--
-- Name: FacebookGroup FacebookGroup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."FacebookGroup"
    ADD CONSTRAINT "FacebookGroup_pkey" PRIMARY KEY (id);


--
-- Name: FilteredProspect FilteredProspect_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."FilteredProspect"
    ADD CONSTRAINT "FilteredProspect_pkey" PRIMARY KEY (id);


--
-- Name: FunnelStage FunnelStage_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."FunnelStage"
    ADD CONSTRAINT "FunnelStage_pkey" PRIMARY KEY (id);


--
-- Name: GBPConfig GBPConfig_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GBPConfig"
    ADD CONSTRAINT "GBPConfig_pkey" PRIMARY KEY (id);


--
-- Name: GBPPost GBPPost_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GBPPost"
    ADD CONSTRAINT "GBPPost_pkey" PRIMARY KEY (id);


--
-- Name: GBPQueueItem GBPQueueItem_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GBPQueueItem"
    ADD CONSTRAINT "GBPQueueItem_pkey" PRIMARY KEY (id);


--
-- Name: GlobalPortalSettings GlobalPortalSettings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GlobalPortalSettings"
    ADD CONSTRAINT "GlobalPortalSettings_pkey" PRIMARY KEY (id);


--
-- Name: GroupPostGroup GroupPostGroup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GroupPostGroup"
    ADD CONSTRAINT "GroupPostGroup_pkey" PRIMARY KEY (id);


--
-- Name: GroupPost GroupPost_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GroupPost"
    ADD CONSTRAINT "GroupPost_pkey" PRIMARY KEY (id);


--
-- Name: IgHashtagSearch IgHashtagSearch_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."IgHashtagSearch"
    ADD CONSTRAINT "IgHashtagSearch_pkey" PRIMARY KEY (id);


--
-- Name: IgInteraction IgInteraction_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."IgInteraction"
    ADD CONSTRAINT "IgInteraction_pkey" PRIMARY KEY (id);


--
-- Name: IgProspect IgProspect_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."IgProspect"
    ADD CONSTRAINT "IgProspect_pkey" PRIMARY KEY (id);


--
-- Name: IgProspectingCampaign IgProspectingCampaign_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."IgProspectingCampaign"
    ADD CONSTRAINT "IgProspectingCampaign_pkey" PRIMARY KEY (id);


--
-- Name: ImpersonationLog ImpersonationLog_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ImpersonationLog"
    ADD CONSTRAINT "ImpersonationLog_pkey" PRIMARY KEY (id);


--
-- Name: LeadActivity LeadActivity_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."LeadActivity"
    ADD CONSTRAINT "LeadActivity_pkey" PRIMARY KEY (id);


--
-- Name: LeadQualification LeadQualification_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."LeadQualification"
    ADD CONSTRAINT "LeadQualification_pkey" PRIMARY KEY (id);


--
-- Name: Lead Lead_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Lead"
    ADD CONSTRAINT "Lead_pkey" PRIMARY KEY (id);


--
-- Name: LessonBlock LessonBlock_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."LessonBlock"
    ADD CONSTRAINT "LessonBlock_pkey" PRIMARY KEY (id);


--
-- Name: LessonProgress LessonProgress_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."LessonProgress"
    ADD CONSTRAINT "LessonProgress_pkey" PRIMARY KEY (id);


--
-- Name: MarketplaceLead MarketplaceLead_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MarketplaceLead"
    ADD CONSTRAINT "MarketplaceLead_pkey" PRIMARY KEY (id);


--
-- Name: MarketplaceListing MarketplaceListing_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MarketplaceListing"
    ADD CONSTRAINT "MarketplaceListing_pkey" PRIMARY KEY (id);


--
-- Name: Message Message_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Message"
    ADD CONSTRAINT "Message_pkey" PRIMARY KEY (id);


--
-- Name: MetaCampaign MetaCampaign_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaCampaign"
    ADD CONSTRAINT "MetaCampaign_pkey" PRIMARY KEY (id);


--
-- Name: MetaConversation MetaConversation_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaConversation"
    ADD CONSTRAINT "MetaConversation_pkey" PRIMARY KEY (id);


--
-- Name: MetaMessage MetaMessage_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaMessage"
    ADD CONSTRAINT "MetaMessage_pkey" PRIMARY KEY (id);


--
-- Name: MetaPublication MetaPublication_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaPublication"
    ADD CONSTRAINT "MetaPublication_pkey" PRIMARY KEY (id);


--
-- Name: Notification Notification_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Notification"
    ADD CONSTRAINT "Notification_pkey" PRIMARY KEY (id);


--
-- Name: Payment Payment_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Payment"
    ADD CONSTRAINT "Payment_pkey" PRIMARY KEY (id);


--
-- Name: PortalProspect PortalProspect_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PortalProspect"
    ADD CONSTRAINT "PortalProspect_pkey" PRIMARY KEY (id);


--
-- Name: PortalPublication PortalPublication_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PortalPublication"
    ADD CONSTRAINT "PortalPublication_pkey" PRIMARY KEY (id);


--
-- Name: PortalSettings PortalSettings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PortalSettings"
    ADD CONSTRAINT "PortalSettings_pkey" PRIMARY KEY (id);


--
-- Name: PropertyCreationSession PropertyCreationSession_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyCreationSession"
    ADD CONSTRAINT "PropertyCreationSession_pkey" PRIMARY KEY (id);


--
-- Name: PropertyCustomContent PropertyCustomContent_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyCustomContent"
    ADD CONSTRAINT "PropertyCustomContent_pkey" PRIMARY KEY (id);


--
-- Name: PropertyDeactivation PropertyDeactivation_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyDeactivation"
    ADD CONSTRAINT "PropertyDeactivation_pkey" PRIMARY KEY (id);


--
-- Name: PropertyDriveFolder PropertyDriveFolder_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyDriveFolder"
    ADD CONSTRAINT "PropertyDriveFolder_pkey" PRIMARY KEY (id);


--
-- Name: PropertyImage PropertyImage_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyImage"
    ADD CONSTRAINT "PropertyImage_pkey" PRIMARY KEY (id);


--
-- Name: Property Property_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Property"
    ADD CONSTRAINT "Property_pkey" PRIMARY KEY (id);


--
-- Name: PublicationSchedule PublicationSchedule_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PublicationSchedule"
    ADD CONSTRAINT "PublicationSchedule_pkey" PRIMARY KEY (id);


--
-- Name: SalesFunnel SalesFunnel_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."SalesFunnel"
    ADD CONSTRAINT "SalesFunnel_pkey" PRIMARY KEY (id);


--
-- Name: ScheduledFollowUp ScheduledFollowUp_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ScheduledFollowUp"
    ADD CONSTRAINT "ScheduledFollowUp_pkey" PRIMARY KEY (id);


--
-- Name: ScheduledMessage ScheduledMessage_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ScheduledMessage"
    ADD CONSTRAINT "ScheduledMessage_pkey" PRIMARY KEY (id);


--
-- Name: ServiceHire ServiceHire_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ServiceHire"
    ADD CONSTRAINT "ServiceHire_pkey" PRIMARY KEY (id);


--
-- Name: ServiceProviderRating ServiceProviderRating_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ServiceProviderRating"
    ADD CONSTRAINT "ServiceProviderRating_pkey" PRIMARY KEY (id);


--
-- Name: ServiceProvider ServiceProvider_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ServiceProvider"
    ADD CONSTRAINT "ServiceProvider_pkey" PRIMARY KEY (id);


--
-- Name: ShortUrlClick ShortUrlClick_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ShortUrlClick"
    ADD CONSTRAINT "ShortUrlClick_pkey" PRIMARY KEY (id);


--
-- Name: ShortUrl ShortUrl_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ShortUrl"
    ADD CONSTRAINT "ShortUrl_pkey" PRIMARY KEY (id);


--
-- Name: SmartAdsAnalysis SmartAdsAnalysis_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."SmartAdsAnalysis"
    ADD CONSTRAINT "SmartAdsAnalysis_pkey" PRIMARY KEY (id);


--
-- Name: SmartAdsProposal SmartAdsProposal_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."SmartAdsProposal"
    ADD CONSTRAINT "SmartAdsProposal_pkey" PRIMARY KEY (id);


--
-- Name: UserClient UserClient_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."UserClient"
    ADD CONSTRAINT "UserClient_pkey" PRIMARY KEY (id);


--
-- Name: WhatsappGroupMessage WhatsappGroupMessage_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappGroupMessage"
    ADD CONSTRAINT "WhatsappGroupMessage_pkey" PRIMARY KEY (id);


--
-- Name: WhatsappGroupPublication WhatsappGroupPublication_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappGroupPublication"
    ADD CONSTRAINT "WhatsappGroupPublication_pkey" PRIMARY KEY (id);


--
-- Name: WhatsappGroup WhatsappGroup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappGroup"
    ADD CONSTRAINT "WhatsappGroup_pkey" PRIMARY KEY (id);


--
-- Name: WhatsappInstance WhatsappInstance_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappInstance"
    ADD CONSTRAINT "WhatsappInstance_pkey" PRIMARY KEY (id);


--
-- Name: AIAgentPrompt_agentId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "AIAgentPrompt_agentId_key" ON public."AIAgentPrompt" USING btree ("agentId");


--
-- Name: AIUsageLog_clientId_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "AIUsageLog_clientId_createdAt_idx" ON public."AIUsageLog" USING btree ("clientId", "createdAt");


--
-- Name: AIUsageLog_clientId_type_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "AIUsageLog_clientId_type_idx" ON public."AIUsageLog" USING btree ("clientId", type);


--
-- Name: AIUsageLog_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "AIUsageLog_createdAt_idx" ON public."AIUsageLog" USING btree ("createdAt");


--
-- Name: AdWalletTransaction_campaignId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "AdWalletTransaction_campaignId_idx" ON public."AdWalletTransaction" USING btree ("campaignId");


--
-- Name: AdWalletTransaction_type_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "AdWalletTransaction_type_idx" ON public."AdWalletTransaction" USING btree (type);


--
-- Name: AdWalletTransaction_walletId_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "AdWalletTransaction_walletId_createdAt_idx" ON public."AdWalletTransaction" USING btree ("walletId", "createdAt");


--
-- Name: AdWallet_clientId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "AdWallet_clientId_key" ON public."AdWallet" USING btree ("clientId");


--
-- Name: AgentConfig_clientId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "AgentConfig_clientId_key" ON public."AgentConfig" USING btree ("clientId");


--
-- Name: AgentProfile_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "AgentProfile_clientId_idx" ON public."AgentProfile" USING btree ("clientId");


--
-- Name: AgentProfile_shortCode_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "AgentProfile_shortCode_idx" ON public."AgentProfile" USING btree ("shortCode");


--
-- Name: AgentProfile_shortCode_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "AgentProfile_shortCode_key" ON public."AgentProfile" USING btree ("shortCode");


--
-- Name: AgentProfile_userId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "AgentProfile_userId_key" ON public."AgentProfile" USING btree ("userId");


--
-- Name: AgentPromptCustomization_clientId_agentType_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "AgentPromptCustomization_clientId_agentType_key" ON public."AgentPromptCustomization" USING btree ("clientId", "agentType");


--
-- Name: AgentPromptCustomization_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "AgentPromptCustomization_clientId_idx" ON public."AgentPromptCustomization" USING btree ("clientId");


--
-- Name: AssignmentConfig_clientId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "AssignmentConfig_clientId_key" ON public."AssignmentConfig" USING btree ("clientId");


--
-- Name: AssignmentPool_clientId_isActive_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "AssignmentPool_clientId_isActive_idx" ON public."AssignmentPool" USING btree ("clientId", "isActive");


--
-- Name: AssignmentPool_clientId_userId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "AssignmentPool_clientId_userId_key" ON public."AssignmentPool" USING btree ("clientId", "userId");


--
-- Name: BlogKeyword_keyword_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "BlogKeyword_keyword_key" ON public."BlogKeyword" USING btree (keyword);


--
-- Name: BlogKeyword_status_priority_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "BlogKeyword_status_priority_idx" ON public."BlogKeyword" USING btree (status, priority);


--
-- Name: BlogPost_slug_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "BlogPost_slug_idx" ON public."BlogPost" USING btree (slug);


--
-- Name: BlogPost_slug_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "BlogPost_slug_key" ON public."BlogPost" USING btree (slug);


--
-- Name: BlogPost_status_publishedAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "BlogPost_status_publishedAt_idx" ON public."BlogPost" USING btree (status, "publishedAt");


--
-- Name: BlogSocialShare_postId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "BlogSocialShare_postId_idx" ON public."BlogSocialShare" USING btree ("postId");


--
-- Name: BlogView_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "BlogView_createdAt_idx" ON public."BlogView" USING btree ("createdAt");


--
-- Name: BlogView_postId_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "BlogView_postId_createdAt_idx" ON public."BlogView" USING btree ("postId", "createdAt");


--
-- Name: BlogView_postId_ip_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "BlogView_postId_ip_createdAt_idx" ON public."BlogView" USING btree ("postId", ip, "createdAt");


--
-- Name: CampaignOptimizationLog_campaignId_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "CampaignOptimizationLog_campaignId_createdAt_idx" ON public."CampaignOptimizationLog" USING btree ("campaignId", "createdAt");


--
-- Name: ClientCourse_clientId_courseId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "ClientCourse_clientId_courseId_key" ON public."ClientCourse" USING btree ("clientId", "courseId");


--
-- Name: ClientCourse_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ClientCourse_clientId_idx" ON public."ClientCourse" USING btree ("clientId");


--
-- Name: Client_slug_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "Client_slug_key" ON public."Client" USING btree (slug);


--
-- Name: Client_stripeCustomerId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "Client_stripeCustomerId_key" ON public."Client" USING btree ("stripeCustomerId");


--
-- Name: ColleagueConnection_initiatorClientId_recipientClientId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "ColleagueConnection_initiatorClientId_recipientClientId_key" ON public."ColleagueConnection" USING btree ("initiatorClientId", "recipientClientId");


--
-- Name: ColleagueConnection_initiatorClientId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ColleagueConnection_initiatorClientId_status_idx" ON public."ColleagueConnection" USING btree ("initiatorClientId", status);


--
-- Name: ColleagueConnection_recipientClientId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ColleagueConnection_recipientClientId_status_idx" ON public."ColleagueConnection" USING btree ("recipientClientId", status);


--
-- Name: Conversation_clientId_prospectCategory_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Conversation_clientId_prospectCategory_idx" ON public."Conversation" USING btree ("clientId", "prospectCategory");


--
-- Name: Conversation_instanceId_remoteNumber_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "Conversation_instanceId_remoteNumber_key" ON public."Conversation" USING btree ("instanceId", "remoteNumber");


--
-- Name: Conversation_prospectCategory_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Conversation_prospectCategory_idx" ON public."Conversation" USING btree ("prospectCategory");


--
-- Name: CourseCategoryLink_categoryId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "CourseCategoryLink_categoryId_idx" ON public."CourseCategoryLink" USING btree ("categoryId");


--
-- Name: CourseCategoryLink_courseId_categoryId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "CourseCategoryLink_courseId_categoryId_key" ON public."CourseCategoryLink" USING btree ("courseId", "categoryId");


--
-- Name: CourseCategoryLink_courseId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "CourseCategoryLink_courseId_idx" ON public."CourseCategoryLink" USING btree ("courseId");


--
-- Name: CourseCategory_name_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "CourseCategory_name_key" ON public."CourseCategory" USING btree (name);


--
-- Name: CourseEnrollment_courseId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "CourseEnrollment_courseId_idx" ON public."CourseEnrollment" USING btree ("courseId");


--
-- Name: CourseEnrollment_userId_courseId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "CourseEnrollment_userId_courseId_key" ON public."CourseEnrollment" USING btree ("userId", "courseId");


--
-- Name: CourseEnrollment_userId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "CourseEnrollment_userId_idx" ON public."CourseEnrollment" USING btree ("userId");


--
-- Name: CourseLesson_moduleId_order_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "CourseLesson_moduleId_order_idx" ON public."CourseLesson" USING btree ("moduleId", "order");


--
-- Name: CourseModule_courseId_order_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "CourseModule_courseId_order_idx" ON public."CourseModule" USING btree ("courseId", "order");


--
-- Name: Course_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Course_status_idx" ON public."Course" USING btree (status);


--
-- Name: EfestoCommission_prospectId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoCommission_prospectId_idx" ON public."EfestoCommission" USING btree ("prospectId");


--
-- Name: EfestoCommission_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoCommission_status_idx" ON public."EfestoCommission" USING btree (status);


--
-- Name: EfestoCommission_vendedorId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoCommission_vendedorId_idx" ON public."EfestoCommission" USING btree ("vendedorId");


--
-- Name: EfestoFacebookGroup_isActive_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoFacebookGroup_isActive_idx" ON public."EfestoFacebookGroup" USING btree ("isActive");


--
-- Name: EfestoProspectActivity_prospectId_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoProspectActivity_prospectId_createdAt_idx" ON public."EfestoProspectActivity" USING btree ("prospectId", "createdAt");


--
-- Name: EfestoProspect_assignedToId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoProspect_assignedToId_idx" ON public."EfestoProspect" USING btree ("assignedToId");


--
-- Name: EfestoProspect_conversationId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "EfestoProspect_conversationId_key" ON public."EfestoProspect" USING btree ("conversationId");


--
-- Name: EfestoProspect_phone_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoProspect_phone_idx" ON public."EfestoProspect" USING btree (phone);


--
-- Name: EfestoProspect_stage_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoProspect_stage_idx" ON public."EfestoProspect" USING btree (stage);


--
-- Name: EfestoProspect_temperature_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoProspect_temperature_idx" ON public."EfestoProspect" USING btree (temperature);


--
-- Name: EfestoPublication_contentType_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoPublication_contentType_idx" ON public."EfestoPublication" USING btree ("contentType");


--
-- Name: EfestoPublication_createdById_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoPublication_createdById_idx" ON public."EfestoPublication" USING btree ("createdById");


--
-- Name: EfestoPublication_scheduledDate_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoPublication_scheduledDate_idx" ON public."EfestoPublication" USING btree ("scheduledDate");


--
-- Name: EfestoPublication_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoPublication_status_idx" ON public."EfestoPublication" USING btree (status);


--
-- Name: EfestoRetentionCommission_dueDate_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoRetentionCommission_dueDate_idx" ON public."EfestoRetentionCommission" USING btree ("dueDate");


--
-- Name: EfestoRetentionCommission_originalCommId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoRetentionCommission_originalCommId_idx" ON public."EfestoRetentionCommission" USING btree ("originalCommId");


--
-- Name: EfestoRetentionCommission_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoRetentionCommission_status_idx" ON public."EfestoRetentionCommission" USING btree (status);


--
-- Name: EfestoRetentionCommission_vendedorId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoRetentionCommission_vendedorId_idx" ON public."EfestoRetentionCommission" USING btree ("vendedorId");


--
-- Name: EfestoVideoScript_createdById_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoVideoScript_createdById_idx" ON public."EfestoVideoScript" USING btree ("createdById");


--
-- Name: EfestoVideoScript_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "EfestoVideoScript_status_idx" ON public."EfestoVideoScript" USING btree (status);


--
-- Name: FunnelStage_funnelId_order_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "FunnelStage_funnelId_order_idx" ON public."FunnelStage" USING btree ("funnelId", "order");


--
-- Name: GBPConfig_clientId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "GBPConfig_clientId_key" ON public."GBPConfig" USING btree ("clientId");


--
-- Name: GBPPost_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "GBPPost_clientId_idx" ON public."GBPPost" USING btree ("clientId");


--
-- Name: GBPPost_clientId_publishedAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "GBPPost_clientId_publishedAt_idx" ON public."GBPPost" USING btree ("clientId", "publishedAt");


--
-- Name: GBPQueueItem_clientId_order_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "GBPQueueItem_clientId_order_idx" ON public."GBPQueueItem" USING btree ("clientId", "order");


--
-- Name: GBPQueueItem_clientId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "GBPQueueItem_clientId_status_idx" ON public."GBPQueueItem" USING btree ("clientId", status);


--
-- Name: GroupPostGroup_groupId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "GroupPostGroup_groupId_idx" ON public."GroupPostGroup" USING btree ("groupId");


--
-- Name: GroupPostGroup_postId_groupId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "GroupPostGroup_postId_groupId_key" ON public."GroupPostGroup" USING btree ("postId", "groupId");


--
-- Name: GroupPostGroup_postId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "GroupPostGroup_postId_idx" ON public."GroupPostGroup" USING btree ("postId");


--
-- Name: GroupPost_clientId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "GroupPost_clientId_status_idx" ON public."GroupPost" USING btree ("clientId", status);


--
-- Name: GroupPost_contentId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "GroupPost_contentId_idx" ON public."GroupPost" USING btree ("contentId");


--
-- Name: GroupPost_scheduledFor_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "GroupPost_scheduledFor_idx" ON public."GroupPost" USING btree ("scheduledFor");


--
-- Name: IgHashtagSearch_clientId_hashtag_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "IgHashtagSearch_clientId_hashtag_key" ON public."IgHashtagSearch" USING btree ("clientId", hashtag);


--
-- Name: IgHashtagSearch_clientId_isActive_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "IgHashtagSearch_clientId_isActive_idx" ON public."IgHashtagSearch" USING btree ("clientId", "isActive");


--
-- Name: IgInteraction_prospectId_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "IgInteraction_prospectId_createdAt_idx" ON public."IgInteraction" USING btree ("prospectId", "createdAt");


--
-- Name: IgInteraction_type_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "IgInteraction_type_idx" ON public."IgInteraction" USING btree (type);


--
-- Name: IgProspect_clientId_category_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "IgProspect_clientId_category_idx" ON public."IgProspect" USING btree ("clientId", category);


--
-- Name: IgProspect_clientId_prospectScore_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "IgProspect_clientId_prospectScore_idx" ON public."IgProspect" USING btree ("clientId", "prospectScore");


--
-- Name: IgProspect_clientId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "IgProspect_clientId_status_idx" ON public."IgProspect" USING btree ("clientId", status);


--
-- Name: IgProspect_clientId_username_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "IgProspect_clientId_username_key" ON public."IgProspect" USING btree ("clientId", username);


--
-- Name: IgProspect_leadId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "IgProspect_leadId_key" ON public."IgProspect" USING btree ("leadId");


--
-- Name: IgProspectingCampaign_clientId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "IgProspectingCampaign_clientId_status_idx" ON public."IgProspectingCampaign" USING btree ("clientId", status);


--
-- Name: ImpersonationLog_impersonatorId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ImpersonationLog_impersonatorId_idx" ON public."ImpersonationLog" USING btree ("impersonatorId");


--
-- Name: ImpersonationLog_startedAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ImpersonationLog_startedAt_idx" ON public."ImpersonationLog" USING btree ("startedAt");


--
-- Name: ImpersonationLog_targetUserId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ImpersonationLog_targetUserId_idx" ON public."ImpersonationLog" USING btree ("targetUserId");


--
-- Name: LeadActivity_leadId_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "LeadActivity_leadId_createdAt_idx" ON public."LeadActivity" USING btree ("leadId", "createdAt");


--
-- Name: LeadQualification_leadId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "LeadQualification_leadId_key" ON public."LeadQualification" USING btree ("leadId");


--
-- Name: LeadQualification_score_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "LeadQualification_score_idx" ON public."LeadQualification" USING btree (score);


--
-- Name: LeadQualification_temperature_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "LeadQualification_temperature_idx" ON public."LeadQualification" USING btree (temperature);


--
-- Name: Lead_assignedToId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Lead_assignedToId_idx" ON public."Lead" USING btree ("assignedToId");


--
-- Name: Lead_clientId_stageId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Lead_clientId_stageId_idx" ON public."Lead" USING btree ("clientId", "stageId");


--
-- Name: Lead_conversationId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "Lead_conversationId_key" ON public."Lead" USING btree ("conversationId");


--
-- Name: Lead_phone_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Lead_phone_idx" ON public."Lead" USING btree (phone);


--
-- Name: Lead_prospectCategory_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Lead_prospectCategory_idx" ON public."Lead" USING btree ("prospectCategory");


--
-- Name: LessonBlock_lessonId_order_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "LessonBlock_lessonId_order_idx" ON public."LessonBlock" USING btree ("lessonId", "order");


--
-- Name: LessonProgress_enrollmentId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "LessonProgress_enrollmentId_idx" ON public."LessonProgress" USING btree ("enrollmentId");


--
-- Name: LessonProgress_enrollmentId_lessonId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "LessonProgress_enrollmentId_lessonId_key" ON public."LessonProgress" USING btree ("enrollmentId", "lessonId");


--
-- Name: LessonProgress_lessonId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "LessonProgress_lessonId_idx" ON public."LessonProgress" USING btree ("lessonId");


--
-- Name: MarketplaceLead_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MarketplaceLead_clientId_idx" ON public."MarketplaceLead" USING btree ("clientId");


--
-- Name: MarketplaceLead_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MarketplaceLead_createdAt_idx" ON public."MarketplaceLead" USING btree ("createdAt");


--
-- Name: MarketplaceLead_reportedAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MarketplaceLead_reportedAt_idx" ON public."MarketplaceLead" USING btree ("reportedAt");


--
-- Name: MarketplaceListing_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MarketplaceListing_clientId_idx" ON public."MarketplaceListing" USING btree ("clientId");


--
-- Name: MarketplaceListing_listingRef_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MarketplaceListing_listingRef_idx" ON public."MarketplaceListing" USING btree ("listingRef");


--
-- Name: MarketplaceListing_listingRef_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "MarketplaceListing_listingRef_key" ON public."MarketplaceListing" USING btree ("listingRef");


--
-- Name: MarketplaceListing_propertyId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MarketplaceListing_propertyId_idx" ON public."MarketplaceListing" USING btree ("propertyId");


--
-- Name: MarketplaceListing_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MarketplaceListing_status_idx" ON public."MarketplaceListing" USING btree (status);


--
-- Name: MetaCampaign_clientId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MetaCampaign_clientId_status_idx" ON public."MetaCampaign" USING btree ("clientId", status);


--
-- Name: MetaCampaign_propertyId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MetaCampaign_propertyId_idx" ON public."MetaCampaign" USING btree ("propertyId");


--
-- Name: MetaConversation_clientId_lastMessageAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MetaConversation_clientId_lastMessageAt_idx" ON public."MetaConversation" USING btree ("clientId", "lastMessageAt");


--
-- Name: MetaConversation_pageId_participantId_platform_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "MetaConversation_pageId_participantId_platform_key" ON public."MetaConversation" USING btree ("pageId", "participantId", platform);


--
-- Name: MetaPublication_contentId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MetaPublication_contentId_idx" ON public."MetaPublication" USING btree ("contentId");


--
-- Name: MetaPublication_status_scheduledAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "MetaPublication_status_scheduledAt_idx" ON public."MetaPublication" USING btree (status, "scheduledAt");


--
-- Name: Notification_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Notification_clientId_idx" ON public."Notification" USING btree ("clientId");


--
-- Name: Notification_userId_isRead_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Notification_userId_isRead_createdAt_idx" ON public."Notification" USING btree ("userId", "isRead", "createdAt");


--
-- Name: Payment_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Payment_clientId_idx" ON public."Payment" USING btree ("clientId");


--
-- Name: Payment_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Payment_status_idx" ON public."Payment" USING btree (status);


--
-- Name: Payment_stripeInvoiceId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "Payment_stripeInvoiceId_key" ON public."Payment" USING btree ("stripeInvoiceId");


--
-- Name: Payment_stripePaymentIntentId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "Payment_stripePaymentIntentId_key" ON public."Payment" USING btree ("stripePaymentIntentId");


--
-- Name: PortalProspect_clientId_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "PortalProspect_clientId_createdAt_idx" ON public."PortalProspect" USING btree ("clientId", "createdAt");


--
-- Name: PortalProspect_clientId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "PortalProspect_clientId_status_idx" ON public."PortalProspect" USING btree ("clientId", status);


--
-- Name: PortalProspect_source_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "PortalProspect_source_idx" ON public."PortalProspect" USING btree (source);


--
-- Name: PortalPublication_clientId_portal_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "PortalPublication_clientId_portal_idx" ON public."PortalPublication" USING btree ("clientId", portal);


--
-- Name: PortalPublication_propertyId_portal_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "PortalPublication_propertyId_portal_key" ON public."PortalPublication" USING btree ("propertyId", portal);


--
-- Name: PortalPublication_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "PortalPublication_status_idx" ON public."PortalPublication" USING btree (status);


--
-- Name: PortalSettings_clientId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "PortalSettings_clientId_key" ON public."PortalSettings" USING btree ("clientId");


--
-- Name: PortalSettings_customDomain_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "PortalSettings_customDomain_key" ON public."PortalSettings" USING btree ("customDomain");


--
-- Name: PortalSettings_featuredAgentProfileId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "PortalSettings_featuredAgentProfileId_key" ON public."PortalSettings" USING btree ("featuredAgentProfileId");


--
-- Name: PortalSettings_subdomain_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "PortalSettings_subdomain_key" ON public."PortalSettings" USING btree (subdomain);


--
-- Name: PropertyCreationSession_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "PropertyCreationSession_clientId_idx" ON public."PropertyCreationSession" USING btree ("clientId");


--
-- Name: PropertyCreationSession_conversationId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "PropertyCreationSession_conversationId_idx" ON public."PropertyCreationSession" USING btree ("conversationId");


--
-- Name: PropertyCreationSession_userId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "PropertyCreationSession_userId_status_idx" ON public."PropertyCreationSession" USING btree ("userId", status);


--
-- Name: PropertyDeactivation_propertyId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "PropertyDeactivation_propertyId_idx" ON public."PropertyDeactivation" USING btree ("propertyId");


--
-- Name: PropertyImage_propertyId_order_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "PropertyImage_propertyId_order_idx" ON public."PropertyImage" USING btree ("propertyId", "order");


--
-- Name: Property_clientId_inmoappId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "Property_clientId_inmoappId_key" ON public."Property" USING btree ("clientId", "inmoappId");


--
-- Name: Property_clientId_isPublished_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Property_clientId_isPublished_idx" ON public."Property" USING btree ("clientId", "isPublished");


--
-- Name: Property_clientId_operationType_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Property_clientId_operationType_idx" ON public."Property" USING btree ("clientId", "operationType");


--
-- Name: Property_clientId_source_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Property_clientId_source_idx" ON public."Property" USING btree ("clientId", source);


--
-- Name: Property_clientId_tokkoId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "Property_clientId_tokkoId_key" ON public."Property" USING btree ("clientId", "tokkoId");


--
-- Name: Property_externalTokkoId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "Property_externalTokkoId_idx" ON public."Property" USING btree ("externalTokkoId");


--
-- Name: SalesFunnel_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "SalesFunnel_clientId_idx" ON public."SalesFunnel" USING btree ("clientId");


--
-- Name: ScheduledFollowUp_conversationId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ScheduledFollowUp_conversationId_idx" ON public."ScheduledFollowUp" USING btree ("conversationId");


--
-- Name: ScheduledFollowUp_status_scheduledFor_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ScheduledFollowUp_status_scheduledFor_idx" ON public."ScheduledFollowUp" USING btree (status, "scheduledFor");


--
-- Name: ServiceHire_clientId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ServiceHire_clientId_status_idx" ON public."ServiceHire" USING btree ("clientId", status);


--
-- Name: ServiceHire_providerId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ServiceHire_providerId_idx" ON public."ServiceHire" USING btree ("providerId");


--
-- Name: ServiceHire_providerId_userId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "ServiceHire_providerId_userId_key" ON public."ServiceHire" USING btree ("providerId", "userId");


--
-- Name: ServiceProviderRating_providerId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ServiceProviderRating_providerId_idx" ON public."ServiceProviderRating" USING btree ("providerId");


--
-- Name: ServiceProviderRating_providerId_userId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "ServiceProviderRating_providerId_userId_key" ON public."ServiceProviderRating" USING btree ("providerId", "userId");


--
-- Name: ServiceProvider_category_isActive_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ServiceProvider_category_isActive_idx" ON public."ServiceProvider" USING btree (category, "isActive");


--
-- Name: ServiceProvider_shortCode_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ServiceProvider_shortCode_idx" ON public."ServiceProvider" USING btree ("shortCode");


--
-- Name: ServiceProvider_shortCode_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "ServiceProvider_shortCode_key" ON public."ServiceProvider" USING btree ("shortCode");


--
-- Name: ServiceProvider_userId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "ServiceProvider_userId_key" ON public."ServiceProvider" USING btree ("userId");


--
-- Name: ShortUrlClick_shortUrlId_timestamp_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ShortUrlClick_shortUrlId_timestamp_idx" ON public."ShortUrlClick" USING btree ("shortUrlId", "timestamp");


--
-- Name: ShortUrl_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ShortUrl_clientId_idx" ON public."ShortUrl" USING btree ("clientId");


--
-- Name: ShortUrl_contentId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ShortUrl_contentId_idx" ON public."ShortUrl" USING btree ("contentId");


--
-- Name: ShortUrl_propertyId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ShortUrl_propertyId_idx" ON public."ShortUrl" USING btree ("propertyId");


--
-- Name: ShortUrl_shortCode_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "ShortUrl_shortCode_idx" ON public."ShortUrl" USING btree ("shortCode");


--
-- Name: ShortUrl_shortCode_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "ShortUrl_shortCode_key" ON public."ShortUrl" USING btree ("shortCode");


--
-- Name: SmartAdsAnalysis_clientId_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "SmartAdsAnalysis_clientId_createdAt_idx" ON public."SmartAdsAnalysis" USING btree ("clientId", "createdAt");


--
-- Name: SmartAdsAnalysis_propertyId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "SmartAdsAnalysis_propertyId_idx" ON public."SmartAdsAnalysis" USING btree ("propertyId");


--
-- Name: SmartAdsProposal_analysisId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "SmartAdsProposal_analysisId_idx" ON public."SmartAdsProposal" USING btree ("analysisId");


--
-- Name: SmartAdsProposal_campaignId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "SmartAdsProposal_campaignId_key" ON public."SmartAdsProposal" USING btree ("campaignId");


--
-- Name: SmartAdsProposal_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "SmartAdsProposal_status_idx" ON public."SmartAdsProposal" USING btree (status);


--
-- Name: UserClient_clientId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "UserClient_clientId_idx" ON public."UserClient" USING btree ("clientId");


--
-- Name: UserClient_userId_clientId_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "UserClient_userId_clientId_key" ON public."UserClient" USING btree ("userId", "clientId");


--
-- Name: UserClient_userId_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "UserClient_userId_idx" ON public."UserClient" USING btree ("userId");


--
-- Name: WhatsappGroupMessage_classification_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "WhatsappGroupMessage_classification_idx" ON public."WhatsappGroupMessage" USING btree (classification);


--
-- Name: WhatsappGroupMessage_groupId_createdAt_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "WhatsappGroupMessage_groupId_createdAt_idx" ON public."WhatsappGroupMessage" USING btree ("groupId", "createdAt");


--
-- Name: WhatsappGroupPublication_clientId_scheduledFor_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "WhatsappGroupPublication_clientId_scheduledFor_idx" ON public."WhatsappGroupPublication" USING btree ("clientId", "scheduledFor");


--
-- Name: WhatsappGroupPublication_groupId_propertyId_scheduledFor_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "WhatsappGroupPublication_groupId_propertyId_scheduledFor_key" ON public."WhatsappGroupPublication" USING btree ("groupId", "propertyId", "scheduledFor");


--
-- Name: WhatsappGroupPublication_groupId_status_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "WhatsappGroupPublication_groupId_status_idx" ON public."WhatsappGroupPublication" USING btree ("groupId", status);


--
-- Name: WhatsappGroup_clientId_isActive_idx; Type: INDEX; Schema: public; Owner: -
--

CREATE INDEX "WhatsappGroup_clientId_isActive_idx" ON public."WhatsappGroup" USING btree ("clientId", "isActive");


--
-- Name: WhatsappGroup_clientId_jid_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "WhatsappGroup_clientId_jid_key" ON public."WhatsappGroup" USING btree ("clientId", jid);


--
-- Name: WhatsappInstance_instanceName_key; Type: INDEX; Schema: public; Owner: -
--

CREATE UNIQUE INDEX "WhatsappInstance_instanceName_key" ON public."WhatsappInstance" USING btree ("instanceName");


--
-- Name: AIUsageLog AIUsageLog_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AIUsageLog"
    ADD CONSTRAINT "AIUsageLog_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: AdWalletTransaction AdWalletTransaction_campaignId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AdWalletTransaction"
    ADD CONSTRAINT "AdWalletTransaction_campaignId_fkey" FOREIGN KEY ("campaignId") REFERENCES public."MetaCampaign"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: AdWalletTransaction AdWalletTransaction_walletId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AdWalletTransaction"
    ADD CONSTRAINT "AdWalletTransaction_walletId_fkey" FOREIGN KEY ("walletId") REFERENCES public."AdWallet"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: AdWallet AdWallet_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AdWallet"
    ADD CONSTRAINT "AdWallet_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: AgentConfig AgentConfig_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AgentConfig"
    ADD CONSTRAINT "AgentConfig_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: AgentProfile AgentProfile_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AgentProfile"
    ADD CONSTRAINT "AgentProfile_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: AgentProfile AgentProfile_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AgentProfile"
    ADD CONSTRAINT "AgentProfile_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: AgentPromptCustomization AgentPromptCustomization_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AgentPromptCustomization"
    ADD CONSTRAINT "AgentPromptCustomization_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: Agent Agent_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Agent"
    ADD CONSTRAINT "Agent_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Agent Agent_instanceId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Agent"
    ADD CONSTRAINT "Agent_instanceId_fkey" FOREIGN KEY ("instanceId") REFERENCES public."WhatsappInstance"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: AssignmentConfig AssignmentConfig_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AssignmentConfig"
    ADD CONSTRAINT "AssignmentConfig_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: AssignmentPool AssignmentPool_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AssignmentPool"
    ADD CONSTRAINT "AssignmentPool_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: AssignmentPool AssignmentPool_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."AssignmentPool"
    ADD CONSTRAINT "AssignmentPool_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: BlogPost BlogPost_sourceKeywordId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BlogPost"
    ADD CONSTRAINT "BlogPost_sourceKeywordId_fkey" FOREIGN KEY ("sourceKeywordId") REFERENCES public."BlogKeyword"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: BlogSocialShare BlogSocialShare_postId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BlogSocialShare"
    ADD CONSTRAINT "BlogSocialShare_postId_fkey" FOREIGN KEY ("postId") REFERENCES public."BlogPost"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: BlogView BlogView_postId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BlogView"
    ADD CONSTRAINT "BlogView_postId_fkey" FOREIGN KEY ("postId") REFERENCES public."BlogPost"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: BrandColor BrandColor_colorPaletteId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BrandColor"
    ADD CONSTRAINT "BrandColor_colorPaletteId_fkey" FOREIGN KEY ("colorPaletteId") REFERENCES public."ColorPalette"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: BrandKit BrandKit_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BrandKit"
    ADD CONSTRAINT "BrandKit_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: BrandLogo BrandLogo_brandKitId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BrandLogo"
    ADD CONSTRAINT "BrandLogo_brandKitId_fkey" FOREIGN KEY ("brandKitId") REFERENCES public."BrandKit"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: BrandStyleImage BrandStyleImage_brandKitId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."BrandStyleImage"
    ADD CONSTRAINT "BrandStyleImage_brandKitId_fkey" FOREIGN KEY ("brandKitId") REFERENCES public."BrandKit"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: CampaignOptimizationLog CampaignOptimizationLog_campaignId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CampaignOptimizationLog"
    ADD CONSTRAINT "CampaignOptimizationLog_campaignId_fkey" FOREIGN KEY ("campaignId") REFERENCES public."MetaCampaign"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ClientCourse ClientCourse_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ClientCourse"
    ADD CONSTRAINT "ClientCourse_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ClientCourse ClientCourse_courseId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ClientCourse"
    ADD CONSTRAINT "ClientCourse_courseId_fkey" FOREIGN KEY ("courseId") REFERENCES public."Course"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ColleagueConnection ColleagueConnection_initiatorClientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ColleagueConnection"
    ADD CONSTRAINT "ColleagueConnection_initiatorClientId_fkey" FOREIGN KEY ("initiatorClientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ColleagueConnection ColleagueConnection_recipientClientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ColleagueConnection"
    ADD CONSTRAINT "ColleagueConnection_recipientClientId_fkey" FOREIGN KEY ("recipientClientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ColorPalette ColorPalette_brandKitId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ColorPalette"
    ADD CONSTRAINT "ColorPalette_brandKitId_fkey" FOREIGN KEY ("brandKitId") REFERENCES public."BrandKit"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ContentComment ContentComment_contentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ContentComment"
    ADD CONSTRAINT "ContentComment_contentId_fkey" FOREIGN KEY ("contentId") REFERENCES public."Content"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ContentComment ContentComment_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ContentComment"
    ADD CONSTRAINT "ContentComment_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: ContentImage ContentImage_contentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ContentImage"
    ADD CONSTRAINT "ContentImage_contentId_fkey" FOREIGN KEY ("contentId") REFERENCES public."Content"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ContentPrompt ContentPrompt_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ContentPrompt"
    ADD CONSTRAINT "ContentPrompt_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Content Content_approvalById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Content"
    ADD CONSTRAINT "Content_approvalById_fkey" FOREIGN KEY ("approvalById") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Content Content_assignedToId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Content"
    ADD CONSTRAINT "Content_assignedToId_fkey" FOREIGN KEY ("assignedToId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Content Content_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Content"
    ADD CONSTRAINT "Content_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Content Content_contentApprovalById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Content"
    ADD CONSTRAINT "Content_contentApprovalById_fkey" FOREIGN KEY ("contentApprovalById") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Content Content_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Content"
    ADD CONSTRAINT "Content_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Conversation Conversation_agentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Conversation"
    ADD CONSTRAINT "Conversation_agentId_fkey" FOREIGN KEY ("agentId") REFERENCES public."Agent"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Conversation Conversation_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Conversation"
    ADD CONSTRAINT "Conversation_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Conversation Conversation_instanceId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Conversation"
    ADD CONSTRAINT "Conversation_instanceId_fkey" FOREIGN KEY ("instanceId") REFERENCES public."WhatsappInstance"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: CourseCategoryLink CourseCategoryLink_categoryId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseCategoryLink"
    ADD CONSTRAINT "CourseCategoryLink_categoryId_fkey" FOREIGN KEY ("categoryId") REFERENCES public."CourseCategory"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: CourseCategoryLink CourseCategoryLink_courseId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseCategoryLink"
    ADD CONSTRAINT "CourseCategoryLink_courseId_fkey" FOREIGN KEY ("courseId") REFERENCES public."Course"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: CourseEnrollment CourseEnrollment_courseId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseEnrollment"
    ADD CONSTRAINT "CourseEnrollment_courseId_fkey" FOREIGN KEY ("courseId") REFERENCES public."Course"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: CourseEnrollment CourseEnrollment_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseEnrollment"
    ADD CONSTRAINT "CourseEnrollment_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: CourseLesson CourseLesson_moduleId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseLesson"
    ADD CONSTRAINT "CourseLesson_moduleId_fkey" FOREIGN KEY ("moduleId") REFERENCES public."CourseModule"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: CourseModule CourseModule_courseId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."CourseModule"
    ADD CONSTRAINT "CourseModule_courseId_fkey" FOREIGN KEY ("courseId") REFERENCES public."Course"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: EfestoCommission EfestoCommission_prospectId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoCommission"
    ADD CONSTRAINT "EfestoCommission_prospectId_fkey" FOREIGN KEY ("prospectId") REFERENCES public."EfestoProspect"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: EfestoCommission EfestoCommission_vendedorId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoCommission"
    ADD CONSTRAINT "EfestoCommission_vendedorId_fkey" FOREIGN KEY ("vendedorId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: EfestoProspectActivity EfestoProspectActivity_createdById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoProspectActivity"
    ADD CONSTRAINT "EfestoProspectActivity_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: EfestoProspectActivity EfestoProspectActivity_prospectId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoProspectActivity"
    ADD CONSTRAINT "EfestoProspectActivity_prospectId_fkey" FOREIGN KEY ("prospectId") REFERENCES public."EfestoProspect"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: EfestoProspect EfestoProspect_assignedToId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoProspect"
    ADD CONSTRAINT "EfestoProspect_assignedToId_fkey" FOREIGN KEY ("assignedToId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: EfestoProspect EfestoProspect_conversationId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoProspect"
    ADD CONSTRAINT "EfestoProspect_conversationId_fkey" FOREIGN KEY ("conversationId") REFERENCES public."Conversation"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: EfestoPublication EfestoPublication_createdById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoPublication"
    ADD CONSTRAINT "EfestoPublication_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: EfestoPublication EfestoPublication_videoScriptId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoPublication"
    ADD CONSTRAINT "EfestoPublication_videoScriptId_fkey" FOREIGN KEY ("videoScriptId") REFERENCES public."EfestoVideoScript"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: EfestoRetentionCommission EfestoRetentionCommission_originalCommId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoRetentionCommission"
    ADD CONSTRAINT "EfestoRetentionCommission_originalCommId_fkey" FOREIGN KEY ("originalCommId") REFERENCES public."EfestoCommission"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: EfestoRetentionCommission EfestoRetentionCommission_prospectId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoRetentionCommission"
    ADD CONSTRAINT "EfestoRetentionCommission_prospectId_fkey" FOREIGN KEY ("prospectId") REFERENCES public."EfestoProspect"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: EfestoRetentionCommission EfestoRetentionCommission_vendedorId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoRetentionCommission"
    ADD CONSTRAINT "EfestoRetentionCommission_vendedorId_fkey" FOREIGN KEY ("vendedorId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: EfestoVideoScript EfestoVideoScript_createdById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."EfestoVideoScript"
    ADD CONSTRAINT "EfestoVideoScript_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: FacebookGroup FacebookGroup_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."FacebookGroup"
    ADD CONSTRAINT "FacebookGroup_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: FilteredProspect FilteredProspect_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."FilteredProspect"
    ADD CONSTRAINT "FilteredProspect_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: FunnelStage FunnelStage_funnelId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."FunnelStage"
    ADD CONSTRAINT "FunnelStage_funnelId_fkey" FOREIGN KEY ("funnelId") REFERENCES public."SalesFunnel"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: GBPConfig GBPConfig_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GBPConfig"
    ADD CONSTRAINT "GBPConfig_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: GBPPost GBPPost_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GBPPost"
    ADD CONSTRAINT "GBPPost_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: GBPPost GBPPost_contentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GBPPost"
    ADD CONSTRAINT "GBPPost_contentId_fkey" FOREIGN KEY ("contentId") REFERENCES public."Content"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: GBPPost GBPPost_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GBPPost"
    ADD CONSTRAINT "GBPPost_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: GBPQueueItem GBPQueueItem_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GBPQueueItem"
    ADD CONSTRAINT "GBPQueueItem_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: GBPQueueItem GBPQueueItem_contentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GBPQueueItem"
    ADD CONSTRAINT "GBPQueueItem_contentId_fkey" FOREIGN KEY ("contentId") REFERENCES public."Content"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: GroupPostGroup GroupPostGroup_groupId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GroupPostGroup"
    ADD CONSTRAINT "GroupPostGroup_groupId_fkey" FOREIGN KEY ("groupId") REFERENCES public."FacebookGroup"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: GroupPostGroup GroupPostGroup_postId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GroupPostGroup"
    ADD CONSTRAINT "GroupPostGroup_postId_fkey" FOREIGN KEY ("postId") REFERENCES public."GroupPost"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: GroupPost GroupPost_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GroupPost"
    ADD CONSTRAINT "GroupPost_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: GroupPost GroupPost_contentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."GroupPost"
    ADD CONSTRAINT "GroupPost_contentId_fkey" FOREIGN KEY ("contentId") REFERENCES public."Content"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: IgHashtagSearch IgHashtagSearch_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."IgHashtagSearch"
    ADD CONSTRAINT "IgHashtagSearch_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: IgInteraction IgInteraction_prospectId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."IgInteraction"
    ADD CONSTRAINT "IgInteraction_prospectId_fkey" FOREIGN KEY ("prospectId") REFERENCES public."IgProspect"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: IgProspect IgProspect_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."IgProspect"
    ADD CONSTRAINT "IgProspect_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: IgProspect IgProspect_leadId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."IgProspect"
    ADD CONSTRAINT "IgProspect_leadId_fkey" FOREIGN KEY ("leadId") REFERENCES public."Lead"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: IgProspect IgProspect_pageId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."IgProspect"
    ADD CONSTRAINT "IgProspect_pageId_fkey" FOREIGN KEY ("pageId") REFERENCES public."MetaPage"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: IgProspectingCampaign IgProspectingCampaign_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."IgProspectingCampaign"
    ADD CONSTRAINT "IgProspectingCampaign_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ImpersonationLog ImpersonationLog_impersonatorId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ImpersonationLog"
    ADD CONSTRAINT "ImpersonationLog_impersonatorId_fkey" FOREIGN KEY ("impersonatorId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: ImpersonationLog ImpersonationLog_targetUserId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ImpersonationLog"
    ADD CONSTRAINT "ImpersonationLog_targetUserId_fkey" FOREIGN KEY ("targetUserId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: LeadActivity LeadActivity_createdById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."LeadActivity"
    ADD CONSTRAINT "LeadActivity_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: LeadActivity LeadActivity_leadId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."LeadActivity"
    ADD CONSTRAINT "LeadActivity_leadId_fkey" FOREIGN KEY ("leadId") REFERENCES public."Lead"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: LeadQualification LeadQualification_leadId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."LeadQualification"
    ADD CONSTRAINT "LeadQualification_leadId_fkey" FOREIGN KEY ("leadId") REFERENCES public."Lead"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: Lead Lead_assignedToId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Lead"
    ADD CONSTRAINT "Lead_assignedToId_fkey" FOREIGN KEY ("assignedToId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Lead Lead_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Lead"
    ADD CONSTRAINT "Lead_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: Lead Lead_conversationId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Lead"
    ADD CONSTRAINT "Lead_conversationId_fkey" FOREIGN KEY ("conversationId") REFERENCES public."Conversation"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Lead Lead_stageId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Lead"
    ADD CONSTRAINT "Lead_stageId_fkey" FOREIGN KEY ("stageId") REFERENCES public."FunnelStage"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: LessonBlock LessonBlock_lessonId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."LessonBlock"
    ADD CONSTRAINT "LessonBlock_lessonId_fkey" FOREIGN KEY ("lessonId") REFERENCES public."CourseLesson"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: LessonProgress LessonProgress_enrollmentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."LessonProgress"
    ADD CONSTRAINT "LessonProgress_enrollmentId_fkey" FOREIGN KEY ("enrollmentId") REFERENCES public."CourseEnrollment"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: LessonProgress LessonProgress_lessonId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."LessonProgress"
    ADD CONSTRAINT "LessonProgress_lessonId_fkey" FOREIGN KEY ("lessonId") REFERENCES public."CourseLesson"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: MarketplaceLead MarketplaceLead_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MarketplaceLead"
    ADD CONSTRAINT "MarketplaceLead_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: MarketplaceLead MarketplaceLead_listingId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MarketplaceLead"
    ADD CONSTRAINT "MarketplaceLead_listingId_fkey" FOREIGN KEY ("listingId") REFERENCES public."MarketplaceListing"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: MarketplaceLead MarketplaceLead_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MarketplaceLead"
    ADD CONSTRAINT "MarketplaceLead_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: MarketplaceListing MarketplaceListing_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MarketplaceListing"
    ADD CONSTRAINT "MarketplaceListing_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: MarketplaceListing MarketplaceListing_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MarketplaceListing"
    ADD CONSTRAINT "MarketplaceListing_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: MarketplaceListing MarketplaceListing_requestedBy_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MarketplaceListing"
    ADD CONSTRAINT "MarketplaceListing_requestedBy_fkey" FOREIGN KEY ("requestedBy") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: Message Message_conversationId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Message"
    ADD CONSTRAINT "Message_conversationId_fkey" FOREIGN KEY ("conversationId") REFERENCES public."Conversation"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: MetaCampaign MetaCampaign_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaCampaign"
    ADD CONSTRAINT "MetaCampaign_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: MetaCampaign MetaCampaign_contentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaCampaign"
    ADD CONSTRAINT "MetaCampaign_contentId_fkey" FOREIGN KEY ("contentId") REFERENCES public."Content"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: MetaCampaign MetaCampaign_pageId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaCampaign"
    ADD CONSTRAINT "MetaCampaign_pageId_fkey" FOREIGN KEY ("pageId") REFERENCES public."MetaPage"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: MetaCampaign MetaCampaign_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaCampaign"
    ADD CONSTRAINT "MetaCampaign_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: MetaConversation MetaConversation_agentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaConversation"
    ADD CONSTRAINT "MetaConversation_agentId_fkey" FOREIGN KEY ("agentId") REFERENCES public."Agent"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: MetaConversation MetaConversation_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaConversation"
    ADD CONSTRAINT "MetaConversation_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: MetaConversation MetaConversation_pageId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaConversation"
    ADD CONSTRAINT "MetaConversation_pageId_fkey" FOREIGN KEY ("pageId") REFERENCES public."MetaPage"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: MetaMessage MetaMessage_conversationId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaMessage"
    ADD CONSTRAINT "MetaMessage_conversationId_fkey" FOREIGN KEY ("conversationId") REFERENCES public."MetaConversation"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: MetaPublication MetaPublication_contentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaPublication"
    ADD CONSTRAINT "MetaPublication_contentId_fkey" FOREIGN KEY ("contentId") REFERENCES public."Content"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: MetaPublication MetaPublication_pageId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."MetaPublication"
    ADD CONSTRAINT "MetaPublication_pageId_fkey" FOREIGN KEY ("pageId") REFERENCES public."MetaPage"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: Notification Notification_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Notification"
    ADD CONSTRAINT "Notification_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: Notification Notification_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Notification"
    ADD CONSTRAINT "Notification_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: Payment Payment_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Payment"
    ADD CONSTRAINT "Payment_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: PortalProspect PortalProspect_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PortalProspect"
    ADD CONSTRAINT "PortalProspect_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: PortalProspect PortalProspect_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PortalProspect"
    ADD CONSTRAINT "PortalProspect_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: PortalPublication PortalPublication_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PortalPublication"
    ADD CONSTRAINT "PortalPublication_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: PortalPublication PortalPublication_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PortalPublication"
    ADD CONSTRAINT "PortalPublication_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: PortalSettings PortalSettings_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PortalSettings"
    ADD CONSTRAINT "PortalSettings_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: PortalSettings PortalSettings_featuredAgentProfileId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PortalSettings"
    ADD CONSTRAINT "PortalSettings_featuredAgentProfileId_fkey" FOREIGN KEY ("featuredAgentProfileId") REFERENCES public."AgentProfile"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: PropertyCreationSession PropertyCreationSession_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyCreationSession"
    ADD CONSTRAINT "PropertyCreationSession_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: PropertyCreationSession PropertyCreationSession_conversationId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyCreationSession"
    ADD CONSTRAINT "PropertyCreationSession_conversationId_fkey" FOREIGN KEY ("conversationId") REFERENCES public."Conversation"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: PropertyCreationSession PropertyCreationSession_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyCreationSession"
    ADD CONSTRAINT "PropertyCreationSession_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: PropertyCustomContent PropertyCustomContent_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyCustomContent"
    ADD CONSTRAINT "PropertyCustomContent_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: PropertyDeactivation PropertyDeactivation_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyDeactivation"
    ADD CONSTRAINT "PropertyDeactivation_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: PropertyDriveFolder PropertyDriveFolder_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyDriveFolder"
    ADD CONSTRAINT "PropertyDriveFolder_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: PropertyImage PropertyImage_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PropertyImage"
    ADD CONSTRAINT "PropertyImage_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: Property Property_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."Property"
    ADD CONSTRAINT "Property_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: PublicationSchedule PublicationSchedule_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."PublicationSchedule"
    ADD CONSTRAINT "PublicationSchedule_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: SalesFunnel SalesFunnel_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."SalesFunnel"
    ADD CONSTRAINT "SalesFunnel_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ScheduledFollowUp ScheduledFollowUp_conversationId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ScheduledFollowUp"
    ADD CONSTRAINT "ScheduledFollowUp_conversationId_fkey" FOREIGN KEY ("conversationId") REFERENCES public."Conversation"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ScheduledMessage ScheduledMessage_agentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ScheduledMessage"
    ADD CONSTRAINT "ScheduledMessage_agentId_fkey" FOREIGN KEY ("agentId") REFERENCES public."Agent"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: ServiceHire ServiceHire_approvedByUserId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ServiceHire"
    ADD CONSTRAINT "ServiceHire_approvedByUserId_fkey" FOREIGN KEY ("approvedByUserId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: ServiceHire ServiceHire_providerId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ServiceHire"
    ADD CONSTRAINT "ServiceHire_providerId_fkey" FOREIGN KEY ("providerId") REFERENCES public."ServiceProvider"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ServiceHire ServiceHire_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ServiceHire"
    ADD CONSTRAINT "ServiceHire_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: ServiceProviderRating ServiceProviderRating_providerId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ServiceProviderRating"
    ADD CONSTRAINT "ServiceProviderRating_providerId_fkey" FOREIGN KEY ("providerId") REFERENCES public."ServiceProvider"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ServiceProviderRating ServiceProviderRating_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ServiceProviderRating"
    ADD CONSTRAINT "ServiceProviderRating_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: ServiceProvider ServiceProvider_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ServiceProvider"
    ADD CONSTRAINT "ServiceProvider_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: ShortUrlClick ShortUrlClick_shortUrlId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ShortUrlClick"
    ADD CONSTRAINT "ShortUrlClick_shortUrlId_fkey" FOREIGN KEY ("shortUrlId") REFERENCES public."ShortUrl"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: ShortUrl ShortUrl_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ShortUrl"
    ADD CONSTRAINT "ShortUrl_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: ShortUrl ShortUrl_contentId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ShortUrl"
    ADD CONSTRAINT "ShortUrl_contentId_fkey" FOREIGN KEY ("contentId") REFERENCES public."Content"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: ShortUrl ShortUrl_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."ShortUrl"
    ADD CONSTRAINT "ShortUrl_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: SmartAdsAnalysis SmartAdsAnalysis_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."SmartAdsAnalysis"
    ADD CONSTRAINT "SmartAdsAnalysis_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: SmartAdsAnalysis SmartAdsAnalysis_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."SmartAdsAnalysis"
    ADD CONSTRAINT "SmartAdsAnalysis_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: SmartAdsProposal SmartAdsProposal_analysisId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."SmartAdsProposal"
    ADD CONSTRAINT "SmartAdsProposal_analysisId_fkey" FOREIGN KEY ("analysisId") REFERENCES public."SmartAdsAnalysis"(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: SmartAdsProposal SmartAdsProposal_campaignId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."SmartAdsProposal"
    ADD CONSTRAINT "SmartAdsProposal_campaignId_fkey" FOREIGN KEY ("campaignId") REFERENCES public."MetaCampaign"(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: UserClient UserClient_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."UserClient"
    ADD CONSTRAINT "UserClient_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: UserClient UserClient_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."UserClient"
    ADD CONSTRAINT "UserClient_userId_fkey" FOREIGN KEY ("userId") REFERENCES public."User"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: WhatsappGroupMessage WhatsappGroupMessage_groupId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappGroupMessage"
    ADD CONSTRAINT "WhatsappGroupMessage_groupId_fkey" FOREIGN KEY ("groupId") REFERENCES public."WhatsappGroup"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: WhatsappGroupPublication WhatsappGroupPublication_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappGroupPublication"
    ADD CONSTRAINT "WhatsappGroupPublication_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: WhatsappGroupPublication WhatsappGroupPublication_groupId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappGroupPublication"
    ADD CONSTRAINT "WhatsappGroupPublication_groupId_fkey" FOREIGN KEY ("groupId") REFERENCES public."WhatsappGroup"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: WhatsappGroupPublication WhatsappGroupPublication_propertyId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappGroupPublication"
    ADD CONSTRAINT "WhatsappGroupPublication_propertyId_fkey" FOREIGN KEY ("propertyId") REFERENCES public."Property"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: WhatsappGroup WhatsappGroup_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappGroup"
    ADD CONSTRAINT "WhatsappGroup_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: WhatsappGroup WhatsappGroup_instanceId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappGroup"
    ADD CONSTRAINT "WhatsappGroup_instanceId_fkey" FOREIGN KEY ("instanceId") REFERENCES public."WhatsappInstance"(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: WhatsappInstance WhatsappInstance_clientId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public."WhatsappInstance"
    ADD CONSTRAINT "WhatsappInstance_clientId_fkey" FOREIGN KEY ("clientId") REFERENCES public."Client"(id) ON UPDATE CASCADE ON DELETE SET NULL;