sns

Tables (6)

Untitled (follow)

  • userId (user_id) — Long — Foreign key → users.userId — NOT NULL
  • userId (following_id) — Long — Foreign key → users.userId — NOT NULL

Untitled (comments)

  • Key (comment_id) — Long — Primary key — NOT NULL
  • Field (content) — varchar(200)
  • postId (post_id) — Long — Foreign key → post.postId — NOT NULL
  • userId (user_id) — Long — Foreign key → users.userId — NOT NULL
  • Field (likes_count) — Long
  • Field2 (created_date) — Date

comment_likes

  • comment_likes (comment_like_id) — Long — Primary key — NOT NULL
  • Key (comment_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • userId (user_id) — Long — Foreign key → users.userId — NOT NULL

post (posts)

  • postId (post_id) — Long — Primary key — NOT NULL
  • title — varchar(30) — NOT NULL
  • content — varchar(500) — NOT NULL
  • userId (user_id) — Long — Foreign key → users.userId — NOT NULL
  • Field (likes_count) — Long
  • Field (created_date) — Date — NOT NULL

post_likes

  • post_likes (post_like_id) — Long — Primary key — NOT NULL
  • postId (post_id) — Long — Foreign key → post.postId — NOT NULL
  • userId (user_id) — Long — Foreign key → users.userId — NOT NULL

users

  • userId (user_id) — Long — Primary key — NOT NULL
  • password — varchar(30) — NOT NULL
  • email — varchar(30) — NOT NULL
  • nickname — varchar(15) — NOT NULL
  • amdin (role) — varchar(15) — NOT NULL