storing images
Posted by: Dimitris Papageorgiou
Date: May 11, 2021 07:13AM

I need to store in the db the images of staff of businesses...for example a hair salon might have as staff maria and jane...and I need to store their images.
I need to store the file paths only..the images will be in a dir..so,,this is the staffList table

CREATE TABLE `staff_list` (
`staff_ID` int unsigned NOT NULL AUTO_INCREMENT,
`st_name` varchar(255) NOT NULL,
`business_user_id` mediumint unsigned NOT NULL,
PRIMARY KEY (`staff_ID`),
KEY `fk_staff_business_users1_idx` (`business_user_id`),
CONSTRAINT `staff_to_buser` FOREIGN KEY (`business_user_id`) REFERENCES `business_users` (`bus_user_ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8

Do I just need to add column image_file_path..is this going to be OK..?if yes what col datatype...
varchar
Do I need a separate table that will reference the above...what cols is should have?

Thanks

Options: ReplyQuote


Subject
Written By
Posted
storing images
May 11, 2021 07:13AM
May 11, 2021 02:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.