storing images
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
Subject
Written By
Posted
storing images
May 11, 2021 07:13AM
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.