sufehmi

YUDISTIRA : more robust metadata

Feb 14th, 2020
175
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  
  2. SUMMARY
  3.  
  4. To make our data more robust and more useful as machine-learning materials, we need to provide more metadata to it.
  5.  
  6. We need the following new metadata :
  7.  
  8. 1/ theme : what's the theme of this particular hoax, for example: politics, religious, health related, etc.
  9. Type: tags, may be multiple, separated by comma : varchar(30)
  10.  
  11. 2/ hoax_component : which part of the message is the hoax ? for example: image / text / video / audio / or combinations of these
  12. Type: enum, image / video / text / audio / textimage / textvideo / textaudio / imagevideo / imageaudio / audiovideo / textvideoimage / othercombination
  13.  
  14. 3/ target_audience : who's the target audience of this particular hoax ? for example : female / male / elder / milennials / etc
  15. Type: tags, may be multiple, separated by comma : varchar(50)
  16.  
  17. 4/ modus_operandi : how does this hoax spread ? for example: fear / election / etc
  18. Type: tags, may be multiple, separated by comma : varchar(50)
  19.  
  20. We also need a new field but not related to metadata, this is needed to make Yudistira more effective as our main anti-hoax database, by enabling it to automatically posts to all of our social media channels automatically :
  21.  
  22. a/ twitter_post : anything input in here will be posted to Twitter. We can not post the whole record due to Twitter's text length limitation. So our fact-checker will need to compose it here.
  23. Type: varchar (280)
  24.  
  25. b/ twitter_post_status : whether this post has been posted to twitter or not
  26. Type: boolean
  27.  
  28. c/ facebook_post_status : whether this post has been posted to twitter or not
  29. Type: boolean
  30.  
  31. The whole Yudistira application & portion of its database will be provided as sample.
  32.  
  33. =================
  34. INPUT
  35.  
  36. On "Add Data" menu https://yudistira.turnbackhoax.id/Main_data/add , add those fields (point 1 to 4, and point a)
  37.  
  38. Empty fields are permitted - except on twitter_post & hoax_component
  39.  
  40. On "Edit Data" https://yudistira.turnbackhoax.id/main_data/edit/3594 make sure those fields are shown as well
  41.  
  42.  
  43. =================
  44. PROCESS
  45.  
  46. Table structures :
  47.  
  48. ----
  49. table metadata :
  50.  
  51. uid : bigint, auto increment
  52. antihoax_id : bigint : links to the main record in antihoax table
  53. theme : varchar(30)
  54. hoax_component : enum (see point 2)
  55. target_audience : varchar(50)
  56. modus_operandi : varchar(50)
  57.  
  58. primary index on uid
  59. index on each fields
  60.  
  61. ----
  62. table social_media_post
  63.  
  64. uid : bigint, auto increment
  65. antihoax_id : bigint : links to the main record in antihoax table
  66. twitter_post : varchar(280)
  67. twitter_post_status : boolean
  68. facebook_post_status : boolean
  69.  
  70. primary index on uid
  71. index on antihoax_id
  72.  
  73.  
  74.  
  75. =================
  76. OUTPUT
  77.  
  78. All data input are stored properly on the related tables.
RAW Paste Data