■
CREATE TABLE whiteboards (
id bigserialc NOT NULL ,
name CHAR(50) NOT NULL,
reflection_date DATE,
PRIMARY KEY (id)
);
CREATE TABLE viewpoints (
id bigserial NOT NULL,
name CHAR(50) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE tags (
id bigserial NOT NULL,
whiteboard_id INT,
viewpoint_id INT,
content TEXT NOT NULL,
PRIMARY KEY (id)
);
ALTER TABLE tags ADD FOREIGN KEY (whiteboard_id) REFERENCES whiteboards (id);
ALTER TABLE tags ADD FOREIGN KEY (viewpoint_id) REFERENCES viewpoints (id);
