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)