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)