Member Info

Tables (7)

Category (category)

  • Category_ID (category_id) — int — Primary key — NOT NULL
  • Parent_ID (parent_id) — int — Primary key — NOT NULL
  • Name (name) — varchar

Category_Item (category_item)

  • Category_ID (category_id) — int — Foreign key → Category.Category_ID — NOT NULL
  • Item_ID (item_id) — int — Foreign key → Item.Item_ID — NOT NULL

Delivery (delivery)

  • Delivery_ID (delivery_id) — int — Primary key — NOT NULL
  • City (city) — varchar
  • Street (street) — varchar
  • Zipcode (zipcode) — varchar
  • Status (status) — varchar

Item (item)

  • Item_ID (item_id) — int — Primary key — NOT NULL
  • Name (name) — varchar
  • Price (price) — int
  • StockQuantity (stockquantity) — int

Member (member)

  • Member_ID (member_id) — int — Primary key — NOT NULL
  • Name (name) — varchar
  • CIty (city) — varchar
  • Street (street) — varchar
  • Zipcode (zipcode) — varchar

Order_Item (order_item)

  • Orders_ID (orders_id) — int — Foreign key → Orders.Orders_ID — NOT NULL
  • Item_ID (item_id) — int — Foreign key → Item.Item_ID — NOT NULL
  • OrderPrice (orderprice) — int
  • Count (count) — int

Orders (orders)

  • Orders_ID (orders_id) — int — Primary key — NOT NULL
  • Member_ID (member_id) — int — Foreign key → Member.Member_ID — NOT NULL
  • Delivery_ID (delivery_id) — int — Foreign key → Delivery.Delivery_ID — NOT NULL
  • OrderDate (orderdate) — date
  • Status (status) — varchar