PHP MySQL图像表

Question

what is the best way to construct an image table in which each user has his own photo album. what I did so far is create a user table with id, username, name etc. fields. I am confused how to construct the image table which will contain all the photos of the users.

any suggestions

Answer 1

CREATE TABLE user_images (
    id INT AUTO_INCREMENT,
    user_id INT REFERENCES user (id),
    image_name VARCHAR(30) NOT NULL,
    image_data BLOB
);