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