outsourcing

Tables (5)

Menu (menus)

  • Menu Id (menu_id) — bigint — Primary key — NOT NULL
  • Name (menu_name)
  • Price (menu_price)
  • Type (menu_type)
  • SoldOut (sold_out) — boolean
  • Status (status) — boolean
  • CreatedAt (created_at)
  • ModifiedAt (modified_at)
  • Store Id (store_id) — bigint — Foreign key → Store.Store Id — NOT NULL

Order (orders)

  • Order Id (order_id) — bigint — Primary key — NOT NULL
  • Process (process)
  • TotalPrice (total_price) — int
  • CreatedAt (created_at)
  • ModifiedAt (modified_at)
  • User Id (user_id) — bigint — Foreign key → User.User Id — NOT NULL
  • Store Id (store_id) — bigint — Foreign key → Store.Store Id — NOT NULL

Review (reviews)

  • Review Id (review_id) — bigint — Primary key — NOT NULL
  • Username (username) — varchar(20)
  • Content (content) — Text
  • Star (star) — int
  • Order Id (order_id) — bigint — Foreign key → Order.Order Id — NOT NULL
  • Store Id (store_id) — bigint — Foreign key → Store.Store Id — NOT NULL

Store (stores)

  • Store Id (store_id) — bigint — Primary key — NOT NULL
  • Name (store_name)
  • OpenTime (open_time)
  • CloseTime (close_time)
  • MinPrice (min_price)
  • Status (status) — boolean
  • CreatedAt (created_at)
  • ModifiedAt (modified_at)
  • User Id (user_id) — bigint — Foreign key → User.User Id — NOT NULL

User (users)

  • User Id (user_id) — bigint — Primary key — NOT NULL
  • Email (email) — varchar
  • Password (password) — varchar(20)
  • Username (username) — varchar(20)
  • Authority (authority)
  • Status (status) — boolean
  • Address (address) — varchar(50)
  • Telephone (telephone) — varchar(20)