20191218

Tables (13)

CART

  • ID — Primary key — NOT NULL
  • PRODUCT_ID — Foreign key → PRODUCT.ID — NOT NULL
  • USER_ID — Foreign key → USER.ID — NOT NULL
  • CREATED_TIMESTAMP
  • STATUS

CLICK_LOG

  • ID — Primary key — NOT NULL
  • PRODUCT_ID — Foreign key → PRODUCT.ID — NOT NULL
  • USER_ID — Foreign key → USER.ID — NOT NULL
  • CLICKED_TIMESTAMP

ORDER

  • ID — Primary key — NOT NULL
  • USER_ID — Foreign key → USER.ID — NOT NULL
  • TICKET_ID — Foreign key → TICKET.ID — NOT NULL

ORDER_PRODUCT

  • ID — Primary key — NOT NULL
  • PRODUCT_ID — Foreign key → PRODUCT.ID — NOT NULL
  • ORDER_ID — Foreign key → ORDER.ID — NOT NULL

PRODUCT

  • ID — Primary key — NOT NULL
  • CLASS_ID — Foreign key → PRODUCT_CLASS.ID — NOT NULL

PRODUCT_CATEGORY

  • ID — Primary key — NOT NULL

PRODUCT_CLASS

  • ID — Primary key — NOT NULL
  • CATEGORY_ID — Foreign key → PRODUCT_CATEGORY.ID — NOT NULL

REVIEW

  • ID — Primary key — NOT NULL
  • PRODUCT_ID — Foreign key → PRODUCT.ID — NOT NULL
  • RATING
  • USER_ID — Foreign key → USER.ID — NOT NULL

SEARCH_KEYWORD

  • ID — Primary key — NOT NULL
  • USER_ID — Foreign key → USER.ID — NOT NULL

SEARCH_PRODUCT

  • ID — Primary key — NOT NULL
  • PRODUCT_ID — Foreign key → PRODUCT.ID — NOT NULL
  • KEYWORD_ID — Foreign key → SEARCH_KEYWORD.ID — NOT NULL

TICKET

  • ID — Primary key — NOT NULL
  • CREATED_TIMESTAMP
  • TYPE
  • STATUS

USER

  • ID — Primary key — NOT NULL
  • EMAIL — VARCHAR
  • PASSWORD
  • NAME
  • ADDRESS (ADDRESD)
  • CREATED_TIMESTAMP

USER_CATEGORY (USER_GATEGORY)

  • ID — Primary key — NOT NULL
  • CATEGORY_ID — Foreign key → PRODUCT_CATEGORY.ID — NOT NULL
  • USER_ID — Foreign key → USER.ID — NOT NULL