# -*- coding: utf-8 -*-
from core.utils.db import db
from core.utils.packages.session import BackupOnDeleteMixin
from sqlalchemy.orm import backref
from sqlalchemy import BigInteger
from datetime import datetime, timezone 
from sqlalchemy import desc, func, String, case, literal_column  
from sqlalchemy.ext.hybrid import hybrid_property 
from sqlalchemy.sql.expression import null 

class Property(db.Model, BackupOnDeleteMixin):
    __tablename__ = 'property'
    id = db.Column(db.Integer, primary_key=True)
    Cadastre_id = db.Column(db.Integer, db.ForeignKey('blob.id'), nullable=True)
    Cadastre = db.relationship('Blob', foreign_keys=[Cadastre_id], lazy='joined')
    CondominiumRegulation_id = db.Column(db.Integer, db.ForeignKey('blob.id'), nullable=True)
    CondominiumRegulation = db.relationship('Blob', foreign_keys=[CondominiumRegulation_id], lazy='joined')
    LandUse_id = db.Column(db.Integer, db.ForeignKey('blob.id'), nullable=True)
    LandUse = db.relationship('Blob', foreign_keys=[LandUse_id], lazy='joined')
    RegistrationDocument_id = db.Column(db.Integer, db.ForeignKey('blob.id'), nullable=True)
    RegistrationDocument = db.relationship('Blob', foreign_keys=[RegistrationDocument_id], lazy='joined')
    Featured = db.Column(db.Boolean())
    ForRent = db.Column(db.Boolean())
    ForSale = db.Column(db.Boolean())
    ForVacationRental = db.Column(db.Boolean())
    PetFriendly = db.Column(db.Boolean())
    ProfessionalPictures = db.Column(db.Boolean())
    ShowInRecent = db.Column(db.Boolean())
    Agent = db.Column(db.Integer())
    AmmenitiesCommunity_id = db.Column(db.Integer, db.ForeignKey('ammenity.id', ondelete='SET NULL'), nullable=True)
    AmmenitiesCommunity = db.relationship('Ammenity', foreign_keys=[AmmenitiesCommunity_id], backref=backref('properties', order_by=lambda: desc(Property.id),passive_deletes=True))
    Features_id = db.Column(db.Integer, db.ForeignKey('feature.id', ondelete='SET NULL'), nullable=True)
    Features = db.relationship('Feature', foreign_keys=[Features_id], backref=backref('properties', order_by=lambda: desc(Property.id),passive_deletes=True))
    Lifestyles_id = db.Column(db.Integer, db.ForeignKey('lifestyle.id', ondelete='SET NULL'), nullable=True)
    Lifestyles = db.relationship('Lifestyle', foreign_keys=[Lifestyles_id], backref=backref('properties', order_by=lambda: desc(Property.id),passive_deletes=True))
    Neighborhood_id = db.Column(db.Integer, db.ForeignKey('neighborhood.id', ondelete='SET NULL'), nullable=True)
    Neighborhood = db.relationship('Neighborhood', foreign_keys=[Neighborhood_id], backref=backref('properties', order_by=lambda: desc(Property.id),passive_deletes=True))
    NewFeature_id = db.Column(db.Integer, db.ForeignKey('newfeature.id', ondelete='SET NULL'), nullable=True)
    NewFeature = db.relationship('Newfeature', foreign_keys=[NewFeature_id], backref=backref('properties', order_by=lambda: desc(Property.id),passive_deletes=True))
    NewPropertyType_id = db.Column(db.Integer, db.ForeignKey('propertyclassification.id', ondelete='SET NULL'), nullable=True)
    NewPropertyType = db.relationship('Propertyclassification', foreign_keys=[NewPropertyType_id], backref=backref('properties', order_by=lambda: desc(Property.id),passive_deletes=True))
    OwnerRecord_id = db.Column(db.Integer, db.ForeignKey('owner.id', ondelete='SET NULL'), nullable=True)
    OwnerRecord = db.relationship('Owner', foreign_keys=[OwnerRecord_id], backref=backref('properties', order_by=lambda: desc(Property.id),passive_deletes=True))
    PropertyLocation = db.Column(db.String(255))
    PropertyLocationFinal_id = db.Column(db.Integer, db.ForeignKey('location.id', ondelete='SET NULL'), nullable=True)
    PropertyLocationFinal = db.relationship('Location', foreign_keys=[PropertyLocationFinal_id], backref=backref('properties', order_by=lambda: desc(Property.id),passive_deletes=True))
    PropertySublocation_id = db.Column(db.Integer, db.ForeignKey('propertylocation.id', ondelete='SET NULL'), nullable=True)
    PropertySublocation = db.relationship('Propertylocation', foreign_keys=[PropertySublocation_id], backref=backref('properties', order_by=lambda: desc(Property.id),passive_deletes=True))
    PropertyType = db.Column(db.String(255))
    DateOfExit = db.Column(db.Date())
    DateOfPublication = db.Column(db.Date())
    CorreoPrueba = db.Column(db.String(255))
    Bathrooms = db.Column(db.String(255))
    ConstructionArea = db.Column(db.String(255))
    Floors = db.Column(db.String(255))
    GarageSize = db.Column(db.String(255))
    LotArea = db.Column(db.String(255))
    Position = db.Column(db.String(255))
    MetersPer = db.Column(db.String(255))
    StorageArea = db.Column(db.String(255))
    Image_id = db.Column(db.Integer, db.ForeignKey('blob.id'), nullable=True)
    Image = db.relationship('Blob', foreign_keys=[Image_id], lazy='joined')
    MaintenanceQuota = db.Column(BigInteger(), nullable=True)
    MinPrice = db.Column(BigInteger(), nullable=True)
    RentalPrice = db.Column(BigInteger(), nullable=True)
    VacationRentalPrice = db.Column(BigInteger(), nullable=True)
    AgentContactCount = db.Column(db.Integer())
    Rooms = db.Column(db.Integer())
    CadastreNumber = db.Column(db.Integer())
    EmailRequestCount = db.Column(db.Integer())
    IndirectViewCount = db.Column(db.Integer())
    NumberOfImages = db.Column(db.Integer())
    ParkingSpaces = db.Column(db.Integer())
    ServiceRooms = db.Column(db.Integer())
    SquareMeters = db.Column(db.Integer())
    VisitCount = db.Column(db.Integer())
    VisitCountHold = db.Column(db.Integer())
    YearBuilt = db.Column(db.Integer())
    YearOfRemodeling = db.Column(db.Integer())
    ContractType = db.Column(db.String(255))
    DirectOrIndirect = db.Column(db.String(255))
    CompositeID = db.Column(db.String(255))
    Craiglist = db.Column(db.String(255))
    CustomerAgentContact = db.Column(db.String(255))
    CustomerInfoSent = db.Column(db.String(255))
    Encuentra24 = db.Column(db.String(255))
    Flooring = db.Column(db.String(255))
    FolioNoRef = db.Column(db.String(255))
    ApplianceImport = db.Column(db.String(255))
    AttachmentUrlsImport = db.Column(db.String(255))
    AvailabilityImport = db.Column(db.String(255))
    CommunityImport = db.Column(db.Text())
    ImportFeatures = db.Column(db.Text())
    ImportField4 = db.Column(db.Text())
    FurnishedImport = db.Column(db.String(255))
    ImportLifestyles = db.Column(db.Text())
    LocationImport = db.Column(db.String(255))
    ImportMaintenanceFee = db.Column(db.Text())
    OwnerEmailImport = db.Column(db.Text())
    OwnerNameImport = db.Column(db.Text())
    OwnerPhoneImport = db.Column(db.String(255))
    AgentResponsibleImport = db.Column(db.String(255))
    RealtorEmailImport = db.Column(db.Text())
    RealtorNameImport = db.Column(db.Text())
    RealtorPhoneImport = db.Column(db.Text())
    ImportRentalPrice = db.Column(db.Text())
    ImportSalePrice = db.Column(db.Text())
    StatusImport = db.Column(db.String(255))
    SublocationImport = db.Column(db.Text())
    TypeImport = db.Column(db.Text())
    ImportWERCRAgent = db.Column(db.Text())
    IndependentAgentEmail = db.Column(db.String(255))
    IndependentAgentNames = db.Column(db.String(255))
    IndependentAgentPhone = db.Column(db.String(255))
    Inmotico = db.Column(db.String(255))
    Latitude = db.Column(db.String(255))
    Longitude = db.Column(db.String(255))
    Observaciones = db.Column(db.String(255))
    OldUrl = db.Column(db.Text())
    OLX = db.Column(db.Text())
    OwnerEmail = db.Column(db.String(255))
    OwnerName = db.Column(db.String(255))
    OwnerPhones = db.Column(db.String(255))
    PdfFileImport = db.Column(db.Text())
    PropertyLabel = db.Column(db.String(255))
    PropertyName = db.Column(db.String(255))
    PropertyStatus = db.Column(db.String(255))
    ShortVideoID = db.Column(db.String(255))
    SocialMedia = db.Column(db.String(255))
    Comments = db.Column(db.Text())
    CommisionValue = db.Column(db.String(255))
    Description = db.Column(db.Text())
    DescriptionEs = db.Column(db.Text())
    ExactAddress = db.Column(db.Text())
    HouseNumber = db.Column(db.String(255))
    ImageUrlsImport = db.Column(db.Text())
    LInksToExternalPlatforms = db.Column(db.Text())
    LinksToOwnPlatforms = db.Column(db.Text())
    ProjectName = db.Column(db.Text())
    Roofing = db.Column(db.Text())
    Title = db.Column(db.Text())
    TitleEs = db.Column(db.Text())
    YoutubeUrl = db.Column(db.Text())
    allImages = db.Column(db.Text())
    createdby_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    modifiedby_id = db.Column(db.Integer, db.ForeignKey('user.id'))
    createdby = db.relationship('User', backref='created_properties', foreign_keys=[createdby_id])
    modifiedby = db.relationship('User', backref='modified_properties', foreign_keys=[modifiedby_id])
    created_at = db.Column(db.DateTime, default=lambda: datetime.now(timezone.utc))
    updated_at = db.Column(db.DateTime, default=lambda: datetime.now(timezone.utc), onupdate=lambda: datetime.now(timezone.utc))


    @hybrid_property
    def full_repr(self):
        result = f'''ID: {self.id if self.id is not None else ''}- {self.PropertyLabel if self.PropertyLabel is not None else ''}'''
        return result.strip()

    @full_repr.expression
    def full_repr(cls):
        return (
            literal_column("") + literal_column("'ID: '")  + func.coalesce(cls.id, literal_column("''"))  + literal_column("''") + literal_column("'- '")  + func.coalesce(cls.PropertyLabel, literal_column("''"))  + literal_column("''")
        )

    def __repr__(self) -> str:
        return self.full_repr 
    __default_ordering__ = [desc('id')]

    __table_args__ = {
        "mysql_charset": "utf8mb4",
        "mysql_collate": "utf8mb4_unicode_ci",
    }


