0504 django_workshop

Tables (3)

category (Untitled2)

  • category (category_name) — VARCHAR(255) — Primary key — NOT NULL
  • cv id (cv_id) — VARCHAR(255) — Foreign key → convenience store.cv id
  • products id (products_id) — VARCHAR(255) — Foreign key → products.products id — NOT NULL

convenience store (Untitled)

  • cv id (cv_id) — VARCHAR(255) — Primary key
  • phone — BIGINT(11)
  • zip code Id (zip_code_id) — BIGINT(11)
  • status id (status_id) — BIGINT(11)
  • store name (store_id) — VARCHAR(255)

products (Untitled3)

  • products id (products_id) — VARCHAR(255) — Primary key — NOT NULL
  • Date (date) — BIGINT(11)
  • Product(s) (product(s)) — BIGINT(11)
  • Quantity (quantity) — BIGINT(11)
  • Price (price) — BIGINT(11)
  • Quantity in stock (quantity_in_stock) — BIGINT(11)
  • Quantity on order (quantity_on_order) — BIGINT(11)