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)