MemberInfo

Tables (7)

CATEGORY (카테고리)

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

CATEGORY_ITEM (상품카테고리)

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

DELIVERY (배송)

  • DELIVERY_ID — VARCHAR — Primary key — NOT NULL
  • CITY — VARCHAR
  • STREET — VARCHAR
  • ZIPCODE — CHAR
  • STATUS — VARCHAR

ITEM (상품)

  • ITEM_ID — VARCHAR — Primary key — NOT NULL
  • NAME — VARCHAR
  • PRICE — NUMBER
  • STOCKQUANTITY — NUMBER

MEMBER

  • MEMBER_ID — VARCHAR — Primary key — NOT NULL
  • NAME — VARCHAR
  • CITY — VARCHAR
  • STREETS (STREEET) — VARCHAR
  • ZIPCODE — CHAR

ORDERS (주문)

  • ORDER_ID — VARCHAR — Primary key — NOT NULL
  • ORDERDATE — DATE
  • STATUS — VARCHAR
  • MEMBER_ID — VARCHAR — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • DELIVERY_ID — VARCHAR — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL

ORDER_ITEM (주문상품)

  • ORDER_ITEM_ID — VARCHAR — Primary key — NOT NULL
  • ORDERPRICE — NUMBER
  • COUNT — NUMBER
  • ORDER_ID — VARCHAR — Foreign key → ORDERS.ORDER_ID — NOT NULL
  • ITEM_ID — VARCHAR — Foreign key → ITEM.ITEM_ID — NOT NULL