Database Model For A Yii2 Project

Yii 2.0 General Discussions
1

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?

vendor_id

name

short_description

long_description

start_date

price_range

type_id

is_veg

is_nonveg

parent_vendor_id

is_halal

is_active

address_line_1

address_line_2

muncipality_id

province_id

postalcode

country_id

latitude

longitude

email

contact_number

image

delivery_charge

youtube_link

twitter_link

resaturant_map

facebook_link

deliver_distance

hotel_information

approximate_cost

web_site

2

I use has_one relations to vertically split a table separating and grouping columns that are often null and/or have similar function.

3

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.