favoritMap
Tables (5)
Mycollection (컬렉션)
- Key (c_id) — Primary key — NOT NULL
- Field (name)
- Field2 (color)
- Field (createDt)
- Field2 (is_share)
- Key (user_id) — Foreign key → user.Key — NOT NULL
collection_place (컬렉션에 포함된 장소)
- Key (id) — Primary key — NOT NULL
- Key (c_id) — Foreign key → Mycollection.Key — NOT NULL
- Key (place_id) — Foreign key → place.Key — NOT NULL
- Field (create_date)
place (장소)
- Key (place_id) — Primary key — NOT NULL
- Field (name)
- Field2 (lng)
- Field3 (lat)
- Field (country)
place_submissions (장소제보)
- Key (id) — Primary key — NOT NULL
- Field (name)
- Field2 (desc)
- Field (lat)
- Field2 (lng)
- Key (user_id) — Foreign key → user.Key — NOT NULL
- Field (is_approved)
- Field2 (status)
- Field (approve_date)
- Field (create_date)
user (유저테이블)
- Key (user_id) — Primary key — NOT NULL
- Field (email)
- Field2 (password)
- Field3 (nickname)