CODEWITHSUNDEEP
mysqldatabase
Ibrahim Azhar Armar
Ibrahim Azhar Armar

Reputation: 25745

Best way to store records in database tables with common fields

I have several database tables such as.

Which have common column names.

What is the best way to store such records ? store in spit tables or one table ? what is the standard practice ?

BTW, I am using MySQL with Doctrine ORM.

Thanks

Upvotes: 0

Views: 81

Answers (1)

Jithil P Ponnan
Jithil P Ponnan

Reputation: 1247

Thinking about scalability,performance and new enhanced features(like LINQ) integration; store in split tables and identifying with foreign key will be much better choice.

Eg: You can integrate searching with better performance speed. The re usability will be also good as, if you want to add an item in future, will not be caused the existing data.

Upvotes: 1

Related Questions