pamisol
Tables (6)
AppUser (user)
- ID (id) — INT — Primary key — NOT NULL
- ISMANAGER (is_manager) — INT
- NAME (name) — VARCHAR
- PASSWORD (password) — CHAR
- MAIL (mail) — CHAR
Comment (Untitled3)
- ID (id) — INT — Primary key — NOT NULL
- USER (user) — INT
- IMAGE (image) — VARCHAR
- CREATE_AT (create_at) — CHAR
- UPDATE_AT (update_at) — CHAR
- TEXT (text) — VARCHAR
- MENU (menu) — INT — Foreign key → Menu.ID — NOT NULL
Follow (Untitled5)
- ID (id) — INT — Primary key — NOT NULL
- FOLLOER (follower) — INT — Foreign key → AppUser.ID — NOT NULL
- FOLLOWED (followed) — INT — Foreign key → AppUser.ID — NOT NULL
Menu (Untitled2)
- ID (id) — INT — Primary key — NOT NULL
- NAME (name) — VARCHAR
- R_NAME (r_name) — VARCHAR
- PRICE (price) — INT
- IMAGE (image) — VARCHAR
- DESCRIPTION (description) — VARCHAR
- GRADE (grade) — INT
- RESTAURANT (restaurant) — INT — Foreign key → Restaurant.ID — NOT NULL
Notice (Untitled4)
- ID (id) — INT — Primary key — NOT NULL
- TITLE (title) — VARCHAR
- TEXT (text) — VARCHAR
- CREATE_AT (create_at) — CHAR
- UPDATE_AT (update_at) — CHAR
- IMAGE (image) — VARCHAR
- RESTAURANT (reataurant) — INT — Foreign key → Restaurant.ID — NOT NULL
Restaurant (Untitled)
- ID (id) — INT — Primary key — NOT NULL
- NAME (name) — VARCHAR
- LOCATION (location) — DOUBLE
- PHONE (phone) — VARCHAR
- ID (manager) — INT — Foreign key → AppUser.ID — NOT NULL