TripFlow
Tables (9)
tf_inquiries
- inquiry_id — INT
- user_id — INT — Foreign key → tf_users.user_id
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- reply_content — TEXT
- is_replied — BOOLEAN
- created_at — TIMESTAMP
tf_operating_hours
- hour_id — INT
- place_id — INT — Foreign key → tf_places.place_id — NOT NULL
- day_of_week — INT — NOT NULL
- open_time — TIME
- close_time — TIME
- is_closed — BOOLEAN
tf_place_bucket
- bucket_id — INT
- user_id — INT — Foreign key → tf_users.user_id — NOT NULL
- place_id — INT — Foreign key → tf_places.place_id — NOT NULL
- added_at — TIMESTAMP
tf_places
- place_id — INT
- name — VARCHAR(255) — NOT NULL
- category — VARCHAR(50)
- address — TEXT
- latitude — DECIMAL(10, 8) — NOT NULL
- longitude — DECIMAL(11, 8) — NOT NULL
- recommended_stay_minutes — INT
- rating — DECIMAL(2, 1)
- is_active — BOOLEAN
- created_at — TIMESTAMP
tf_schedules
- schedule_id — INT
- trip_id — INT — Foreign key → tf_trips.trip_id — NOT NULL
- place_id — INT — Foreign key → tf_places.place_id
- sequence_order — INT — NOT NULL
- type — VARCHAR(20) — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- duration_minutes — INT — NOT NULL
- memo — TEXT
- transport_detail — JSONB
tf_social_auth
- social_id — VARCHAR(255)
- user_id — INT — Foreign key → tf_users.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- connected_at — TIMESTAMP
tf_system_logs
- log_id — INT
- log_type — VARCHAR(50)
- endpoint — VARCHAR(255)
- latency_ms — INT
- status_code — INT
- message — TEXT
- created_at — TIMESTAMP
tf_trips
- trip_id — INT
- user_id — INT — Foreign key → tf_users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- trip_date — DATE — NOT NULL
- start_location_name — VARCHAR(255)
- start_latitude — DECIMAL(10, 8)
- start_longitude — DECIMAL(11, 8)
- start_time — TIME — NOT NULL
- transport_mode — VARCHAR(20)
- pace_level — VARCHAR(20)
- feasibility_status — VARCHAR(20)
- created_at — TIMESTAMP
tf_users
- user_id — INT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- address — TEXT
- status — VARCHAR(20)
- marketing_agree — BOOLEAN
- created_at — TIMESTAMP
- last_login_at — TIMESTAMP