parkingtravel

Tables (8)

ARTICLE (게시물)

  • article_id — INT — Primary key — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → USER.user_id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • hit — INT — NOT NULL

ATTRACTION (관광지 정보)

  • content_id — INT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • type_id — INT — NOT NULL
  • address — VARCHAR(255)
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • description — TEXT
  • tel — VARCHAR(20)
  • homepage — VARCHAR(255)

PARKING_BOOKMARK (주차장 즐겨찾기)

  • parking_id — INT — Foreign key → PARKING_LOT.parking_id — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → USER.user_id — NOT NULL
  • bookmarked_at — DATETIME — NOT NULL

PARKING_LOT (주차장 정보)

  • parking_id — INT — Primary key — NOT NULL
  • content_id — INT — Foreign key → ATTRACTION.content_id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • address — VARCHAR(255)
  • latitude — DECIMAL(10, 7) — NOT NULL
  • longitude — DECIMAL(10, 7) — NOT NULL
  • total_spots — INT — NOT NULL
  • current_spots — INT
  • operating_time — VARCHAR(100)

PARKING_PREDICTION (주차 가능성 정보)

  • pred_id — INT — Primary key — NOT NULL
  • parking_id — INT — Foreign key → PARKING_LOT.parking_id — NOT NULL
  • prediction_time — DATETIME — NOT NULL
  • prediction_result — VARCHAR(10) — NOT NULL
  • confidence — DECIMAL(5, 2)
  • created_at — DATETIME — NOT NULL

PARKING_REVIEW (주차장 리뷰ㅜ)

  • review_id — INT — Primary key — NOT NULL
  • parking_id — INT — Foreign key → PARKING_LOT.parking_id — NOT NULL
  • user_id — VARCHAR(50) — Foreign key → USER.user_id — NOT NULL
  • rating — DECIMAL(2, 1) — NOT NULL
  • content — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

PHOTO (관광지 사진)

  • photo_id — INT — Primary key — NOT NULL
  • content_id — INT — Foreign key → ATTRACTION.content_id — NOT NULL
  • url — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)

USER (사용자)

  • user_id — VARCHAR(50) — Primary key — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • user_name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • join_date — DATETIME — NOT NULL