app.articles_tags

Description

Columns

Name

Type

Default

Nullable

Children

Parents

Comment

article_id

uuid

false

app.articles

tag_id

uuid

false

app.tags

Constraints

Name

Type

Definition

articles_tags_pkey

PRIMARY KEY

PRIMARY KEY (article_id, tag_id)

Indexes

Name

Definition

articles_tags_pkey

CREATE UNIQUE INDEX articles_tags_pkey ON app.articles_tags USING btree (article_id, tag_id)

Relations

        erDiagram

"app.articles_tags" }o--|| "app.articles" : "Additional Relation"
"app.articles_tags" }o--|| "app.tags" : "Additional Relation"

"app.articles_tags" {
  uuid article_id
  uuid tag_id
}
"app.articles" {
  uuid article_id
  uuid user_id
}
"app.tags" {
  uuid tag_id
}
    

Generated by tbls