jacklist

Tables (8)

Amazon_product (CopyOfUntitled22)

  • id (primary_key) — INT — Primary key — NOT NULL
  • itemCode (ForeignKey)
  • itemName (Field3) — String
  • mediumImageUrls (Field) — String
  • itemPrice (Field2) — String
  • itemUrl (Field4) — tring
  • reviewCount (Field5) — INT
  • reviewAverage (Field7) — INT

Rakuten_product (Untitled2)

  • id (primary_key) — INT — Primary key — NOT NULL
  • itemCode (ForeignKey)
  • itemName (Field3) — String
  • mediumImageUrls (Field) — String
  • itemPrice (Field2) — String
  • itemUrl (Field4) — tring
  • reviewCount (Field5) — INT
  • reviewAverage (Field7) — INT

RankList (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • date (ForeignKey) — BigINT

Yahoo_product (CopyOfUntitled23)

  • id (primary_key) — INT — Primary key — NOT NULL
  • itemCode (ForeignKey)
  • itemName (Field3) — String
  • mediumImageUrls (Field) — String
  • itemPrice (Field2) — String
  • itemUrl (Field4) — tring
  • reviewCount (Field5) — INT
  • reviewAverage (Field7) — INT

amazon_cate (CopyOfUntitled2)

  • id (primary_key) — INT — Primary key — NOT NULL
  • url (Field2) — String
  • cateName (Field) — String
  • parentId (ForeignKey) — INT
  • depth (Field4)
  • children (Field5) — array

categories (CopyOfUntitled)

  • id (primary_key) — INT — Primary key — NOT NULL
  • genreId (Field2) — INT
  • cateName (Field) — String
  • parentId (ForeignKey) — INT
  • depth (Field4)
  • children (Field5) — array
  • platform (Field3)

product_ranking (CopyOfUntitled3)

  • id (primary_key) — INT — Primary key — NOT NULL
  • date (ForeignKey) — INT — Foreign key → RankList.id — NOT NULL
  • itemCode (Foreign Key) — String — Foreign key → Rakuten_product.id — NOT NULL
  • genreId (Foreign) — INT — Foreign key → categories.id — NOT NULL
  • ranking (Field3) — INT
  • platform (Field) — INT

rakuten_cate (Untitled)

  • id (primary_key) — INT — Primary key — NOT NULL
  • genreId (Field2) — INT
  • cateName (Field) — String
  • parentId (ForeignKey) — INT
  • depth (Field4)
  • children (Field5) — array