def get_fields():
    fields = {'Cadastre': {'id': 1, 'type': 'blob', 'name': 'Cadastre', 'maxlength': None, 'connected_table': None, 'label': 'Cadastre', 'input': 'blob', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'CondominiumRegulation': {'id': 2, 'type': 'blob', 'name': 'CondominiumRegulation', 'maxlength': None, 'connected_table': None, 'label': 'Condominium Regulation', 'input': 'blob', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'LandUse': {'id': 3, 'type': 'blob', 'name': 'LandUse', 'maxlength': None, 'connected_table': None, 'label': 'Land Use', 'input': 'blob', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'RegistrationDocument': {'id': 4, 'type': 'blob', 'name': 'RegistrationDocument', 'maxlength': None, 'connected_table': None, 'label': 'Registration Document', 'input': 'blob', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Featured': {'id': 5, 'type': 'Boolean', 'name': 'Featured', 'maxlength': None, 'connected_table': None, 'label': 'Featured', 'input': 'boolean', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ForRent': {'id': 6, 'type': 'Boolean', 'name': 'ForRent', 'maxlength': None, 'connected_table': None, 'label': 'For Rent', 'input': 'boolean', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ForSale': {'id': 7, 'type': 'Boolean', 'name': 'ForSale', 'maxlength': None, 'connected_table': None, 'label': 'For Sale', 'input': 'boolean', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ForVacationRental': {'id': 8, 'type': 'Boolean', 'name': 'ForVacationRental', 'maxlength': None, 'connected_table': None, 'label': 'For Vacation Rental', 'input': 'boolean', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'PetFriendly': {'id': 9, 'type': 'Boolean', 'name': 'PetFriendly', 'maxlength': None, 'connected_table': None, 'label': 'Pet Friendly', 'input': 'boolean', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ProfessionalPictures': {'id': 10, 'type': 'Boolean', 'name': 'ProfessionalPictures', 'maxlength': None, 'connected_table': None, 'label': 'Professional Pictures', 'input': 'boolean', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ShowInRecent': {'id': 11, 'type': 'Boolean', 'name': 'ShowInRecent', 'maxlength': None, 'connected_table': None, 'label': 'Show In Recent', 'input': 'boolean', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Agent': {'id': 12, 'type': 'Integer', 'name': 'Agent', 'maxlength': None, 'connected_table': None, 'label': 'Agent', 'input': 'connected_table', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'AmmenitiesCommunity': {'id': 13, 'type': 'connected_table', 'name': 'AmmenitiesCommunity', 'maxlength': None, 'connected_table': 2, 'label': 'Ammenities', 'input': 'connected_table', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Features': {'id': 14, 'type': 'connected_table', 'name': 'Features', 'maxlength': None, 'connected_table': 3, 'label': 'Features', 'input': 'connected_table', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Lifestyles': {'id': 15, 'type': 'connected_table', 'name': 'Lifestyles', 'maxlength': None, 'connected_table': 4, 'label': 'Lifestyles', 'input': 'connected_table', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Neighborhood': {'id': 16, 'type': 'connected_table', 'name': 'Neighborhood', 'maxlength': None, 'connected_table': 5, 'label': 'Neighborhood', 'input': 'connected_table', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'NewFeature': {'id': 17, 'type': 'connected_table', 'name': 'NewFeature', 'maxlength': None, 'connected_table': 6, 'label': 'New Feature', 'input': 'connected_table', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'NewPropertyType': {'id': 18, 'type': 'connected_table', 'name': 'NewPropertyType', 'maxlength': None, 'connected_table': 7, 'label': 'New Property Type', 'input': 'connected_table', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'OwnerRecord': {'id': 19, 'type': 'connected_table', 'name': 'OwnerRecord', 'maxlength': None, 'connected_table': 8, 'label': 'Owner', 'input': 'connected_table', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'PropertyLocation': {'id': 20, 'type': 'String', 'name': 'PropertyLocation', 'maxlength': None, 'connected_table': None, 'label': 'Property Location', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'PropertyLocationFinal': {'id': 21, 'type': 'connected_table', 'name': 'PropertyLocationFinal', 'maxlength': None, 'connected_table': 9, 'label': 'Property Location Final', 'input': 'connected_table', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'PropertySublocation': {'id': 22, 'type': 'connected_table', 'name': 'PropertySublocation', 'maxlength': None, 'connected_table': 10, 'label': 'Property Sublocation', 'input': 'connected_table', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'PropertyType': {'id': 23, 'type': 'String', 'name': 'PropertyType', 'maxlength': None, 'connected_table': None, 'label': 'Property Type', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'DateOfExit': {'id': 24, 'type': 'Date', 'name': 'DateOfExit', 'maxlength': None, 'connected_table': None, 'label': 'Date Of Exit', 'input': 'date', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'DateOfPublication': {'id': 25, 'type': 'Date', 'name': 'DateOfPublication', 'maxlength': None, 'connected_table': None, 'label': 'Date Of Publication', 'input': 'date', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'CorreoPrueba': {'id': 26, 'type': 'String', 'name': 'CorreoPrueba', 'maxlength': None, 'connected_table': None, 'label': 'Correo Prueba', 'input': 'email', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Bathrooms': {'id': 27, 'type': 'String', 'name': 'Bathrooms', 'maxlength': None, 'connected_table': None, 'label': 'Bathrooms', 'input': 'float', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ConstructionArea': {'id': 28, 'type': 'String', 'name': 'ConstructionArea', 'maxlength': None, 'connected_table': None, 'label': 'Construction Area', 'input': 'float', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Floors': {'id': 29, 'type': 'String', 'name': 'Floors', 'maxlength': None, 'connected_table': None, 'label': 'Floors', 'input': 'float', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'GarageSize': {'id': 30, 'type': 'String', 'name': 'GarageSize', 'maxlength': None, 'connected_table': None, 'label': 'Garage Size', 'input': 'float', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'LotArea': {'id': 31, 'type': 'String', 'name': 'LotArea', 'maxlength': None, 'connected_table': None, 'label': 'Lot Area', 'input': 'float', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Position': {'id': 32, 'type': 'String', 'name': 'Position', 'maxlength': None, 'connected_table': None, 'label': 'Position', 'input': 'float', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'MetersPer': {'id': 33, 'type': 'String', 'name': 'MetersPer', 'maxlength': None, 'connected_table': None, 'label': 'Price Per Meter', 'input': 'float', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'StorageArea': {'id': 34, 'type': 'String', 'name': 'StorageArea', 'maxlength': None, 'connected_table': None, 'label': 'Storage Area', 'input': 'float', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Image': {'id': 35, 'type': 'blob', 'name': 'Image', 'maxlength': None, 'connected_table': None, 'label': 'Image', 'input': 'Image', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'MaintenanceQuota': {'id': 36, 'type': 'Money', 'name': 'MaintenanceQuota', 'maxlength': None, 'connected_table': None, 'label': 'Maintenance Quota', 'input': 'money', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'MinPrice': {'id': 37, 'type': 'Money', 'name': 'MinPrice', 'maxlength': None, 'connected_table': None, 'label': 'Min Price', 'input': 'money', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'RentalPrice': {'id': 38, 'type': 'Money', 'name': 'RentalPrice', 'maxlength': None, 'connected_table': None, 'label': 'Rental Price', 'input': 'money', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'VacationRentalPrice': {'id': 39, 'type': 'Money', 'name': 'VacationRentalPrice', 'maxlength': None, 'connected_table': None, 'label': 'Vacation Rental Price', 'input': 'money', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'AgentContactCount': {'id': 40, 'type': 'Integer', 'name': 'AgentContactCount', 'maxlength': None, 'connected_table': None, 'label': 'Agent Contact Count', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Rooms': {'id': 41, 'type': 'Integer', 'name': 'Rooms', 'maxlength': None, 'connected_table': None, 'label': 'Bedrooms', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'CadastreNumber': {'id': 42, 'type': 'Integer', 'name': 'CadastreNumber', 'maxlength': None, 'connected_table': None, 'label': 'Cadastre Number', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'EmailRequestCount': {'id': 43, 'type': 'Integer', 'name': 'EmailRequestCount', 'maxlength': None, 'connected_table': None, 'label': 'Email Request Count', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'IndirectViewCount': {'id': 44, 'type': 'Integer', 'name': 'IndirectViewCount', 'maxlength': None, 'connected_table': None, 'label': 'Indirect View Count', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'NumberOfImages': {'id': 45, 'type': 'Integer', 'name': 'NumberOfImages', 'maxlength': None, 'connected_table': None, 'label': 'Number Of Images', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ParkingSpaces': {'id': 46, 'type': 'Integer', 'name': 'ParkingSpaces', 'maxlength': None, 'connected_table': None, 'label': 'Parking Spaces', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ServiceRooms': {'id': 47, 'type': 'Integer', 'name': 'ServiceRooms', 'maxlength': None, 'connected_table': None, 'label': 'Service Rooms', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'SquareMeters': {'id': 48, 'type': 'Integer', 'name': 'SquareMeters', 'maxlength': None, 'connected_table': None, 'label': 'Square Meters', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'VisitCount': {'id': 49, 'type': 'Integer', 'name': 'VisitCount', 'maxlength': None, 'connected_table': None, 'label': 'Visit Count', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'VisitCountHold': {'id': 50, 'type': 'Integer', 'name': 'VisitCountHold', 'maxlength': None, 'connected_table': None, 'label': 'Visit Count Hold', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'YearBuilt': {'id': 51, 'type': 'Integer', 'name': 'YearBuilt', 'maxlength': None, 'connected_table': None, 'label': 'Year Built', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'YearOfRemodeling': {'id': 52, 'type': 'Integer', 'name': 'YearOfRemodeling', 'maxlength': None, 'connected_table': None, 'label': 'Year Of Remodeling', 'input': 'number', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ContractType': {'id': 53, 'type': 'String', 'name': 'ContractType', 'maxlength': None, 'connected_table': None, 'label': 'Contract Type', 'input': 'select', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': '{\r\n"General":"1",\r\n"Preferencial":"2",\r\n"Exclusivo":"3"\r\n}', 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'DirectOrIndirect': {'id': 54, 'type': 'String', 'name': 'DirectOrIndirect', 'maxlength': None, 'connected_table': None, 'label': 'Direct Or Indirect', 'input': 'select', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': '{\r\n"Direct":"D",\r\n"Indirect":"I"\r\n}', 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'CompositeID': {'id': 55, 'type': 'String', 'name': 'CompositeID', 'maxlength': None, 'connected_table': None, 'label': 'Composite ID', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Craiglist': {'id': 56, 'type': 'String', 'name': 'Craiglist', 'maxlength': None, 'connected_table': None, 'label': 'Craiglist', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'CustomerAgentContact': {'id': 57, 'type': 'String', 'name': 'CustomerAgentContact', 'maxlength': None, 'connected_table': None, 'label': 'Customer Agent Contact', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'CustomerInfoSent': {'id': 58, 'type': 'String', 'name': 'CustomerInfoSent', 'maxlength': None, 'connected_table': None, 'label': 'Customer Info Sent', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Encuentra24': {'id': 59, 'type': 'String', 'name': 'Encuentra24', 'maxlength': None, 'connected_table': None, 'label': 'Encuentra 24', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Flooring': {'id': 60, 'type': 'String', 'name': 'Flooring', 'maxlength': None, 'connected_table': None, 'label': 'Flooring', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'FolioNoRef': {'id': 61, 'type': 'String', 'name': 'FolioNoRef', 'maxlength': None, 'connected_table': None, 'label': 'Folio Number', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ApplianceImport': {'id': 62, 'type': 'String', 'name': 'ApplianceImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Appliances', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'AttachmentUrlsImport': {'id': 63, 'type': 'String', 'name': 'AttachmentUrlsImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Attachment Urls', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'AvailabilityImport': {'id': 64, 'type': 'String', 'name': 'AvailabilityImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Availability', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'CommunityImport': {'id': 65, 'type': 'Text', 'name': 'CommunityImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Community', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ImportFeatures': {'id': 66, 'type': 'Text', 'name': 'ImportFeatures', 'maxlength': None, 'connected_table': None, 'label': 'Import Features', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ImportField4': {'id': 67, 'type': 'Text', 'name': 'ImportField4', 'maxlength': None, 'connected_table': None, 'label': 'Import Field 4', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'FurnishedImport': {'id': 68, 'type': 'String', 'name': 'FurnishedImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Furnished', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ImportLifestyles': {'id': 69, 'type': 'Text', 'name': 'ImportLifestyles', 'maxlength': None, 'connected_table': None, 'label': 'Import Lifestyles', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'LocationImport': {'id': 70, 'type': 'String', 'name': 'LocationImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Location', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ImportMaintenanceFee': {'id': 71, 'type': 'Text', 'name': 'ImportMaintenanceFee', 'maxlength': None, 'connected_table': None, 'label': 'Import Maintenance Fee', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'OwnerEmailImport': {'id': 72, 'type': 'Text', 'name': 'OwnerEmailImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Owner Email', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'OwnerNameImport': {'id': 73, 'type': 'Text', 'name': 'OwnerNameImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Owner Name', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'OwnerPhoneImport': {'id': 74, 'type': 'String', 'name': 'OwnerPhoneImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Owner Phone', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'AgentResponsibleImport': {'id': 75, 'type': 'String', 'name': 'AgentResponsibleImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Realtor Agent', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'RealtorEmailImport': {'id': 76, 'type': 'Text', 'name': 'RealtorEmailImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Realtor Email', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'RealtorNameImport': {'id': 77, 'type': 'Text', 'name': 'RealtorNameImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Realtor Name', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'RealtorPhoneImport': {'id': 78, 'type': 'Text', 'name': 'RealtorPhoneImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Realtor Phone', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ImportRentalPrice': {'id': 79, 'type': 'Text', 'name': 'ImportRentalPrice', 'maxlength': None, 'connected_table': None, 'label': 'Import Rental Price', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ImportSalePrice': {'id': 80, 'type': 'Text', 'name': 'ImportSalePrice', 'maxlength': None, 'connected_table': None, 'label': 'Import Sale Price', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'StatusImport': {'id': 81, 'type': 'String', 'name': 'StatusImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Status', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'SublocationImport': {'id': 82, 'type': 'Text', 'name': 'SublocationImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Sublocation', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'TypeImport': {'id': 83, 'type': 'Text', 'name': 'TypeImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Type', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ImportWERCRAgent': {'id': 84, 'type': 'Text', 'name': 'ImportWERCRAgent', 'maxlength': None, 'connected_table': None, 'label': 'Import WERCR Agent', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'IndependentAgentEmail': {'id': 85, 'type': 'String', 'name': 'IndependentAgentEmail', 'maxlength': None, 'connected_table': None, 'label': 'Independent Agent Email', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'IndependentAgentNames': {'id': 86, 'type': 'String', 'name': 'IndependentAgentNames', 'maxlength': None, 'connected_table': None, 'label': 'Independent Agent Name', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'IndependentAgentPhone': {'id': 87, 'type': 'String', 'name': 'IndependentAgentPhone', 'maxlength': None, 'connected_table': None, 'label': 'Independent Agent Phone', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Inmotico': {'id': 88, 'type': 'String', 'name': 'Inmotico', 'maxlength': None, 'connected_table': None, 'label': 'Inmotico', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Latitude': {'id': 89, 'type': 'String', 'name': 'Latitude', 'maxlength': None, 'connected_table': None, 'label': 'Latitude', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Longitude': {'id': 90, 'type': 'String', 'name': 'Longitude', 'maxlength': None, 'connected_table': None, 'label': 'Longitude', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Observaciones': {'id': 91, 'type': 'String', 'name': 'Observaciones', 'maxlength': None, 'connected_table': None, 'label': 'Observaciones', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'OldUrl': {'id': 92, 'type': 'Text', 'name': 'OldUrl', 'maxlength': None, 'connected_table': None, 'label': 'Old Url', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'OLX': {'id': 93, 'type': 'Text', 'name': 'OLX', 'maxlength': None, 'connected_table': None, 'label': 'OLX', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'OwnerEmail': {'id': 94, 'type': 'String', 'name': 'OwnerEmail', 'maxlength': None, 'connected_table': None, 'label': 'Owner Email', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'OwnerName': {'id': 95, 'type': 'String', 'name': 'OwnerName', 'maxlength': None, 'connected_table': None, 'label': 'Owner Name', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'OwnerPhones': {'id': 96, 'type': 'String', 'name': 'OwnerPhones', 'maxlength': None, 'connected_table': None, 'label': 'Owner Phone', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'PdfFileImport': {'id': 97, 'type': 'Text', 'name': 'PdfFileImport', 'maxlength': None, 'connected_table': None, 'label': 'Pdf File (Import)', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'PropertyLabel': {'id': 98, 'type': 'String', 'name': 'PropertyLabel', 'maxlength': None, 'connected_table': None, 'label': 'Property Label', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'PropertyName': {'id': 99, 'type': 'String', 'name': 'PropertyName', 'maxlength': None, 'connected_table': None, 'label': 'Property Name', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'PropertyStatus': {'id': 100, 'type': 'String', 'name': 'PropertyStatus', 'maxlength': None, 'connected_table': None, 'label': 'Property Status', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ShortVideoID': {'id': 101, 'type': 'String', 'name': 'ShortVideoID', 'maxlength': None, 'connected_table': None, 'label': 'Short Video ID', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'SocialMedia': {'id': 102, 'type': 'String', 'name': 'SocialMedia', 'maxlength': None, 'connected_table': None, 'label': 'Social Media', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Comments': {'id': 103, 'type': 'Text', 'name': 'Comments', 'maxlength': None, 'connected_table': None, 'label': 'Comments', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'CommisionValue': {'id': 104, 'type': 'String', 'name': 'CommisionValue', 'maxlength': None, 'connected_table': None, 'label': 'Commision Value', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Description': {'id': 105, 'type': 'Text', 'name': 'Description', 'maxlength': None, 'connected_table': None, 'label': 'Description', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'DescriptionEs': {'id': 106, 'type': 'Text', 'name': 'DescriptionEs', 'maxlength': None, 'connected_table': None, 'label': 'Description (Es)', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ExactAddress': {'id': 107, 'type': 'Text', 'name': 'ExactAddress', 'maxlength': None, 'connected_table': None, 'label': 'Exact Address', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'HouseNumber': {'id': 108, 'type': 'String', 'name': 'HouseNumber', 'maxlength': None, 'connected_table': None, 'label': 'House Number', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ImageUrlsImport': {'id': 109, 'type': 'Text', 'name': 'ImageUrlsImport', 'maxlength': None, 'connected_table': None, 'label': 'Import Image Urls', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'LInksToExternalPlatforms': {'id': 110, 'type': 'Text', 'name': 'LInksToExternalPlatforms', 'maxlength': None, 'connected_table': None, 'label': 'LInks To External Platforms', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'LinksToOwnPlatforms': {'id': 111, 'type': 'Text', 'name': 'LinksToOwnPlatforms', 'maxlength': None, 'connected_table': None, 'label': 'Links To Own Platforms', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'ProjectName': {'id': 112, 'type': 'Text', 'name': 'ProjectName', 'maxlength': None, 'connected_table': None, 'label': 'Project Name', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Roofing': {'id': 113, 'type': 'Text', 'name': 'Roofing', 'maxlength': None, 'connected_table': None, 'label': 'Roofing', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'Title': {'id': 114, 'type': 'Text', 'name': 'Title', 'maxlength': None, 'connected_table': None, 'label': 'Title', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'TitleEs': {'id': 115, 'type': 'Text', 'name': 'TitleEs', 'maxlength': None, 'connected_table': None, 'label': 'Title (Es)', 'input': 'text', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'YoutubeUrl': {'id': 116, 'type': 'Text', 'name': 'YoutubeUrl', 'maxlength': None, 'connected_table': None, 'label': 'Youtube Url', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': False, 'calculate_file': None, 'calculate_function': None, 'helper': None}, 'allImages': {'id': 121, 'type': 'Text', 'name': 'allImages', 'maxlength': None, 'connected_table': None, 'label': 'Todas las Imágenes', 'input': 'textarea', 'sort': None, 'required': False, 'hidden': False, 'publicBlob': False, 'default_value': None, 'select_options': None, 'extraclass': None, 'allowHtml': False, 'hasManyValues': False, 'readOnly': True, 'calculate_file': None, 'calculate_function': None, 'helper': None}}
    return fields


def get_permissions():
    permissions = {}
    return permissions