We have multiple category, subcategory and product tables which could be stored in multiple relational tables or even in 1 table itself. Issue is when we are inserting bulk data , its bit difficult to handle in retool.
Can you help me in decision making should i create my database by keep ids relationship or storing names directly which could add redundant data also for longer run?