property-detail
The property_details table stores comprehensive information about properties listed in a system, likely for a hotel or accommodation booking platform.
| Field Name | Type | Other | Index | |
|---|---|---|---|---|
| id | int(11) | NOT NULL AUTO_INCREMENT | Ya | |
| userid | int(11) | NOT NULL | Ya | |
| Property_Name | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| currency | varchar(50) | COLLATE utf8_bin NOT NULL | ||
| Accomodation_type | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| Rating | varchar(11) | COLLATE utf8_bin DEFAULT NULL | ||
| rating_Type | varchar(100) | COLLATE utf8_bin DEFAULT NULL | ||
| Rating_Number | varchar(30) | COLLATE utf8_bin NOT NULL | ||
| Contact_Name | varchar(150) | COLLATE utf8_bin NOT NULL | ||
| varchar(100) | COLLATE utf8_bin NOT NULL | |||
| cc_email | longtext | COLLATE utf8_bin | ||
| country_code | varchar(15) | COLLATE utf8_bin NOT NULL | ||
| Primary_Phone | varchar(15) | COLLATE utf8_bin DEFAULT NULL | ||
| mobile_number | varchar(20) | COLLATE utf8_bin NOT NULL | ||
| mobile_countrycode | varchar(50) | COLLATE utf8_bin NOT NULL | ||
| Primary_Fax | varchar(20) | COLLATE utf8_bin NOT NULL | ||
| Website_Address | varchar(100) | COLLATE utf8_bin DEFAULT NULL | ||
| Qty_rooms | int(11) | NOT NULL | ||
| Tax_Id | varchar(50) | COLLATE utf8_bin NOT NULL | ||
| Time_Zone | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| Street_Address | varchar(250) | COLLATE utf8_bin NOT NULL | ||
| Street_City | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| Street_State | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| Street_Zip | varchar(20) | COLLATE utf8_bin DEFAULT NULL | ||
| Street_Country | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| Postal_Address | varchar(250) | COLLATE utf8_bin NOT NULL | ** | |
| Postal_City | varchar(100) | COLLATE utf8_bin NOT NULL | ** | |
| Postal_State | varchar(100) | COLLATE utf8_bin NOT NULL | ** | |
| Postal_Zip | varchar(20) | COLLATE utf8_bin DEFAULT NULL | ** | |
| Postal_Country | varchar(100) | COLLATE utf8_bin NOT NULL | ** | |
| Latitude | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| Longitude | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| Description | mediumtext | COLLATE utf8_bin | ||
| terms_conditions | text | COLLATE utf8_bin NOT NULL | ||
| thumbnail | longtext | COLLATE utf8_bin NOT NULL | ||
| property_logo | longtext | COLLATE utf8_bin NOT NULL | ||
| step_no | int(11) | NOT NULL | ||
| date | date | NOT NULL | ||
| int(1) | NOT NULL default 0 | |||
| cron_import_resv | int(11) | NOT NULL | ||
| varchar(200) | ||||
| varchar(30) | COLLATE utf8_bin | |||
| varchar(15) | COLLATE utf8_bin | |||
| travel_time | varchar(20) | COLLATE utf8_bin NOT NULL | not use | |
| by | varchar(20) | COLLATE utf8_bin NOT NULL | not use | |
| name | varchar(200) | COLLATE utf8_bin NOT NULL | not use | |
| banner_picture | mediumtext | COLLATE utf8_bin NOT NULL | ||
| mobilebanner_picture | text | OLLATE utf8_bin NOT NULL | ||
| template | varchar(255) | COLLATE utf8_bin DEFAULT 'template3' | not use | |
| template_id | enum('','1','2','3') | COLLATE utf8_bin NOT NULL | not use | |
| backgroundimage | varchar(200) | COLLATE utf8_bin DEFAULT NULL | ||
| custombgimage | varchar(200) | COLLATE utf8_bin DEFAULT NULL | ||
| cover | varchar(10) | COLLATE utf8_bin DEFAULT NULL | ||
| facebook_link | varchar(200) | COLLATE utf8_bin DEFAULT NULL | ||
| com_base_start | varchar(150) | COLLATE utf8_bin NOT NULL | ||
| syspay_login | int(11) | NOT NULL | ||
| search_tags | varchar(400) | COLLATE utf8_bin NOT NULL | ||
| syspay_public_key | varchar(250) | COLLATE utf8_bin NOT NULL | ||
| status | enum('active','inactive') | COLLATE utf8_bin NOT NULL | Ya | |
| unique_id | varchar(50) | COLLATE utf8_bin NOT NULL | ||
| cron_import_comp | int(11) | NOT NULL | ||
| api_status | int(11) | NOT NULL | ||
| prefix_booking_number | varchar(50) | COLLATE utf8_bin DEFAULT NULL | ||
| last_month | varchar(10) | COLLATE utf8_bin NOT NULL | ||
| analytic | text | COLLATE utf8_bin | ||
| pms_flag | varchar(20) | COLLATE utf8_bin DEFAULT NULL | ||
| email_report | varchar(200) | COLLATE utf8_bin NOT NULL | ||
| Preferred_Currency | varchar(20) | COLLATE utf8_bin NOT NULL | ||
| auto_update | varchar(200) | COLLATE utf8_bin NOT NULL | ||
| payment_cycle | enum('monthly','yearly') | COLLATE utf8_bin NOT NULL | ||
| payment_amount | varchar(20) | COLLATE utf8_bin NOT NULL | ||
| google_tag_manager | varchar(500) | COLLATE utf8_bin DEFAULT NULL | ||
| google_tag_manager2 | varchar(500) | COLLATE utf8_bin DEFAULT NULL | ||
| api_key | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| cvv_check | int(11) | NOT NULL | ||
| contract_start | date | NOT NULL | ||
| update_log_status | int(11) | NOT NULL | ||
| mail_alert | int(11) | NOT NULL | ||
| agent_page | int(11) | NOT NULL | ||
| lang_id | int(11) | NOT NULL | ||
| cron_setting | int(11) | DEFAULT '2' | Ya | |
| com_base | int(11) | NOT NULL | ||
| paid | varchar(20) | COLLATE utf8_bin NOT NULL | ||
| group_id | varchar(200) | COLLATE utf8_bin NOT NULL | ||
| hk_feature | int(11) | NOT NULL | ||
| min_rows | int(11) | NOT NULL | ||
| property_group_id | int(11) | NOT NULL | ||
| instagram_link | varchar(200) | COLLATE utf8_bin DEFAULT NULL | ||
| jurnal_apikey | varchar(200) | COLLATE utf8_bin NOT NULL | ||
| timestamp | timestamp | NULL DEFAULT CURRENT_TIMESTAMP | ||
| dynamic_pricing_method | int(11) | NOT NULL | ||
| trial | int(11) | NOT NULL | ||
| billing_currency | varchar(3) | COLLATE utf8_bin NOT NULL | ||
| bookingku | int(11) | NOT NULL | ||
| email_bnlgateway | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| email_dyn_pricing | varchar(100) | COLLATE utf8_bin NOT NULL | ||
| yearly_synchro | int(11) | NOT NULL | ||
| ibe_enable | int(11) | NOT NULL | ||
| order_step | int(11) | NOT NULL | ||
| kovena_surcharge_type | varchar(10) | COLLATE utf8_bin NOT NULL | ||
| kovena_surcharge_value | varchar(10) | COLLATE utf8_bin NOT NULL | ||
| youtube_link | varchar(200) | COLLATE utf8_bin DEFAULT NULL | ||
| kovena_gateway | varchar(30) | COLLATE utf8_bin NOT NULL | ||
| kovena_currency | varchar(3) | COLLATE utf8_bin NOT NULL | ||
| send_cc | int(11) | NOT NULL | ||
| search_tags2 | varchar(400) | COLLATE utf8_bin NOT NULL | ||
| hotelku | int(11) | DEFAULT '0' | ||
| pos | int(11) | DEFAULT '0' | ||
| dyn_pricing | int(11) | DEFAULT '0' | ||
| reviewku | int(11) | DEFAULT '0' | ||
| is_suspended | tinyint(4) | DEFAULT '0' | ||
| billing_date | date | DEFAULT NULL | Ya | |
| is_s3_storage | tinyint(4) | DEFAULT '0' | Ya | |
| dynamic_min_night | tinyint(4) | DEFAULT '0' | ||
| accounting_email | varchar(150) | COLLATE utf8_bin NOT NULL | ||
| tiktok_link | text | COLLATE utf8_bin | ||
| slug | varchar(255) | COLLATE utf8_bin DEFAULT NULL | ||
| created_at | timestamp | NULL DEFAULT CURRENT_TIMESTAMP | ||
| updated_at | timestamp | NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP |
Here’s an explanation of each field:
Basic Identifiers
id: Unique identifier for the property.userid: The user who owns or manages the property.unique_id: A secondary unique identifier, possibly used for external integrations.
Property Information
Property_Name: Name of the property.currency: Default currency for transactions related to this property.Accomodation_type: Type of accommodation (e.g., hotel, villa, apartment).category: Classification of the property (e.g., budget, luxury).place: The general location or area of the property.
Ratings & Reviews
Rating: Overall rating of the property.rating_Type: Type of rating used (e.g., stars, points).Rating_Number: Number of reviews that contributed to the rating.is_demo: Whether demo Account are enabled.reviewku: Whether internal review features are enabled.
Contact Details
Contact_Name: Primary contact person.Email: Official email address.cc_email: Additional email for CC.country_code: Country dialing code.Primary_Phone: Main contact number.mobile_number: Mobile phone number.mobile_countrycode: Country code for the mobile number.Primary_Fax: Fax number.Website_Address: Official website link.accounting_email: Email for accounting-related matters.
Address Details
Street_Address,Street_City,Street_State,Street_Zip,Street_Country: Physical address of the property.Postal_Address,Postal_City,Postal_State,Postal_Zip,Postal_Country: Postal mailing address.
Geolocation
Latitude: Geographic latitude.Longitude: Geographic longitude.distance: Distance from a key location.distance_type: Unit of measurement (e.g., km, miles).travel_time: Estimated travel time to a key location.
Property Details
Qty_rooms: Number of rooms available.Tax_Id: Tax identifier.Time_Zone: Property’s timezone.terms_conditions: Terms and conditions for booking.Description: Description of the property.
Images & Media
thumbnail: Thumbnail image of the property.property_logo: Property’s logo.banner_picture: Main banner image.mobilebanner_picture: Banner image for mobile display.backgroundimage: Background image for the property’s profile.custombgimage: Custom background image.cover: Cover image.facebook_link,instagram_link,youtube_link,tiktok_link: Social media links.
Booking & Payment Settings
Preferred_Currency: Default currency for transactions.auto_update: Whether automatic updates are enabled.payment_cycle: Frequency of payments (e.g., monthly, yearly).payment_amount: Default payment amount.pms_flag: Indicates if the property is using a Property Management System (PMS).cvv_check: Whether CVV verification is required.prefix_booking_number: Prefix for booking numbers.billing_currency: Currency for billing.billing_date: Date of the billing cycle.paid: Whether the property has settled its dues.trial: Whether the property is in a trial period.
Integration & API Settings
api_status: Status of the API connection.api_key: API key for external integrations.cron_import_resv: Whether reservation import via cron job is enabled.cron_import_comp: Whether completed reservation import is enabled.cron_setting: Settings related to cron jobs.yearly_synchro: Whether yearly synchronization is enabled.ibe_enable: Whether Internet Booking Engine (IBE) is enabled.syspay_login: System payment login credential.syspay_public_key: Public key for system payments.kovena_gateway: Payment gateway used.kovena_currency: Currency used for Kovena transactions.kovena_surcharge_type: Type of surcharge applied in Kovena.kovena_surcharge_value: Value of the surcharge.
Analytics & Tracking
google_tag_manager,google_tag_manager2: Google Tag Manager IDs for tracking.analytic: Stores analytics-related data.update_log_status: Whether updates are logged.
Marketing & SEO
search_tags: Tags used for search optimization.search_tags2: Additional search tags.slug: SEO-friendly URL identifier.
Administrative & Miscellaneous
step_no: Current setup step in the onboarding process.date: The date when the property was added.timestamp: Last update timestamp.group_id: Group ID if the property belongs to a group.property_group_id: ID of the property's group.is_suspended: Whether the property is suspended.is_s3_storage: Whether S3 storage is used.dynamic_min_night: Minimum nights for dynamic pricing.dynamic_pricing_method: Method used for dynamic pricing.dyn_pricing: Whether dynamic pricing is enabled.order_step: The step number in the order process.mail_alert: Whether email alerts are enabled.agent_page: Whether an agent-specific page is enabled.lang_id: Language ID of the property.