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