store sequence of images to a particular id in a database

Vote count:

0

TABLE imagedetails (
  imageid INTEGER PRIMARY KEY, 
  imagename VARCHAR(50),
  studyid INTEGER,    
  FOREIGN KEY(studyid) REFERENCES study(studyid)
);

INSERT INTO imagedetails VALUES (1,'img1.jpg',1);
INSERT INTO imagedetails VALUES (2,'img2.jpg',2);
INSERT INTO imagedetails VALUES (3,'imp3.jpg',3);
INSERT INTO imagedetails VALUES (4,'img4.jpg',4);

right now the images are stored on the server, how would i store multiple images related to a specific Id

asked 2 mins ago

user2675364

11

store sequence of images to a particular id in a database