May 2018
Beginner to intermediate
452 pages
11h 26m
English
We need to create the following three lookup tables:
Add the SQL query for creating these tables to create_db.sql as follows:
CREATE TABLE labs (id CHAR(1) PRIMARY KEY);CREATE TABLE lab_techs (id SMALLINT PRIMARY KEY, name VARCHAR(512) UNIQUE NOT NULL);CREATE TABLE plots (lab_id CHAR(1) NOT NULL REFERENCES labs(id), plot SMALLINT NOT NULL, current_seed_sample ...