simpleSNS

Tables (7)

Comment (comment)

  • Id (id) — Primary key — NOT NULL
  • Comment (comment)
  • Id (post_id) — Foreign key → Post.Id — NOT NULL
  • Id (user_id) — Foreign key → User.Id — NOT NULL

Heart (heart)

  • Id (id) — Primary key — NOT NULL
  • Id (post_id) — Foreign key → Post.Id — NOT NULL
  • Id (user_id) — Foreign key → User.Id — NOT NULL

ImgUrls (img_urls)

  • Id (post_id) — Foreign key → Post.Id — NOT NULL
  • ImgUrls (img_urls)

Post (post)

  • Id (id) — Primary key — NOT NULL
  • Content (content)
  • Id (user_id) — Foreign key → User.Id — NOT NULL

Untitled

    User (user)

    • Id (id) — Primary key — NOT NULL
    • Name (name)
    • PhoneNumber (phone_num)
    • Tag (tag)
    • Password (password)

    UserRole (user_role)

    • Id (user_id) — Foreign key → User.Id — NOT NULL
    • UserRole (user_role)