The following table is part of my project. I'm really strict about field types and store engines. I've read a lot of questions from this site, but I think there are a lot to do in the first step. Is there anything wrong with below fields and/or their relationship? Thanks in advance.
Based on the comments to your question, I would strongly recommend using InnoDB since it is ACID complaint and supports your foreign key layout.
When it comes to using InnoDB:
As for the log table you have that uses the ARCHIVE storage engine, keep in mind
As for SELECTs, you must tune the SELECTs to take proper advantage of table indexes. Otherwise, add the appropriate indexes to the tables.