Determine structure of SQL tables.
I imagine at the very least it's two tables, one for paintings, one for artists.
Paintings columns:
ID Primary Key NOT NULL Auto_increment
URL VARCHAR(250) NOT NULL
(where the image lives, possibly from the MET)
Artist ID (Foreign Key)(INT) NOT NULL
Year INT(8)
Blurb (TEXT)
Country TINYTEXT
Artist:
ID: Primary Key NOT NULL AUTO_INCREMENT
Name TINYTEXT NOT NULL
Determine structure of SQL tables. I imagine at the very least it's two tables, one for paintings, one for artists.
Paintings columns: ID Primary Key NOT NULL Auto_increment URL VARCHAR(250) NOT NULL (where the image lives, possibly from the MET) Artist ID (Foreign Key)(INT) NOT NULL Year INT(8) Blurb (TEXT) Country TINYTEXT
Artist: ID: Primary Key NOT NULL AUTO_INCREMENT Name TINYTEXT NOT NULL