Hello, I'm currently building a e-commerce site from scratch.
I've built a library administration before but e-comm is something new for me so,
It's dynamic web using PHP, and sql database using PDO.
I've built the database, and I'm confused about something here.
My e-comm will have 2 kind of users operating in admin level. One is managing the sales, another managing the storage.
and I separate the login table from the admins, I wonder if it's the right choice or not. :mellow:
My question is:
Should I just make a table for admins with admin_level collumn and link it with admin_level table for deciding what kind of user are they.
or Just make 2 different table for sales_admin and storage_admin?
which one would be more efficient?
fyi these are my table now:
item_name [name_id, name, type_id, stocks, id_imgPath]
item_type [type_id, type]
items [item_id, name_id]
itemImgPath [id_imgPath]
admin [id, name, gender, address, level_id, etc]
admin_level [level_id, level]
login[id, admin_id, username, password]
couldn't find the right keyword on google, might try to ask here
hope you can help, really confused, it's first time I make login system with two different kind of users.
sorry for bad english.