instagram clone

Tables (4)

Article

  • Key (article_id) — int — Primary key — NOT NULL
  • Key (user_id) — Int — Foreign key → User.Key — NOT NULL
  • Field (content) — varchar
  • Field (Image)
  • Field (updated_at) — date
  • Field (created_at) — date

Comment (comment)

  • Key (comment_id) — int — Primary key — NOT NULL
  • Key (article_id) — int — Foreign key → Article.Key — NOT NULL
  • Key (user_id) — Int — Foreign key → User.Key — NOT NULL
  • Field (content) — varchar
  • Field

Like (Untitled)

  • Key (article_id) — int — Foreign key → Article.Key — NOT NULL
  • Key (user_id) — Int — Foreign key → User.Key — NOT NULL

User

  • Key (user_id) — Int — Primary key — NOT NULL
  • Key (username) — varchar — Primary key — NOT NULL
  • Field (email) — email
  • Field — int
  • Field (이름) — varchar
  • Field (성) — varchar
  • Field (비밀번호) — password
  • Key (user_id2) — Int — Foreign key → User.Key — NOT NULL