Tables
Back to Dashboard| # | Name | Alias | Descr |
|---|---|---|---|
| 1 | AccessEventLog | AEL | Log of access to selected recources (e.g. owner logins) |
| 2 | AccessEventType | AET | Types of events to log for access to selected recources (e.g. owner logins) |
| 3 | activities | AC | |
| 4 | activities_category | ACC | |
| 5 | AdminICalImport | AII | Import staging for availability data via iCal imports |
| 6 | amenities | AM | |
| 7 | amenities_category | AMC | |
| 8 | AmenityFilter | AMF | Filter flags for pre-defined amenity filters |
| 9 | bathroom | BTH | |
| 10 | bedroom | BED | |
| 11 | blog_comments_dnu | ||
| 12 | BlogComments | BLC | Comments from the public on blogs created by site admin |
| 13 | Blogs | BLG | Data for blogs created by the site admin and available to the public |
| 14 | CalendarSeason | CLS | Calendar seasons based on solstices and equinoxes |
| 15 | CancellationPolicy | CNP | descriptive text for the cancellation policy tag used by an Owner for their Properties |
| 16 | category | CAT | |
| 17 | CityLocationData | CLD | |
| 18 | DataFieldType | DFT | Type of JSON Data Field Types for various JSON objects stored or generated |
| 19 | DestinFloridaMagazine | DFM | List of properties to use for the DestinFlorida Magazine export |
| 20 | DestinFloridaMagazine_20221018 | DFM | |
| 21 | DestinFloridaMagazine_20230112 | DFM | |
| 22 | DestinFloridaMagazine_20230329 | DFM | List of properties to use for the DestinFlorida Magazine export |
| 23 | ECBYOPropertiesTempImport | ||
| 24 | ErrorLog_BPAL | ELG | Error log for capturing any error messages that arise from receiving requests with the BookingPal API |
| 25 | EventContact | EVC | List of those who submitted a contact in response to a particular event or occurrence |
| 26 | ExternalListingNote | ELN | Log of notes about external data integrations for any given Site, Owner or Property |
| 27 | ExternalListingSite | ELS | List of external listing sites, booking channels and hospitality software platforms |
| 28 | ExternalListingSite_NEXT | ELSN | |
| 29 | ExternalSiteRecordType | ERT | Types of records imports for those sources that bring in all property data in one chunk (not broken down by property), typically for a single owner account within a Source |
| 30 | extra_fee | EF | |
| 31 | extra_fee_tmp | EXT | not intended for production use |
| 32 | fee_notes | FEN | |
| 33 | HelpVideo | HVD | Help videos for site users |
| 34 | HTGAmenity | HTA | Amenity names used in the HomeToGo export process |
| 35 | HTGPropertyType | HPT | Property types used in the HomeToGo export process |
| 36 | ICalImportLog | IIL | Log of iCal imports for non_IVOL users |
| 37 | ImageType | ITP | Lookup for the mapping to the full relative path to an image in the property photo gallery or a functional size bracket for image URLs |
| 38 | ImageTypePath | ITP | Lookup for the mapping to the full relative path to an image in the property photo gallery |
| 39 | ImportDate | IMD | Daily availability data imported from individual Properties (superset of PropertyBooking) - this will be used for loading the PropertyDateAvailability to support the UI for BookingPal (may be expanded to others in the future) |
| 40 | ImportImage | IMI | Images imported from/photos for individual Properties |
| 41 | ImportPropertyRateLoSRaw | LRW | Raw data dump of property rates in the Length of Stay format from external listing data |
| 42 | ImportRate | IMR | Standard rate data imported from individual Properties (rates not targeted for the LoS format) - this will be used for loading the PropertyRateLoS table to support quotes |
| 43 | InsuranceProduct | INS | Insurance Products |
| 44 | InternalLink | LNK | Site pages and the internal links to display on it |
| 45 | InternalLink_Sample | ||
| 46 | InternalLinkMaster | ILM | Master list of site URLs and link texts |
| 47 | JsonPropertyName | JPN | List of specific names to use with JSON serialization of specific output entities (tables/functions/procedures) |
| 48 | ListingActivationStatus | LAS | Source-dictated activation status for an external list |
| 49 | ListingEvent | LSE | List of event types that may be tracked on the property listing page for a given Property |
| 50 | LocationActivity | LAT | List of activities in a given location |
| 51 | LocationActivityCategory | LAC | List of activity categories |
| 52 | LocationDataField | LDF | JSON data fields for Locations |
| 53 | NEXT_PropertyAmenityRefresh | ||
| 54 | NEXT_PropertyList | ||
| 55 | NEXT2_Codes_PropertyAmenities | NAM | NextPax API codes for various Property Amenities - will be mapped down to our Amenities table |
| 56 | NEXT2_Codes_PropertyChargeModes | NCM | NextPax API codes for various Property Charge Modes - will be mapped down to our PropertyFees table for the mode of the charge |
| 57 | NEXT2_Codes_PropertyChargeTypes | NCT | NextPax API codes for various Property Charge Types - will be mapped down to our PropertyFees table for the types of charges |
| 58 | NEXT2_Codes_PropertyFees | NFE | NextPax API codes for various Property Fees - will be mapped down to our PropertyFees table |
| 59 | NEXT2_Codes_PropertyImages | Npi | NextPax API codes for various Property Images - will be mapped down to our PropertyImage table |
| 60 | NEXT2_Codes_PropertyTaxes | NTX | NextPax API codes for various Property Taxes - will be mapped down to our PropertyFees table |
| 61 | NEXT2_Codes_PropertyTypes | NPT | NextPax API codes for various Property Types - will be mapped down to our PropertyType table |
| 62 | NEXTCategory | NXC | Category codes used in the NextPax import process |
| 63 | NEXTDates | ||
| 64 | NEXTDistance | NXD | Distance codes used in the NextPax import process |
| 65 | NEXTFee | NXF | Additional cost codes used in the NextPax import process |
| 66 | NEXTListingFileData | LFD | List of data file names and types to import |
| 67 | NEXTProperty | NXP | Property codes used in the NextPax import process |
| 68 | NEXTProperty_XML_2021 | ||
| 69 | NEXTPropList_LX000132 | ||
| 70 | Numbers | NUM | |
| 71 | OEL_S22_NoRates | ||
| 72 | OREZ_ClientListXML | OCL | Exposed client list from OwnerRez - basic list of OREZ IDs, names and owner emails - as an XML document which is later parsed |
| 73 | owner_order_details | OOD | |
| 74 | owner_orders | OOR | |
| 75 | OwnerAccessLog | OAL | Log of owner logins to the site |
| 76 | OwnerContact | OCN | Contacts of various Types for a given Owner |
| 77 | OwnerContact_BPAL | OCNBP | Contacts of various Types for a given Owner for BookingPal accounts only |
| 78 | OwnerContactType | OCT | Contacts types for OwnerContacts - types are divided by Site; used for contacts from feed sources |
| 79 | OwnerContactTypeList | CTL | List of contact type labels/designators from feed sources (including base site) for OwnerContactsTypes - types are divided by Site; used for contacts from feed sources |
| 80 | OwnerExternalImport | OEM | Staging table for importing XML or JSON data directly files for futher processing for a given Owner |
| 81 | OwnerExternalInventory | OEI | External site property listing inventories (ID, Name, Descr) - for a given Owner |
| 82 | OwnerExternalListing | OEL | External site references - include keys, token, usernames, password and portals - for a given Owner |
| 83 | OwnerImportFile | OIF | Log of file imports loaded from an external Source for a given Owner |
| 84 | OwnerReferral | ORF | List of owners referred to ECBYO for signups and/or listings |
| 85 | OwnerSignup | OSU | List of owner signups and date info |
| 86 | package | PKG | |
| 87 | PAM_Temp | ||
| 88 | PMT_ClientListXML | PCL | Exposed client list from PMT - basic list of PMT IDs and names - as an XML document which is later parsed |
| 89 | ProcessErrorLog | PLG | Log of errors generated by queries |
| 90 | property | PRP | Properties available for lease |
| 91 | property_activities | PAC | |
| 92 | property_amenities | PAM | |
| 93 | property_booking | PBK | |
| 94 | property_booking_system | ||
| 95 | property_booking_system_automated_discount | ||
| 96 | property_booking_system_discount_coupon | ||
| 97 | property_booking_system_extra_guest | ||
| 98 | property_booking_system_mandatory_fee | MFEE | |
| 99 | property_booking_system_mandatory_tax | ||
| 100 | property_booking_system_minimum_stay | ||
| 101 | property_booking_system_optional_fee | ||
| 102 | property_calendar_ical | ||
| 103 | property_gallery | PG | |
| 104 | property_inquiry | PI | |
| 105 | property_inquiry_ricardo | ||
| 106 | Property_NEXT | ||
| 107 | property_rank | PRK | |
| 108 | property_rate | PRTI | |
| 109 | property_rates | PRT | |
| 110 | property_review | PRV | |
| 111 | PropertyAction | PRA | List of data actions for use on a Property, either singular or multiple |
| 112 | PropertyActivityImport | PAI | Activities associated with a given Property, based on proximity; used to import in bulk |
| 113 | PropertyAddress | PAD | List of the physically identifiable street address of a given Property |
| 114 | PropertyAmenityFilter | PAF | Filter flags for pre-defined amenity filters for a given Property; closely tied to property_amenities, amenities and amenity_categories |
| 115 | PropertyAmenityFilterOverride | PAFO | Filter flags overrides that align with the PropertyAmenityFilter table, but these indicators will allow for deliberate setting in reaction to feed paramaters |
| 116 | PropertyAvailability | PAV | The availability calendar for a given Property (dates are assumed available unless marked otherwise) |
| 117 | PropertyBooking | PBK | Records for property availability |
| 118 | PropertyBookingCalendar | PBC | Consolidated record set for the property availability calendar indicating date that are booked for a given Property |
| 119 | PropertyBookingImport | PBI | Records for the property availability calendar indicating date that are booked for a given Property that come from external sources via an import mechanism; these records are not intended for individual editing |
| 120 | PropertyCalendar | PCL | The availability calendar for a given Property (dates are assumed available unless marked otherwise) |
| 121 | PropertyDataField | JSON data fields for Properties | |
| 122 | PropertyDateAvailability | PDA | List of available check in/out dates based on LoS rate data from the PropertyRateLoS table |
| 123 | PropertyDateLoS_FeedDB | PDT | Length of Stay (LoS) availability for a given Property - similar to PropertyRateLos, but no rate data (this is for the availability only that will be fed into PropertyDateAvailability) |
| 124 | PropertyDeal | PDL | Owner deals for the specified properties |
| 125 | PropertyDiscount | DSC | Discount to be applied to a rental for a given Property (Note: discounts are always applied as a negative quantity) |
| 126 | PropertyExternalImport_Avail_FeedDB | PEIA | Working table for importing XML or JSON data directly into the database for an external Listing for availability (calendar) data only |
| 127 | PropertyExternalImport_Bran | PEI | Working table for importing XML or JSON data directly into the database for an external Listing |
| 128 | PropertyExternalImport_Copy | PEI | Working table for importing XML or JSON data directly into the database for an external Listing |
| 129 | PropertyExternalImport_FeedDB | PEI | Working table for importing XML or JSON data directly into the database for an external Listing |
| 130 | PropertyExternalImport_Rate_FeedDB | PEIR | Working table for importing XML or JSON data directly into the database for an external Listing for Streamline rate data only |
| 131 | PropertyExternalListing | PEL | List of external listing references for a given Property |
| 132 | PropertyExternalLocation | PXL | Mapping of external listing locations onto our PropertyLocation table for a given External Site |
| 133 | PropertyExternalStatus | PES | Operations status for a Property (used mostly for feed properties right now) |
| 134 | PropertyExternalUpdate_FeedDB | PEU | Working table for importing XML or JSON data directly into the database for an external Listing that updates a base object in PropertyExternalImport |
| 135 | PropertyFee | FEE | Mandatory and optional fees associated with a given Property |
| 136 | PropertyFeeImport | PFI | Fees (mandatory and option) associated with Properties; used to import in bulk |
| 137 | PropertyGalleryLog | PGL | Log of the creation of the thumbnail photos for each main gallery photo |
| 138 | PropertyICalImport | PII | List of external iCal links for importing into a given Property |
| 139 | PropertyICalImportLog | PIL | Log of iCal imports based on the PropertyICalImportTable |
| 140 | PropertyImage | IMG | Images/photos for individual Properties |
| 141 | PropertyImage_GC | ||
| 142 | PropertyImageContent | IMGC | Images/photo content for individual Properties |
| 143 | PropertyImageImport | PIM | Images handled for data feed imports |
| 144 | PropertyImageList | IML | Comma-delimited list of property images and remote image flags in order based on property_gallery table |
| 145 | PropertyImageURL | PIU | Log of physical asset URLs or filenames for a given Image |
| 146 | PropertyImportAction | PIA | List of predefined data actions intended fo ruse with the data feeds |
| 147 | PropertyListingEvent | PLE | Log of event interactions on the property listing page |
| 148 | PropertyListingInventory | PLI | Basic info for the list of exposed property listings from a given feed source for a given Owner account - base version of the same table in the ImportAdmin database |
| 149 | PropertyListingSite | PLS | External property listing sites and the IDs associated with a given Property |
| 150 | PropertyLocationImport | PLIM | Hand-mapped locations for state/city/community combo that come in through the data |
| 151 | PropertyManagerList_BPAL | PMLBP | Table of BookingPal property managers using the ECBYO channel - populated from the pm_id and pm_name keys in the API |
| 152 | PropertyManagerList_OREZ | PML | |
| 153 | PropertyMigrationList_BPAL | PML | List of Properties that is in the processof being migrated from PropertyExternalUpdate (PEU) to PropertyExternalImport (PEI); it is maintained by the SQL job that is moving these properties down the pipeline |
| 154 | PropertyMinNight | PMN | Minimum nights for data ranges on a given Property |
| 155 | PropertyNightlyRate | PNR | The calculated Nightly Rate for a given Property; this table is populated by the process that calculates the rates |
| 156 | PropertyOption | POP | List of options for a given Property |
| 157 | PropertyOptionValue | POV | Definition of option values for the PropertyOption table |
| 158 | PropertyPackage | PKG | List of packages available for sale |
| 159 | PropertyPackageType | PPT | List of packages type available for use |
| 160 | PropertyPricingModel | PPM | Pricing model used for a given Property; mostly used by BPAL, but can be applied to any property (default is per_night) |
| 161 | PropertyQuote | PQT | Log of property quotes requested in conjunction with property inqueries |
| 162 | PropertyRate | PRT | Periodic rates for a given Property |
| 163 | PropertyRateImport | PRI | Rates associated with Properties; used to import in bulk |
| 164 | PropertyRateLoS_FeedDB | PRL | Length of Stay (LoS) rates for a given Property |
| 165 | PropertyRateLoS_Raw_BPAL_FeedDB | PRLBP | Dump of Length of Stay (LoS) rates for a given Property from the BookingPal feed for native LOS properties |
| 166 | PropertyRatesImport | RAT | Rates associated with Properties; used to import in bulk to the O:D table structure |
| 167 | PropertyRenewalExclude | PRE | Exclude the listed properties from being sent property renewal notices; this table is part of a temp |
| 168 | PropertyReservation | RES | Rental reservations booked on this platform for a given Property |
| 169 | PropertyReservationData | RSD | Data captured in relation to a given Reservation |
| 170 | PropertyReservationDetail | PRD | Basic details for rental reservations booked on this platform for a given Property; intended for reporting |
| 171 | PropertyReview | PRV | Guest reviews for stays on a given Property |
| 172 | PropertySearchLog | PSL | Log of Property searches done from the search form |
| 173 | PropertyTax | TAX | Taxes on rental rates and fees associated with a given Property |
| 174 | PropertyType_BPAL | PTPBP | Mapping of the system PropertyType (just type in ECBYO right now) to the Listing Type Category in BookingPal |
| 175 | PropertyUpdateAction | PUA | List of predefined general Actions intended for use with all properties and owners or custom routines for a specific owner |
| 176 | PropertyUpdateQueue | PUQ | List of data actions for use on a Property, most |
| 177 | question_ans | QAN | |
| 178 | ReservationCancellationLog | RCL | Log of requests to cancel a Reservation |
| 179 | SalesRep | SAL | List sales reps who sell, market and maintain owner accounts |
| 180 | SearchOverrideLog | SRO | Log of requests by owner to grant a search result override for a given Property if the owner does not legitimately have any future bookings |
| 181 | seo_ecbyo | SEO | |
| 182 | seo_ecbyo_links | SEL | |
| 183 | SHVRS-ECBYO_Rate_Table_11-9-20 | ||
| 184 | site_config | SCO | |
| 185 | site_content | SCN | |
| 186 | site_content_page | SCP | |
| 187 | site_email_template | SET | |
| 188 | site_form_contactus | SFC | |
| 189 | site_slider | SSI | |
| 190 | SiteExternalImport | SEI | Staging table for importing XML or JSON data directly files for futher processing |
| 191 | SiteImportFile | IMP | Log of file imports loaded from an external Source |
| 192 | SMSCarrier | SMS | List of cellular service providers in the US and Canada and their email-to-SMS gateway |
| 193 | SterlingRaw | ||
| 194 | SubSite | SRS | egional sites within the main Regional site |
| 195 | SubSiteContent | SSC | egional site |
| 196 | SubSiteLocationList | SSL | this allows arbitrary Locations to be included in any given site |
| 197 | SubSitePage | SSP | egional site |
| 198 | sysdiagrams | ||
| 199 | SystemAmenity_BPAL | SAM | Standard amenities for a given Property on the BookingPal feed |
| 200 | SystemAmenity_PMT | SAM | Standard amenities for a given Property on the PropertyManagerTools feed |
| 201 | SystemAmenity_ToBeAdded | AAD | Extra amenities to add to ECBYO to support the new admin |
| 202 | SystemAmenityCategory | SAC | Categories of amenities within the system tied to the import source |
| 203 | SystemAmenityCategory_BPAL | SAC | System-level amenity categories to add for the BookingPal feed |
| 204 | SystemAmenityCategory_PMT | SAC | System-level amenity categories to add for the PropertyManagerTools feed |
| 205 | SystemAmenityLoad_RJ | ||
| 206 | SystemOption | SOP | List of system-wide option bits stored as groups of integers |
| 207 | SystemOptionList | SOL | List of system-wide option values |
| 208 | SystemOptionValue | SOV | Definition of option values for the SystemOption table |
| 209 | SystemOwnerPhoto | OPH | |
| 210 | SystemReview | SRV | Owner review (testimonial) of system performance |
| 211 | tbl_OwnerOrderByDate | ||
| 212 | tbl_Property_O2549 | ||
| 213 | TLDList | TLD | List of current top level domains for email address validations |
| 214 | tmp_NewECBYOCities | TMPC | Temporary but stable table to setup new cities for the ECBYO Expansion |
| 215 | tmp_PropertyRateLoS | ||
| 216 | type | TYP | |
| 217 | user_login | OWN | |
| 218 | UserAccessLog | UAL | Log of user logins to the site |
| 219 | UserType | UST | Types of users that can log into the system |
| 220 | Voucher | VCH | Vouchers to use on adding value and function to owners and properties |
| 221 | VoucherType | VCT | Types of vouchers to use on adding value and function to owners and properties |
| 222 | WynAmenMaster | WAM | Master list of all available Wyndham property amenities mapped to our ameniity/category combos |
| 223 | WynAvailData | WYA | Wyndham availability data |
| 224 | WyndhamData | WYN | Wyndham data load |
| 225 | xx_ZipCode | ZIP | |
| 226 | ZipCode | ZIP | List of zip codes for the states that are a part of ECBYO (general accuracy is sufficient in this use case) |
Total: 226 table(s)