MEMBER_info

Tables (7)

CATEGORY (Untitled5)

  • CATEGORY_ID — varchar — Primary key — NOT NULL
  • NAME — varchar
  • PARENT_ID — varchar

CATEGORY_ITEM (Untitled7)

  • CATEGORY_ID — varchar — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
  • ITEM_ID — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL

DEDLIVERY (Untitled4)

  • 주문번호 (DELIVERY_ID) — int — Primary key
  • 시 (CITY) — varchar — NOT NULL
  • 주소 (STREET) — varchar
  • ZIPCODE — varchar
  • 현황 (STATUS) — varchar

ITEM (Untitled6)

  • ITEM_ID — varchar — Primary key — NOT NULL
  • 제품명 (NAME) — varchar
  • 가격 (PRICE) — int
  • 재고수량 (STOCKQUANTITY) — int

MEMBER (Untitled3)

  • MEMBER_Id — varchar — Primary key — NOT NULL
  • 이름 (NAME) — varchar
  • CITY — varchar
  • STREET — varchar
  • Field

ORDERS (ORDER_ID)

  • 주문번호 (ORDER_ID) — int — Primary key — NOT NULL
  • MEMBER_Id — varchar — Foreign key → MEMBER.MEMBER_Id — NOT NULL
  • 주문번호 (DELIVERY_ID) — int — Foreign key → DEDLIVERY.주문번호
  • 주문일 (ORDERDATE) — Date
  • 현황 (STATUS) — varchar

ORDER_ITEM (Untitled)

  • ORDER_ITEM_ID — varchar — Primary key — NOT NULL
  • 주문번호 (ORDER_ID) — int — Foreign key → ITEM.ITEM_ID — NOT NULL
  • 제품명 (ITEM_ID) — int — Foreign key → ORDERS.주문번호 — NOT NULL
  • ORDERPRICE (ODERPRICE) — int
  • COUNT — int