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)