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