Member Info

Tables (7)

Category (category)

  • Category ID (category_id) — int — Primary key — NOT NULL
  • Parent ID (parent_id) — int — 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 (Field) — varchar

Item (item)

  • Item ID (item_id) — int — Primary key — NOT NULL
  • Name (name) — varchar
  • Price (price) — int
  • Stock Quantity (stock_quantity) — 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)

  • Order Item ID (order_item_id) — int — Primary key — NOT NULL
  • Order ID (order_id) — int — Foreign key → Orders.Order ID — NOT NULL
  • Item ID (item_id2) — int — Foreign key → Item.Item ID — NOT NULL
  • Order Price (order_price) — int
  • Count (count) — int

Orders (orders)

  • Order ID (order_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
  • Order Date (order_date) — date
  • Status (status) — varchar