fisa06test

Tables (3)

customer (customers)

  • c_id (고객id) — int — Primary key — NOT NULL
  • Field (고객이름) — varchar(20)
  • Field2 (멤버십 등급)
  • Field3 (공동현관 출입법)
  • Field
  • Field2
  • Field4
  • Field5
  • Field6

order

  • Key (주문번호) — int — Primary key — NOT NULL
  • Key (주문한 고객) — int — Primary key — NOT NULL
  • Key2 (주문한 상품) — Primary key — NOT NULL
  • Field (상품)
  • Field2
  • Field3
  • Field4

product

  • Key (상품id) — int — Primary key — NOT NULL
  • Field (상품명) — varchar(20)
  • Field2
  • Field3
  • Field4