nack_article

Tables (9)

Article (Untitled2)

  • Article Idx (article_idx) — Not Null — Primary key — NOT NULL
  • User Idx (user_idx) — Not Null — Foreign key → User.User Idx — NOT NULL
  • Article Created At (article_createdAt) — DATE
  • Article Content (article_content) — STRING

Article Hashtag (Untitled9)

  • Article Hashtag Idx (article_hashtag_idx) — Not Null — Primary key — NOT NULL
  • Article Idx (article_idx) — Not Null — Foreign key → Article.Article Idx — NOT NULL
  • Hashtag Idx (hashtag_idx) — Not Null — Foreign key → Hashtag.Hashtag Idx — NOT NULL

Article Like (Untitled3)

  • Article Like Idx (article_like_idx) — Not Null — Primary key — NOT NULL
  • Article Idx (article_idx) — Not Null — Foreign key → Article.Article Idx — NOT NULL
  • User Idx (user_idx) — Not Null — Foreign key → User.User Idx — NOT NULL

Comment (Untitled4)

  • Comment Idx (comment_idx) — Not Null — Primary key — NOT NULL
  • User Idx (user_idx) — Not Null — Foreign key → User.User Idx — NOT NULL
  • Article Idx (article_idx) — Not Null — Foreign key → Article.Article Idx — NOT NULL
  • Comment Content (comment_content) — STRING
  • Comment Created At (comment_created_at) — DATE

Comment Like (Untitled5)

  • Comment Like Idx (comment_like_idx) — Not Null — Primary key — NOT NULL
  • Comment Idx (comment_idx) — Not Null — Foreign key → Comment.Comment Idx — NOT NULL
  • User Idx (user_idx) — Not Null — Foreign key → User.User Idx — NOT NULL

Hashtag (Untitled8)

  • Hashtag Idx (hashtag_idx) — Not Null — Primary key — NOT NULL
  • Hashtag Tag (hashtag_tag) — CHAR(20)

Recomment (Untitled6)

  • Recomment Idx (recomment_idx) — Not Null — Primary key — NOT NULL
  • Comment Idx (comment_idx) — Not Null — Foreign key → Comment.Comment Idx — NOT NULL
  • User Idx (user_idx) — Not Null — Foreign key → User.User Idx — NOT NULL
  • Recomment Content (recomment_content) — STRING
  • Recomment Created At (recomment_created_at) — DATE

Recomment Like (Untitled7)

  • Recomment Like Idx (recomment_like_idx) — Not Null — Primary key — NOT NULL
  • Recomment Idx (recomment_idx) — Not Null — Foreign key → Recomment.Recomment Idx — NOT NULL
  • User Idx (user_idx) — Not Null — Foreign key → User.User Idx — NOT NULL

User (Untitled)

  • User Idx (user_idx) — Not Null — Primary key — NOT NULL
  • User Nickname (user_nickname) — CHAR(16)
  • User Id (user_id) — CHAR(20)
  • User Password (user_password) — CHAR(16)