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