I tried to make an app that allows you to post and chat by genre ~ Where I had a hard time ~

I posted an overview of the app in the previous article. From here, I would like to write an article about the difficulties I had when creating the app.

: star: Mostly starts from the genre page

First, this app selects a genre or creates it yourself
Select a genre to open the genre page
You can post on the right side of the genre page, and you can search for chat groups within the genre on the left side.
** In other words, genru_id is required for most page migration and data transmission **
** This means that most things are linked (within the genre) to the genre **

This got in the way
I searched for various methods, but there were times when something that was easy to do with that page alone did not work if it had a genre page in between.
At first I wondered why it didn't work, but most of the time, genru_id was missing (laughs).

: star: There were many intermediate tables

Please check the ER diagram below.

: sunny: Database (ER diagram)

Untitled Diagram (1)

――How many intermediate tables are there?
A => 3 (UserGenrus table / UsersGroups table / Likes table)

Actually, I tried to create another intermediate table (hope table), but since the shape was the same as the UsersGroup table, the hope table uses integer to save records. So, there are actually four.
Especially it was difficult to save the id of the group member in the UsersGroups table (laugh) Also, the reason why it was difficult to create the intermediate table was a little wrong. I plan to write another article about this area.

: star: Like function did not become JS

Speaking from the result, it became JS (laugh) But at first, I couldn't make it JS, and I ended up saying "Why!"

――Why was it made into JS?
=> JS conversion I put it on hold for the time being and proceeded with another function, and there was a hint there!

: star: Image preview of posting function (by JS)

Before posting, I previewed it so that I could check if the image matches, but this is the songwriter ... When I thought I was able to preview it, I had a hard time because the upper limit of the number of sheets did not go well (laugh)

: star2: Impressions

So far, is this the place you had a hard time coming up with? Actually, I thought I'd do the details of what I struggled with, but I'd like to change it and write an article about each function.