tst

Tables (13)

bookmark

  • bookmark_id — BIGINT — Primary key
  • cafe_id (cafe_id2) — BIGINT — Foreign key → cafe.cafe_id
  • user_id (user_id2) — BIGINT — Foreign key → site_user.user_id
  • id (id22) — BIGINT — Foreign key → cafe.id
  • user_id (user_id22) — BIGINT — Foreign key → cafe.user_id
  • user_id — BIGINT
  • cafe_id — BIGINT

business

  • id — BIGINT — Primary key
  • user_id (user_id2) — BIGINT — Foreign key → site_user.user_id
  • user_id — BIGINT
  • company_name — VARCHAR(255)
  • business_number — VARCHAR(255)
  • representative_name — VARCHAR(255)
  • representative_email — VARCHAR(255)
  • representative_phone — VARCHAR(255)
  • address — VARCHAR(255)
  • description — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

cafe

  • cafe_id — BIGINT — Primary key
  • id (id2) — BIGINT — Foreign key → business.id
  • user_id (user_id2) — BIGINT — Foreign key → business.user_id
  • cafe_name — VARCHAR(255)
  • phone_num — VARCHAR(255)
  • site_url — VARCHAR(255)
  • address1 — VARCHAR(255)
  • address2 — VARCHAR(255)
  • district — VARCHAR(255)
  • city — VARCHAR(255)
  • lat — DECIMAL(19,2)
  • lng — DECIMAL(19,2)
  • open_time — VARCHAR(255)
  • close_time — VARCHAR(255)
  • parking_yn — TINYINT(1)
  • hit_count — INT
  • intro — VARCHAR(255)
  • user_id — BIGINT

cafe_image

  • id — BIGINT — Primary key
  • cafe_id (cafe_id2) — BIGINT — Foreign key → cafe.cafe_id
  • id (id22) — BIGINT — Foreign key → cafe.id
  • user_id (user_id2) — BIGINT — Foreign key → cafe.user_id
  • cafe_id — BIGINT
  • img_url — VARCHAR(255)

cafe_keyword

  • id — BIGINT — Primary key
  • cafe_id (cafe_id2) — BIGINT — Foreign key → cafe.cafe_id
  • id (id22) — BIGINT — Foreign key → cafe.id
  • user_id (user_id2) — BIGINT — Foreign key → cafe.user_id
  • cafe_id — BIGINT
  • keyword_id — BIGINT

cafe_menu

  • menu_id — BIGINT — Primary key
  • cafe_id (cafe_id3) — BIGINT — Foreign key → cafe.cafe_id
  • id (id22) — BIGINT — Foreign key → cafe.id
  • user_id (user_id2) — BIGINT — Foreign key → cafe.user_id
  • cafe_id — BIGINT
  • name — VARCHAR(255)
  • price — INT
  • description — VARCHAR(255)
  • sort_order — INT
  • cafe_id (cafe_id2) — BIGINT

keyword

  • id — BIGINT — Primary key
  • id (id2) — BIGINT — Foreign key → keyword_type.id
  • id (id3) — BIGINT — Foreign key → cafe_keyword.id
  • cafe_id (cafe_id2) — BIGINT — Foreign key → cafe_keyword.cafe_id
  • id (id22) — BIGINT — Foreign key → cafe_keyword.id
  • user_id (user_id2) — BIGINT — Foreign key → cafe_keyword.user_id
  • name — VARCHAR(255)
  • type_id — BIGINT
  • description — VARCHAR(255)

keyword_type

  • id — BIGINT — Primary key
  • type_name — VARCHAR(255)

likedUsers (Untitled)

  • user_id — BIGINT — Foreign key → site_user.user_id
  • cafe_id — BIGINT — Foreign key → cafe.cafe_id
  • id (id2) — BIGINT — Foreign key → cafe.id
  • user_id (user_id2) — BIGINT — Foreign key → cafe.user_id

review_images

  • id — BIGINT — Primary key
  • id (id2) — BIGINT — Foreign key → reviews.id
  • cafe_id (cafe_id2) — BIGINT — Foreign key → reviews.cafe_id
  • user_id (user_id2) — BIGINT — Foreign key → reviews.user_id
  • id (id22) — BIGINT — Foreign key → reviews.id
  • user_id (user_id22) — BIGINT — Foreign key → reviews.user_id
  • review_id — BIGINT
  • image_url — VARCHAR(255)

review_report

  • id — BIGINT — Primary key
  • id (id2) — BIGINT — Foreign key → reviews.id
  • cafe_id (cafe_id2) — BIGINT — Foreign key → reviews.cafe_id
  • user_id — BIGINT — Foreign key → site_user.user_id
  • user_id (user_id2) — BIGINT — Foreign key → reviews.user_id
  • id (id22) — BIGINT — Foreign key → reviews.id
  • user_id (user_id22) — BIGINT — Foreign key → reviews.user_id
  • review — BIGINT
  • reporter — BIGINT
  • reason — VARCHAR(255)

reviews

  • id — BIGINT — Primary key
  • cafe_id (cafe_id2) — BIGINT — Foreign key → cafe.cafe_id
  • user_id (user_id2) — BIGINT — Foreign key → site_user.user_id
  • id (id22) — BIGINT — Foreign key → cafe.id
  • user_id (user_id22) — BIGINT — Foreign key → cafe.user_id
  • cafe_id — BIGINT
  • user_id — BIGINT
  • rating — DOUBLE
  • content — VARCHAR(255)

site_user

  • user_id — BIGINT — Primary key
  • username — VARCHAR(255)
  • password — VARCHAR(255)
  • email — VARCHAR(255)
  • nickname — VARCHAR(255)
  • last_login — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME
  • reviews — VARCHAR(255)
  • bookmarks — VARCHAR(255)
  • phone — VARCHAR(255)
  • rrn — VARCHAR(255)
  • business_user — BIGINT