deploy/article_taggings.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

-- Deploy diary:article_taggings to pg
-- requires: schema
-- requires: tags
-- requires: articles

BEGIN;

SET search_path to diary;

CREATE TABLE article_taggings(
  article_id UUID REFERENCES articles(id),
  tag_id INT REFERENCES tags(id),
  PRIMARY KEY(article_id, tag_id)
);

COMMIT;