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