workshop_0504

Tables (5)

ConvenienceStore (conveniencestore)

  • ConvenienceStore_id (conveniencestroe_id) — INT(10) — Primary key — NOT NULL
  • Manager (manager) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)

Employ (employ)

  • ConvenienceStore_id (conveniencestroe_id) — INT(10) — Foreign key → ConvenienceStore.ConvenienceStore_id — NOT NULL
  • Employee_id (employee_id) — INT(10) — Foreign key → Employee.Employee_id — NOT NULL

Employee (employee)

  • Employee_id (employee_id) — INT(10) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Email (email) — VARCHAR(100)

Product (product)

  • Product_id (product_id) — INT(10) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Price (price) — INT(10)
  • Category (category) — VARCHAR(255)
  • Exp (exp) — INT(10)

StoreProduct (storeproduct)

  • Product_id (product_id) — INT(10) — Foreign key → Product.Product_id — NOT NULL
  • ConvenienceStore_id (conveniencestroe_id) — INT(10) — Foreign key → ConvenienceStore.ConvenienceStore_id — NOT NULL
  • 수량 — INT(10)