motticle

Tables (6)

Article (Untitled)

  • id — Primary key — NOT NULL
  • member_id (Key) — Foreign key → Member.id — NOT NULL
  • title (Field)
  • type (enum)
  • content (Enum)
  • memo (Field3)
  • isPublic (Field2) — Boolean
  • Field4

Article_Tag (Untitled5)

  • id (Key2) — Primary key — NOT NULL
  • tag_id (Key) — Foreign key → Tag.id — NOT NULL
  • article_id (2) — Foreign key → Article.id — NOT NULL

Member (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • nickname — Varchar
  • gender_type (Field4) — ENUM
  • providerId (Field2)
  • provider (Field3)
  • refreshToken (Field)

Report (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → Member.id — NOT NULL — 신고자 id
  • article_id (2) — Foreign key → Article.id — NOT NULL
  • content (Field)

Scrap (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • id (memberId) — Foreign key → Member.id — NOT NULL
  • id (ArticleId) — Foreign key → Article.id — NOT NULL

Tag (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → Member.id — NOT NULL
  • name (Field)