Query them separately, sort them by creation date before serializing into JSON. It would end up with this kind of code : activity = Activity.find(1)Ĭreate 3 different tables: status_activity, transfer_activity and metadata_activity. left table, plus additional columns containing data from the right table. Whether you manage a single database or a dozen, the app’s easy-to-use interface and soothing appearance take the hassle out of your workflow. status (enum )ĭoesn't look great if I want to add a new kind of activity event, I will have to create an extra column for each row. An enum defining matching rules on the final column to match by in as-of join. TablePlus is a powerful and friendly GUI tool for relational databases, designed to give you a convenient hub for overseeing your SQL.I have a table named letter with information as follow : > ENUM('RED','GREEN','BLUE','YELLOW','ORANGE','PINK') Ĭheck the description of the table to ensure that the values are added or not.I am trying to implement a activity tracking system in Ruby on Rails for an API only application. Native, fast
0 Comments
Leave a Reply. |