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