HomePage
Tables (5)
T_CART_ITEM_ID (Untitled)
- CART_ITEM_ID (Key) — Primary key — NOT NULL
- QUANTITY (Field)
- OPTION_ID (Key2) — Foreign key → T_PRODUCT_OPTION.OPTION_ID — NOT NULL
- USER_ID (Key3) — Foreign key → T_USER.USER_ID — NOT NULL
T_CATEGORY (Untitled2)
- CATEGORY_ID (Key) — Primary key — NOT NULL
- PARENT_ID (Field)
- CATEGORY_NAME (Field2)
T_PRODUCT (Untitled3)
- PRODUCT_ID (Key) — Primary key — NOT NULL
- IS_SOLD_OUT (Field)
- SELLING_PRICE (Field2)
- VIEW_COUNT (Field3)
- REG_DATE (Field5)
- NAME (Field6)
- IMAGE_URL (Field7)
- CATEGORY_ID (Key2) — Foreign key → T_CATEGORY.CATEGORY_ID — NOT NULL
T_PRODUCT_OPTION (Untitled4)
- OPTION_ID (Key) — Primary key — NOT NULL
- STOCK_QUANTITY (Field)
- SIZE_NAME (Field3)
- PRODUCT_ID (Key2) — Foreign key → T_PRODUCT.PRODUCT_ID — NOT NULL
T_USER (Untitled5)
- USER_ID (Key) — Primary key — NOT NULL
- NAME (Field) — NOT NULL
- USERNAME (Field2) — NOT NULL
- PASSWORD (Field3) — NOT NULL