ASD
Tables (5)
categories (CopyOfCopyOfUntitled2)
- category_id (Key) — INT — Primary key — NOT NULL
- category_name (Field2) — VARCHAR(255)
- description (Field5) — TEXT
order_items (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- order_item_id (Key) — INT — Primary key — NOT NULL
- order_id (Key2) — INT — Foreign key → orders.order_id — NOT NULL
- user_id (Key22) — INT — Foreign key → orders.user_id — NOT NULL
- order_id (Field2) — INT
- product_id (Field5) — INT
- quantity (Field) — INT
- price (Field6) — DECIMAL(10, 2)
orders (CopyOfCopyOfCopyOfCopyOfUntitled2)
- order_id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
- user_id (Field2) — VARCHAR(100)
- total_price (Field5) — DECIMAL(10, 2)
- order_status (Field) — ENUM('Pending', 'Paid', 'Shipped', 'Cancelled')
- created_at (Field6) — TIMESTAMP
products (CopyOfCopyOfCopyOfUntitled2)
- product_id (Key) — INT — Primary key — NOT NULL
- category_id (Key2) — INT — Foreign key → categories.category_id — NOT NULL
- order_item_id (Key3) — INT — Foreign key → order_items.order_item_id — NOT NULL
- order_id (Key22) — INT — Foreign key → order_items.order_id — NOT NULL
- user_id (Key222) — INT — Foreign key → order_items.user_id — NOT NULL
- product_name (Field2) — VARCHAR(255)
- description (Field5) — TEXT
- price (Field) — DECIMAL(10, 2)
- stock (Field3) — INT
- category_id (Field4) — INT
- created_at (Field6) — TIMESTAMP
users (CopyOfUntitled2)
- user_id (Key) — VARCHAR(100) — Primary key — NOT NULL
- username (Field) — TIMESTAMP
- password (Field2) — VARCHAR(255)
- email (Field3) — VARCHAR(100)
- phone (Field4) — VARCHAR(20)
- address (Field5) — TEXT
- created_at (Field6) — TIMESTAMP