LLM2

Tables (3)

Customers (고객)

  • Customer_ID — Int — Primary key — NOT NULL
  • Customer_name — Varchar
  • Customer_email — Varchar
  • Customer_phone — Int
  • Customer_city — Varchar
  • Customer_state — Varchar

Order (주문)

  • Order_ID — Primary key — NOT NULL
  • Customer_ID — Int — Foreign key → Customers.Customer_ID — NOT NULL
  • Order_date

Products (상품)

  • SKU — Primary key — NOT NULL
  • Product_name
  • Category
  • Unit_price