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