kr.ac.bu.capstoneDesign

Tables (4)

comment (코멘트)

  • user_email (PK) — not null — Foreign key → user.user_email — NOT NULL
  • store_id (PK1) — not null — Foreign key → store.store_id — NOT NULL
  • comment_contents (contents) — null
  • comment_date (date) — null
  • comment_scope (scope) — not null

route (경로)

  • route_id (id) — not null — Primary key — NOT NULL
  • route_longitude (longitude) — not null
  • route_latitude (latitudev) — not null
  • route_waypoint (waypoint) — null
  • route_name (name) — not null

store (상점)

  • store_id (id) — not null — Primary key — NOT NULL
  • store_name (name) — not null
  • store_category (category) — not null
  • store_x (longitude) — not null
  • store_y (latitude) — not null
  • store_url (url) — null

user (사용자)

  • user_email (email) — not null — Primary key — NOT NULL
  • user_phone (phone) — not null
  • user_pass (pass) — not null
  • user_nick (nick) — not null
  • user_grid (grid) — not null