Tabela accommodation — variáveis (colunas)

Base de dados gocore. Lista gerada em tempo real com SHOW FULL COLUMNS — 86 colunas.

Versão JSON desta lista — para integrar em scripts (sem raspar HTML).

Lista compacta (apenas nomes)

  1. id
  2. api_id
  3. beds24_prop_key
  4. beds24_synced_at
  5. name
  6. listing_short_name
  7. typology
  8. is_virtual_listing
  9. duplicated_from_accommodation_id
  10. calendar_listing_kind
  11. calendar_inventory_anchor_id
  12. description_short
  13. description_long
  14. pictures
  15. tags
  16. beds24_extra
  17. type
  18. beds24_prop_type_id
  19. status
  20. operational_status
  21. tenant_code
  22. booking_mode
  23. operational_reason_code
  24. operational_reason_detail
  25. operational_status_changed_at
  26. operational_status_actor_user_id
  27. operational_status_actor_user_name
  28. operational_status_change_source
  29. clean
  30. units
  31. subType
  32. purpose
  33. pricingModel
  34. updatedAt
  35. created_at
  36. updated_at
  37. capacity_maxAmount
  38. capacity_minAmount
  39. location_countryCode
  40. location_cityName
  41. location_resort
  42. location_coordinates_lat
  43. location_coordinates_lon
  44. location_admin1
  45. location_admin2
  46. location_address
  47. location_postalCode
  48. registry_tourismRegistrationNumber
  49. registry_legalEntityId
  50. owner_id
  51. beds24_account_id
  52. _links_self
  53. _links_availabilities
  54. _links_gallery
  55. _links_occupation_rule
  56. _links_rate
  57. contact_firstName
  58. contact_lastName
  59. contact_phone
  60. contact_mobile
  61. contact_fax
  62. contact_email
  63. contact_web
  64. currency
  65. cutOffHour
  66. vatRate
  67. beds24_control_priority
  68. beds24_notify_url
  69. beds24_notify_data
  70. beds24_notify_header
  71. beds24_templates
  72. beds24_channel_integrations
  73. api_map
  74. property_is_active
  75. beds24_property_id
  76. smoobu_apartment_id
  77. beds24_channel_enabled
  78. smoobu_channel_enabled
  79. su_api_channel_enabled
  80. avantio_channel_enabled
  81. partner_ical_token
  82. partner_ical_import_url
  83. airbnb_listing_url
  84. early_check_in_fee_per_hour_eur
  85. late_check_out_fee_per_hour_eur
  86. desk_extras_pricing_json

Detalhe

# Field Type Null Key Default Extra Comment
1 id int(11) NO PRI NULL auto_increment
2 api_id varchar(128) NO UNI NULL Identificador API Beds (propKey / propId)
3 beds24_prop_key varchar(128) YES NULL PropKey longo Beds24 (getPropertyContent) se diferente de api_id
4 beds24_synced_at datetime YES NULL Última sincronização com Beds24 (import ou refresh)
5 name varchar(255) NO NULL
6 listing_short_name varchar(191) YES NULL Nome curto (UI interna; não substitui name)
7 typology varchar(32) YES NULL Tipologia (nº quartos / tipo): Room, T1, V2, etc.
8 is_virtual_listing tinyint(1) NO 0 1 = anúncio virtual (duplicado); calendário pode agregar membros mapeados
9 duplicated_from_accommodation_id int(10) unsigned YES MUL NULL accommodation.id do anúncio origem da duplicação (auditoria)
10 calendar_listing_kind enum('REAL','VARIANT','GROUP') NO MUL REAL REAL=inventário canónico; VARIANT=anúncio do mesmo quarto (usa anchor); GROUP=combo resort (membros em accommodation_virtual_calendar_member)
11 calendar_inventory_anchor_id int(10) unsigned YES MUL NULL Só VARIANT: FK lógica para accommodation.id com calendar_listing_kind=REAL
12 description_short varchar(500) YES NULL Resumo/descrição curta
13 description_long text YES NULL Descrição completa (HTML ou texto)
14 pictures text YES NULL URLs das fotos (JSON array)
15 tags text YES NULL Etiquetas/categorias (JSON array de strings)
16 beds24_extra text YES NULL Dados completos Beds24 (merge lista + getProperty + API V2) em JSON
17 type varchar(50) YES MUL NULL
18 beds24_prop_type_id int(10) unsigned YES NULL Beds24 propTypeId
19 status varchar(50) YES MUL NULL
20 operational_status enum('active','inactive','suspended') NO MUL active Estado operacional para catálogo/ops (independente de status DELETED legado)
21 tenant_code varchar(64) YES MUL checkinall
22 booking_mode enum('immediate_payment','request_with_payment','request_no_card','request_with_card') NO request_no_card
23 operational_reason_code varchar(64) YES NULL
24 operational_reason_detail varchar(1000) NO
25 operational_status_changed_at datetime YES NULL
26 operational_status_actor_user_id varchar(64) YES NULL
27 operational_status_actor_user_name varchar(190) YES NULL
28 operational_status_change_source enum('manual','auto') YES NULL
29 clean tinyint(1) YES 0
30 units int(11) YES NULL Número de unidades
31 subType varchar(50) YES NULL
32 purpose varchar(50) YES NULL
33 pricingModel varchar(50) YES NULL
34 updatedAt varchar(50) YES NULL
35 created_at timestamp NO current_timestamp()
36 updated_at timestamp NO current_timestamp() on update current_timestamp()
37 capacity_maxAmount int(11) YES NULL
38 capacity_minAmount int(11) YES NULL
39 location_countryCode varchar(10) YES NULL
40 location_cityName varchar(150) YES NULL
41 location_resort varchar(100) YES NULL
42 location_coordinates_lat varchar(50) YES NULL
43 location_coordinates_lon varchar(50) YES NULL
44 location_admin1 varchar(100) YES NULL
45 location_admin2 varchar(100) YES NULL
46 location_address varchar(500) YES NULL Morada completa (Beds24 address)
47 location_postalCode varchar(20) YES NULL Código postal (Beds24 postcode)
48 registry_tourismRegistrationNumber varchar(100) YES NULL
49 registry_legalEntityId varchar(100) YES NULL
50 owner_id varchar(50) YES NULL
51 beds24_account_id int(10) unsigned YES MUL NULL Conta Beds24 (reseller) responsável
52 _links_self varchar(500) YES NULL Sincronizado de API: List Accommodations
53 _links_availabilities varchar(500) YES NULL Sincronizado de API: List Accommodations
54 _links_gallery varchar(500) YES NULL Sincronizado de API: List Accommodations
55 _links_occupation_rule varchar(500) YES NULL Sincronizado de API: List Accommodations
56 _links_rate varchar(500) YES NULL Sincronizado de API: List Accommodations
57 contact_firstName varchar(100) YES NULL Nome do contacto (Beds24 contactFirstName)
58 contact_lastName varchar(100) YES NULL Apelido do contacto (Beds24 contactLastName)
59 contact_phone varchar(50) YES NULL Telefone (Beds24 phone)
60 contact_mobile varchar(50) YES NULL Telemóvel (Beds24 mobile)
61 contact_fax varchar(50) YES NULL Fax (Beds24 fax)
62 contact_email varchar(255) YES NULL Email (Beds24 email)
63 contact_web varchar(500) YES NULL Site (Beds24 web)
64 currency varchar(10) YES EUR Moeda (Beds24 currency)
65 cutOffHour tinyint(3) unsigned YES NULL Hora limite check-in 0-24 (Beds24 cutOffHour)
66 vatRate decimal(5,2) YES NULL Taxa IVA % (Beds24 vatRate)
67 beds24_control_priority int(11) YES NULL Beds24 controlPriority
68 beds24_notify_url varchar(512) YES NULL Beds24 notifyUrl
69 beds24_notify_data varchar(64) YES NULL Beds24 notifyData
70 beds24_notify_header text YES NULL Beds24 notifyHeader
71 beds24_templates longtext YES NULL Beds24 template1..template8 (objeto JSON)
72 beds24_channel_integrations longtext YES NULL Campos Beds24 agoda*/airbnb*/booking*/ical*/etc. (objeto JSON)
73 api_map longtext YES NULL Origem API v1/v2, flags de import, amostra de chaves (JSON)
74 property_is_active tinyint(1) NO 0 1=activa na gocore; 0 até relação/configuração
75 beds24_property_id int(10) unsigned YES MUL NULL Property id numérico Beds24 (espelho; alinhar com import/API v2)
76 smoobu_apartment_id int(10) unsigned YES MUL NULL Apartamento/listing id Smoobu (espelho; também em channel_property_connections)
77 beds24_channel_enabled tinyint(1) NO 0 0=inactivo por defeito; 1 após mapa/relação Beds24
78 smoobu_channel_enabled tinyint(1) NO 0 0=inactivo por defeito; 1 após mapa Smoobu↔Beds24
79 su_api_channel_enabled tinyint(1) NO 0
80 avantio_channel_enabled tinyint(1) NO 0
81 partner_ical_token varchar(48) YES UNI NULL Token opaco URL feed iCal (parceiros)
82 partner_ical_import_url varchar(768) YES NULL URL iCal externo (portal) — referência / import futuro
83 airbnb_listing_url varchar(768) YES NULL URL público do anúncio Airbnb (/rooms/id)
84 early_check_in_fee_per_hour_eur decimal(10,2) YES NULL EUR/hora check-in antecipado (referência Desk)
85 late_check_out_fee_per_hour_eur decimal(10,2) YES NULL EUR/hora check-out tardio (referência Desk)
86 desk_extras_pricing_json longtext YES NULL Referência JSON de custos de extras (GoCore Desk)

Migrações SQL: accommodation/sql/ (README.md).