GMG

Tables (11)

availabilities

  • id — BIGINT
  • event_id — BIGINT — Foreign key → events.id — NOT NULL
  • participant_id — BIGINT — Foreign key → participants.id — NOT NULL
  • time_slot — NULL — 12일: 000000000000 000000000000 001111000000 000000000000
  • date — NULL — date: 2025-11-21
  • time_slot — NULL — time_slot: 15:30

event_place_types

  • id — BIGINT
  • event_id — BIGINT — Foreign key → events.id — NOT NULL
  • place_type_id — BIGINT — Foreign key → place_types.id — NOT NULL
  • is_selected — BOOLEAN — NOT NULL
  • selected_at — TIMESTAMP — NOT NULL

event_recommended_places

  • id — BIGINT
  • event_id — BIGINT — Foreign key → events.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • rank — INT — NOT NULL
  • total_score — DECIMAL(5,2) — NOT NULL
  • open_score — DECIMAL(5,2)
  • rating_score — DECIMAL(5,2)
  • people_fit_score — DECIMAL(5,2)
  • distance_score — DECIMAL(5,2)
  • ai_score — DECIMAL(5,2)
  • created_at — TIMESTAMP — NOT NULL

events

  • id — BIGINT
  • creator_id — BIGINT — Foreign key → participants.id — NOT NULL
  • hash_url — VARCHAR(64)
  • title — VARCHAR(50) — NOT NULL
  • timezone — VARCHAR(64) — NOT NULL
  • date_start — DATE — NOT NULL
  • date_end — DATE — NOT NULL
  • time_start — INT — NOT NULL
  • time_end — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL

final_result

  • result_id — BIGINT — Primary key — NOT NULL
  • event_id — BIGINT — Foreign key → events.id — NOT NULL
  • final_date — DATE
  • final_time_start — TIME
  • final_time_end — TIME
  • final_place_id — BIGINT — Foreign key → places.id — NOT NULL

participant_disliked_categories

  • id — BIGINT
  • event_id — BIGINT — Foreign key → events.id — NOT NULL
  • participant_id — BIGINT — Foreign key → participants.id — NOT NULL
  • category_id — BIGINT — Foreign key → place_categories.id — NOT NULL

participant_disliked_places

  • id — BIGINT
  • event_id — BIGINT — Foreign key → events.id — NOT NULL
  • participant_id — BIGINT — Foreign key → participants.id — NOT NULL
  • place_id — BIGINT — Foreign key → places.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

participants

  • id — BIGINT
  • event_id — BIGINT — Foreign key → events.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL

place_categories

  • id — BIGINT
  • place_type_id — BIGINT — Foreign key → place_types.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • code — VARCHAR(50)

place_types

  • id — BIGINT
  • code — VARCHAR(32)
  • label — VARCHAR(32) — NOT NULL

places

  • id — BIGINT
  • external_place_id — VARCHAR(128) — NOT NULL
  • provider — VARCHAR(32) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • place_type_id — BIGINT — Foreign key → place_types.id — NOT NULL
  • category_id — BIGINT — Foreign key → place_categories.id
  • latitude — DECIMAL(10,7) — NOT NULL
  • longitude — DECIMAL(10,7) — NOT NULL
  • address — VARCHAR(255)
  • image_url — VARCHAR(500)
  • rating — DECIMAL(2,1)
  • open_hours_json — TEXT
  • is_active — BOOLEAN — NOT NULL