Is it necessary to prefix sub tables with main table names only if you use custom databases, or it is also necessary if you use Database Manager?
I don’t think I ever use this naming convention. Eg if I had these tables:
customers > orders > order items
… if I understand correctly, I would have to have to name the last table something like orders_orderitems. If I wanted to create a query with orders nested within customers, does that mean I would have to name the orders table, customers_orders (and therefore rename the last table customers_orders_orderitems)?
I’ve probably misunderstood how the new feature works. and perhaps it’s not in fact necessary to adopt this naming convention.
(I don’t think I ever think about ‘sub tables’ - perhaps ‘child tables’ but it’s a matter of context.)
Last updated: