test
Tables (3)
Buy (buy)
- Buy Code (buy_code) — VARCHAR(20) — Primary key — NOT NULL
- product_code (poduct_code) — VARCHAR(20) — Foreign key → Product.product_code — NOT NULL
- User Id (userid) — VARCHAR(30) — Foreign key → User Info.User Id — NOT NULL
- Buy Date (buy_date) — DATE(0)
- ZIpCode (zipcode) — int(7)
- Address (address) — VARCHAR(500)
Product (product)
- product_code (poduct_code) — VARCHAR(20) — Primary key — NOT NULL
- Size (size) — VARCHAR(6)
- Price (price) — INT(20)
- ProductName (productname) — VARCHAR(200)
User Info (user_info)
- User Id (user_id) — VARCHAR(30) — Primary key — NOT NULL
- Phone (phone) — VARCHAR(15)
- Name (user_name) — VARCHAR(50)
- User Password (user_password) — VARCHAR(50)
- Email (email) — VARCHAR(100)