Butteryum

Tables (6)

rpjt_country (CopyOfUntitled2)

  • country_id (Key) — INT(11) — Primary key — NOT NULL
  • country_code (Field) — VARCHAR(75)
  • description (Field2) — TEXT
  • created_dt (Field3) — DATETIME
  • created_by (Field4) — INT(11)
  • dbstatus (Field5) — SMALLINT(5)
  • updated_dt (Field6) — DATETIME
  • updated_by (Field7) — INT(11)

rpjt_file_media (CopyOfUntitled)

  • file_id (Key) — INT(11) — Primary key — NOT NULL
  • media_type — VARCHAR(75)
  • label — VARCHAR(255)
  • value — VARCHAR(75)
  • params (Field4) — TEXT
  • ordering (Field5) — INT(11)
  • created_dt (Field6) — DATETIME
  • created_by (Field7) — INT(11)
  • dbstatus (Field8) — SMALLINT(5)
  • updated_dt (Field9) — DATETIME
  • updated_by (Field10)

rpjt_like (Untitled3)

  • like_id (Key) — INT(11) — Primary key — NOT NULL
  • type (Field) — VARCHAR(75)
  • item_id (Field2) — INT(11)
  • user_id (Field3) — INT(11)
  • created_dt (Field4) — DATETIME
  • created_by (Field5) — INT(11)
  • dbstatus (Field6) — SMALLINT(5)
  • updated_dt (Field7) — DATETIME
  • updated_by (Field8) — INT(11)

rpjt_user_groups (Untitled)

  • group_id (Key) — INT(11) — Primary key — NOT NULL
  • name — VARCHAR(75)
  • description — TEXT
  • created_dt — DATETIME
  • created_by — INT(11)
  • dbstatus — SMALLINT(5)
  • updated_dt — DATETIME
  • updated_by — INT(11)

rpjt_video (CopyOfUntitled3)

  • video_id (Key) — INT(11) — Primary key — NOT NULL
  • status — VARCHAR(75) — Primary key
  • thumbnail — DATETIME — Primary key
  • creator_id (Field3) — INT(11) — Primary key
  • country_id (Field4) — INT(11) — Primary key
  • difficulty_id (Field5) — INT(11) — Primary key
  • title — VARCHAR(255)
  • video_url — VARCHAR(255)
  • youtube_id (Field) — VARCHAR(255)
  • description (Field2) — TEXT
  • allow_comment (Field6) — SMALLINT(5)
  • allow_rate (Field7) — SMALLINT(5)
  • total_view (Field8) — INT(11)
  • total_comment (Field9) — INT(11)
  • total_rating (Field10) — DECIMAL(20,4)
  • total_like (Field11) — INT(11)
  • is_weekly_challenges (Field12) — SMALLINT(5)
  • created_dt (Field13) — DATETIME
  • created_by (Field14) — INT(11)
  • dbstatus (Field15) — SMALLINT(5)
  • updated_dt (Field16) — DATETIME
  • updated_by (Field17) — INT(11)

rpjt_video_status_history (Untitled2)

  • history_id (Key) — INT(11) — Primary key — NOT NULL
  • video_id (Key2) — INT(11) — Foreign key → rpjt_video.video_id — NOT NULL
  • status — VARCHAR(75) — Foreign key → rpjt_video.status
  • status (Field2) — VARCHAR(75)
  • note (Field3) — TEXT
  • created_dt (Field4) — DATETIME
  • created_by (Field5) — INT(11)
  • dbstatus (Field6) — SMALLINT(5)
  • updated_dt (Field7) — DATETIME
  • updated_by (Field8) — INT(11)