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