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