db

docker exec -it sampler-services-mysql-1 mysql -p
mysql -h sampler-db -u root -ppassword secret

use sampler-db;
show tables;

create table users(
   userid INT NOT NULL AUTO_INCREMENT,
   email VARCHAR(225) NOT NULL,
   username VARCHAR(225) NOT NULL,
   passcode varchar(100) NOT NULL, 
   created DATETIME NOT NULL,
   PRIMARY KEY ( userid )
);


create table observations(
   observationid INT NOT NULL AUTO_INCREMENT,
   userid INT NOT NULL,
   feeling VARCHAR(225) NOT NULL,
   company VARCHAR(225) NOT NULL,
   activity varchar(225) NOT NULL, 
   created DATETIME NOT NULL,
   PRIMARY KEY ( observationid ),
    CONSTRAINT FK_UserObservations FOREIGN KEY (userid)
    REFERENCES users(userid)
    ON DELETE CASCADE
);