test

Tables (4)

OrderDetails (주문상세내역)

  • OrderDetailID (Key) — Primary key — NOT NULL
  • OrderID (Key2) — Foreign key → Orders.OrderID — NOT NULL
  • CustomerID (Key22) — Foreign key → Orders.CustomerID — NOT NULL
  • Key (Key3) — Foreign key → Products.ProductID — NOT NULL
  • Quantity (Field)
  • Subtotal (Field2)

Orders (주문)

  • OrderID (Key) — Primary key — NOT NULL
  • CustomerID (Key2) — Foreign key → customers.CustomerID — NOT NULL
  • OrderDate (Field)
  • TotalAmount (Field2)

Products (상품)

  • ProductID (Key) — Primary key — NOT NULL
  • Name (Field2)
  • Price (Field3)
  • Stock (Field4)

customers (고객)

  • CustomerID (Key) — Primary key — NOT NULL
  • Name (Field)
  • Email (Field2)
  • Phone (Field3)