그린루트

테이블 (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