ohh, by the way - I just spoke with a company today and they want us to import all their transactions - and they have 27,000 transactions.
That is just one company - so it is a lot of data - and I hope to have thousands of companies!!
okay, I thought if lets say I have two companies:
id:1 = Company A
id:178 = Company B
I could just do a SQL string like
select from transactions_table0000001 (compnay A)
select from transactions_table0000178 (company B)
And have all company main information (id etc) on a shared table.
But I...
Thanks for the feedback I really appreciate it.
My database is going to host individual companies, but there are many other tables in the database, but the most important one is the transactions table. They are all important, but thought of doing some extra security to the transaction table...
Hi,
I am new to designing large databases. I could use some advice regarding the best database structure.
We are in a database design plan, so how would be the best way to do this.
I have a table, called transactions and this table holds all financial transactions within a company.
Our plan...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.