Tabela accommodation — variáveis (colunas)

Base de dados gocore. Lista gerada em tempo real com SHOW FULL COLUMNS — 81 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. operational_reason_code
  22. operational_reason_detail
  23. operational_status_changed_at
  24. operational_status_actor_user_id
  25. operational_status_actor_user_name
  26. operational_status_change_source
  27. clean
  28. units
  29. subType
  30. purpose
  31. pricingModel
  32. updatedAt
  33. created_at
  34. updated_at
  35. capacity_maxAmount
  36. capacity_minAmount
  37. location_countryCode
  38. location_cityName
  39. location_resort
  40. location_coordinates_lat
  41. location_coordinates_lon
  42. location_admin1
  43. location_admin2
  44. location_address
  45. location_postalCode
  46. registry_tourismRegistrationNumber
  47. registry_legalEntityId
  48. owner_id
  49. beds24_account_id
  50. _links_self
  51. _links_availabilities
  52. _links_gallery
  53. _links_occupation_rule
  54. _links_rate
  55. contact_firstName
  56. contact_lastName
  57. contact_phone
  58. contact_mobile
  59. contact_fax
  60. contact_email
  61. contact_web
  62. currency
  63. cutOffHour
  64. vatRate
  65. beds24_control_priority
  66. beds24_notify_url
  67. beds24_notify_data
  68. beds24_notify_header
  69. beds24_templates
  70. beds24_channel_integrations
  71. api_map
  72. property_is_active
  73. beds24_property_id
  74. smoobu_apartment_id
  75. beds24_channel_enabled
  76. smoobu_channel_enabled
  77. su_api_channel_enabled
  78. avantio_channel_enabled
  79. partner_ical_token
  80. partner_ical_import_url
  81. airbnb_listing_url

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 operational_reason_code varchar(64) YES NULL
22 operational_reason_detail varchar(1000) NO
23 operational_status_changed_at datetime YES NULL
24 operational_status_actor_user_id varchar(64) YES NULL
25 operational_status_actor_user_name varchar(190) YES NULL
26 operational_status_change_source enum('manual','auto') YES NULL
27 clean tinyint(1) YES 0
28 units int(11) YES NULL Número de unidades
29 subType varchar(50) YES NULL
30 purpose varchar(50) YES NULL
31 pricingModel varchar(50) YES NULL
32 updatedAt varchar(50) YES NULL
33 created_at timestamp NO current_timestamp()
34 updated_at timestamp NO current_timestamp() on update current_timestamp()
35 capacity_maxAmount int(11) YES NULL
36 capacity_minAmount int(11) YES NULL
37 location_countryCode varchar(10) YES NULL
38 location_cityName varchar(150) YES NULL
39 location_resort varchar(100) YES NULL
40 location_coordinates_lat varchar(50) YES NULL
41 location_coordinates_lon varchar(50) YES NULL
42 location_admin1 varchar(100) YES NULL
43 location_admin2 varchar(100) YES NULL
44 location_address varchar(500) YES NULL Morada completa (Beds24 address)
45 location_postalCode varchar(20) YES NULL Código postal (Beds24 postcode)
46 registry_tourismRegistrationNumber varchar(100) YES NULL
47 registry_legalEntityId varchar(100) YES NULL
48 owner_id varchar(50) YES NULL
49 beds24_account_id int(10) unsigned YES MUL NULL Conta Beds24 (reseller) responsável
50 _links_self varchar(500) YES NULL Sincronizado de API: List Accommodations
51 _links_availabilities varchar(500) YES NULL Sincronizado de API: List Accommodations
52 _links_gallery varchar(500) YES NULL Sincronizado de API: List Accommodations
53 _links_occupation_rule varchar(500) YES NULL Sincronizado de API: List Accommodations
54 _links_rate varchar(500) YES NULL Sincronizado de API: List Accommodations
55 contact_firstName varchar(100) YES NULL Nome do contacto (Beds24 contactFirstName)
56 contact_lastName varchar(100) YES NULL Apelido do contacto (Beds24 contactLastName)
57 contact_phone varchar(50) YES NULL Telefone (Beds24 phone)
58 contact_mobile varchar(50) YES NULL Telemóvel (Beds24 mobile)
59 contact_fax varchar(50) YES NULL Fax (Beds24 fax)
60 contact_email varchar(255) YES NULL Email (Beds24 email)
61 contact_web varchar(500) YES NULL Site (Beds24 web)
62 currency varchar(10) YES EUR Moeda (Beds24 currency)
63 cutOffHour tinyint(3) unsigned YES NULL Hora limite check-in 0-24 (Beds24 cutOffHour)
64 vatRate decimal(5,2) YES NULL Taxa IVA % (Beds24 vatRate)
65 beds24_control_priority int(11) YES NULL Beds24 controlPriority
66 beds24_notify_url varchar(512) YES NULL Beds24 notifyUrl
67 beds24_notify_data varchar(64) YES NULL Beds24 notifyData
68 beds24_notify_header text YES NULL Beds24 notifyHeader
69 beds24_templates longtext YES NULL Beds24 template1..template8 (objeto JSON)
70 beds24_channel_integrations longtext YES NULL Campos Beds24 agoda*/airbnb*/booking*/ical*/etc. (objeto JSON)
71 api_map longtext YES NULL Origem API v1/v2, flags de import, amostra de chaves (JSON)
72 property_is_active tinyint(1) NO 0 1=activa na gocore; 0 até relação/configuração
73 beds24_property_id int(10) unsigned YES MUL NULL Property id numérico Beds24 (espelho; alinhar com import/API v2)
74 smoobu_apartment_id int(10) unsigned YES MUL NULL Apartamento/listing id Smoobu (espelho; também em channel_property_connections)
75 beds24_channel_enabled tinyint(1) NO 0 0=inactivo por defeito; 1 após mapa/relação Beds24
76 smoobu_channel_enabled tinyint(1) NO 0 0=inactivo por defeito; 1 após mapa Smoobu↔Beds24
77 su_api_channel_enabled tinyint(1) NO 0
78 avantio_channel_enabled tinyint(1) NO 0
79 partner_ical_token varchar(48) YES UNI NULL Token opaco URL feed iCal (parceiros)
80 partner_ical_import_url varchar(768) YES NULL URL iCal externo (portal) — referência / import futuro
81 airbnb_listing_url varchar(768) YES NULL URL público do anúncio Airbnb (/rooms/id)

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