CRWL_DB

Tables (7)

Dim_Brand (Untitled4)

  • Model_Name (PK) — Primary key — NOT NULL
  • Model (Field)
  • Brand (Field2)

Dim_Category_Id (Untitled5)

  • Category_Id (PK) — Primary key — NOT NULL
  • Theme (Field)
  • Field2

Dim_Channel (Untitled3)

  • Channel_Id (PK) — Primary key — NOT NULL
  • Channel_Title (Field)

Dim_Date (Untitled6)

  • Timestamp (PK) — Primary key — NOT NULL
  • Year (Field)
  • Month (Field2)
  • Day (Field3)
  • DayofWeek (Field4)
  • holiday (Field5)
  • Week/Weekend (Field6)

Dim_Video (Untitled2)

  • Video_Id (PK) — Primary key — NOT NULL
  • Channel_Id (FK1) — Foreign key → Dim_Channel.Channel_Id — NOT NULL
  • Model_Name (FK2) — Foreign key → Dim_Brand.Model_Name — NOT NULL
  • Video_Title (Field)
  • Video_Description (Field2)
  • Video_Genre (Field3)

Fact_ChannerReponse (CopyOfUntitled)

  • Timestamp (FK1) — Foreign key → Dim_Date.Timestamp — NOT NULL
  • Channel_Id (FK2) — Foreign key → Dim_Channel.Channel_Id — NOT NULL
  • Subcription_counts (Field2)
  • Like_counts (Field4)
  • VIew_counts (Field5)
  • Daily_Subcription (Field)
  • Daily_Like (Field7)
  • Daily_View (Field3)

Fact_VideoResponse (Untitled)

  • Video_Id (FK1) — Foreign key → Dim_Video.Video_Id — NOT NULL
  • Category_Id (FK2) — Foreign key → Dim_Category_Id.Category_Id — NOT NULL
  • Timestamp (PK) — Foreign key → Dim_Date.Timestamp — NOT NULL
  • Comment_counts (Field2)
  • Dislike_counts (Field3)
  • Like_counts (Field4)
  • VIew_counts (Field5)
  • Daily_view (Field)
  • Daily_comment (Field6)
  • Daily_dislike (Field7)