그린루트
테이블 (8)
Category (Category1)
- category1_id — int — 기본 키 — NOT NULL
- category1 — string
Category2
- category2_id — int — 기본 키 — NOT NULL
- category2 — string
Hashtags
- hashtags_id — int — 기본 키 — NOT NULL
- hashtag — string
Place
- place_id — int — 기본 키 — NOT NULL
- route_id — int — 외래 키 → Route_places.route_id — NOT NULL
- place_name — string
- address — string
- place_like — int
- category1_id — int — 외래 키 → Category.category1_id — NOT NULL
- category2_id — int — 외래 키 → Category2.category2_id — NOT NULL
Route
- route_id — int — 기본 키 — NOT NULL
- startpoint_name — string
- startpoint_address — string
- endpoint_name — string
- endpoint_address — stri ng
- date — date
- user_id — int — 외래 키 → User.user_id — NOT NULL
Route_places
- route_id — int — 외래 키 → Route.route_id — NOT NULL
- user_like — boolean
Route_tags
- route_id — int — 외래 키 → Route.route_id — NOT NULL
- hashtags_id — int — 외래 키 → Hashtags.hashtags_id — NOT NULL
User
- user_id — int — 기본 키 — NOT NULL
- nickname — string
- id — string
- password — string