Bingrae_db

Tables (8)

Board (board)

  • ID (board_id) — Primary key — NOT NULL
  • Title (board_title) — NOT NULL
  • Date (board_date) — NOT NULL
  • Content (board_content) — NOT NULL
  • User_ID (user_id) — Foreign key → User.ID — NOT NULL
  • Photo (board_image)
  • Type (board_type)

Board_Reply (board_reply)

  • Admin_ID (user_id) — Foreign key → User.ID — NOT NULL
  • Board_ID (board_id) — Foreign key → Board.ID — NOT NULL
  • Content (reply_content) — NOT NULL

Category (category)

  • ID (category_id) — Primary key — NOT NULL
  • Name (category_name) — NOT NULL
  • Image (category_image) — NOT NULL

Information (info)

  • ID (prod_id) — Primary key — NOT NULL
  • Sugar (sugar) — double — NOT NULL
  • Fat (fat) — double — NOT NULL
  • Cholesterol (cholesterol) — double — NOT NULL
  • Transfat (transfat) — double — NOT NULL
  • Protein (protein) — double — NOT NULL
  • Sodium (sodium) — double — NOT NULL

Order (order)

  • ID (order_id) — Primary key — NOT NULL
  • Date (order_date) — NOT NULL
  • User_ID (user_id) — Foreign key → User.ID — NOT NULL
  • Confirm (order_confirm) — boolean — NOT NULL

Order_Detail (order_detail)

  • Order_ID (order_id) — Foreign key → Order.ID — NOT NULL
  • Product_ID (prod_id) — Foreign key → Product.ID — NOT NULL
  • Quantity (order_quantity) — Int — NOT NULL

Product (prod)

  • ID (prod_id) — Primary key — NOT NULL
  • Name (prod_name) — NOT NULL
  • Flavor (flavor) — NOT NULL
  • Image (prod_image)
  • Category (category_id) — Foreign key → Category.ID — NOT NULL
  • Information (prod_info) — Foreign key → Information.ID — NOT NULL
  • Price (prod_price) — Int — NOT NULL
  • Stock (stock) — Int — NOT NULL

User (user)

  • ID (user_id) — Primary key — NOT NULL
  • Name (user_name) — NOT NULL
  • Phone (user_phone) — NOT NULL
  • Email (user_email)
  • Address (user_address) — NOT NULL
  • Admin (user_admin) — Boolean — NOT NULL
  • Password (user_password) — NOT NULL