I’m using following columns for my table vendor. Is it fine to use this much columns in a single table in yii2 project? Please give me some suggestions if a better database model is there?
To give an answer we need to know the whole database structure…
If you only use a vendor table and not for example a customer table
It would be allright.
If you use Adresses, Mail, Images in several other tables (Vendor, Customer, Sales), You’d beter create a user table. and vendor specific Fields in a vendor table with an user_ID related to the user table.
If a vendor has several addresses (Invoice, location) then seperate the address information as well and create a seperate table with vendor_id and address_id.