caujmtgr
Tables (4)
Restaurant
- id (Key) — Primary key — NOT NULL
- name (Field)
- location (Field2)
- type (Field3)
- phone (Field4)
- mainmenu (Field5)
- Field6
- closeTime (Field7)
Restaurant_picture
- id (Key) — r_id — Foreign key → Restaurant.id — NOT NULL
- Field — auto_increment
- link (Field2)
User
- id (Key) — Primary key — NOT NULL
- name (Field)
- email (Field2)
- passwd (Field3)
User_review
- id (key1) — user id — Foreign key → Restaurant.id — NOT NULL
- id (Key4) — restaurant id — Foreign key → User.id — NOT NULL
- star (Field)
- comment (Field2)
- day (Field3)