Assuming you have ...
subscribe2( custid int unsigned primary key auto_increment, ... ),
... I think you want ...
create table mygallery2(
gallerid int unsigned primary key auto_increment, -- PK
custid int unsigned not null, -- FK
refnbr int not null,
pseudo varchar(?) not null, -- NEED LENGTH
musician varchar(?) not null, -- NOTE 1
nickname varchar not null, -- ditto
group1 varchar not null, -- NEEDS LENGTH, NOTE 2
description varchar not null, -- NEEDS LENGTH
status varchar not null, -- NEEDS LENGTH OR SHOULD BE INT?
date date not null, == NOT varchar!!!
price decimal(10,2) not null, -- ditto
picture varchar not null, -- SHOULD NE BLOB OR NAME OF FILE ON DISK
email varchar not null, -- needs length
foreign key(custid) references subscribe2(custid)
);
note 1: Musicians to reps & works is 1:many, so this should probably be an int unsigned foreign key to a musicians lookup table.
note 2: Musicians to groups likewise, so this should probably be a int unsigned foreign key to a groups lookup table.