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