taskcafe/migrations/0012_add-project-label-table.up.sql

8 lines
275 B
MySQL
Raw Permalink Normal View History

2020-04-21 01:04:27 +02:00
CREATE TABLE project_label (
project_label_id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
project_id uuid NOT NULL REFERENCES project(project_id),
label_color_id uuid NOT NULL REFERENCES label_color(label_color_id),
created_date timestamptz NOT NULL,
name text
);