Seoul_Docent
Tables (6)
curation
- id — BIGINT
- location_log_id — BIGINT — NOT NULL
- provider_id — VARCHAR(128)
- place_id — BIGINT
- category — VARCHAR(30)
- curated_sentence — TEXT — NOT NULL
- created_at — TIMESTAMP
curation_like
- id — BIGINT
- curation_id — BIGINT — NOT NULL
- provider_id — VARCHAR(128) — NOT NULL
- liked — TINYINT(1) — NOT NULL
- created_at — TIMESTAMP
location_log
- id — BIGINT
- kakao_place_id — VARCHAR(64) — NOT NULL
- place_name — VARCHAR(255) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- address — VARCHAR(255)
- latitude — DOUBLE
- longitude — DOUBLE
- nationality — VARCHAR(10)
- preferred_category — VARCHAR(50)
- recommended_category — VARCHAR(30)
- recommended_probability — DOUBLE
- candidate_probabilities — TEXT
- created_at — TIMESTAMP
- INDEX — idx_location_log_kakao
place
- id — BIGINT
- kakao_place_id — VARCHAR(64) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- address — VARCHAR(255)
- latitude — DOUBLE
- longitude — DOUBLE
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_preference
- id — BIGINT
- provider_id — VARCHAR(128) — NOT NULL
- category — VARCHAR(30) — NOT NULL
- weight — DOUBLE — NOT NULL
- updated_at — TIMESTAMP
users
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- provider_id — VARCHAR(128) — NOT NULL
- nationality — VARCHAR(10)
- preferred_category — VARCHAR(50)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP