0917

Tables (6)

Copy Of comments (CopyOfcomments)

  • comment_id — int — Primary key — NOT NULL
  • comment — varchar — NOT NULL
  • review_id — int — NOT NULL
  • user_id — int — NOT NULL

Copy Of foods (CopyOffoods)

  • food_id — int — Primary key — NOT NULL
  • food_name — varchar — NOT NULL
  • food_price — integer
  • stored_id — int — NOT NULL

Copy Of reviews (CopyOfreviews)

  • review_id — int — Primary key — NOT NULL
  • review_title — varchar — NOT NULL
  • review_contents — archar — NOT NULL
  • review_star_rating — float
  • review_image_route — varchar
  • user_id (user_id2) — int — NOT NULL
  • stored_id — int — NOT NULL

Copy Of store (CopyOfstores)

  • stored_id — int — Primary key — NOT NULL
  • store_name — varchar — NOT NULL
  • store_address — varchar
  • store_gps_latitude — varchar
  • store_gps_longitude (store_gps_longtitude) — varchar
  • store_star_rating — float
  • store_category — varchar — NOT NULL
  • store_model_route — varchar — NOT NULL
  • store_image — varchar
  • store_issuance_number — integer — NOT NULL

Copy Of users (CopyOfusers)

  • user_id — int — Primary key — NOT NULL
  • user_name (name) — varchar
  • user_password — varchar — NOT NULL
  • user_phonenumber — integer
  • user_birthday — varchar
  • Field

order (CopyOforder)

  • id (order_id) — int — Primary key — NOT NULL
  • order_time — varchar — NOT NULL
  • EA — integer — NOT NULL
  • user_id — int — NOT NULL
  • user_id (user_address) — varchar — NOT NULL
  • user_id (user_phonenumber) — varchar — NOT NULL
  • food_id — int — NOT NULL