sample

Tables (7)

Untitled (users)

  • Field (user_id) — Primary key
  • Field (username)
  • Field (password)
  • Field (email)
  • Field (fullname)
  • Field2 (join_date)

Untitled (style)

  • Key (style_id) — Primary key — NOT NULL
  • Field (image)
  • Field (category)

Untitled (image)

  • Key (image_id) — Primary key — NOT NULL
  • Key (style_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (article_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (user_id) — Foreign key → Untitled.Field
  • Field2 (input)
  • Field3 (output)

Untitled (article)

  • Key (article_id) — Primary key — NOT NULL
  • Field (user_id) — Foreign key → Untitled.Field
  • Field (title)
  • Field2 (content)
  • Field3 (created_at)
  • Field4 (modified_at)

Untitled (comment)

  • Key (comment_id) — Primary key — NOT NULL
  • Key (article_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (user_id) — Foreign key → Untitled.Field
  • Field (content)

Untitled (like)

  • Key (like_id) — Primary key — NOT NULL
  • Key (article_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (user_id) — Foreign key

Untitled (bookmark)

  • Key (bookmark_id) — Primary key — NOT NULL
  • Key (article_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (user_id) — Foreign key → Untitled.Field