erd

Tables (4)

bookmark

  • bookmark_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT
  • cafe_id — BIGINT

business

  • id — BIGINT — Primary key — NOT NULL
  • 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_image

  • id — BIGINT — Primary key — NOT NULL
  • cafe_id — BIGINT
  • img_url — VARCHAR(255)

cafe_keyword

  • id — BIGINT — Primary key — NOT NULL
  • cafe_id — BIGINT
  • keyword_id — BIGINT