MBTI_SITE

Tables (4)

Comment (댓글)

  • pk — Integer — Primary key — NOT NULL
  • pk (post) — Integer — Foreign key → Post.pk — NOT NULL
  • pk (poster) — Integer — Foreign key → Post.pk — NOT NULL
  • pk (commenter) — Integer — Foreign key → User.pk — NOT NULL
  • post (ForignKey) — Char
  • commenter (Field) — Char
  • content (text) — Char

Post (게시물)

  • pk — Integer — Primary key — NOT NULL
  • pk (poster) — Integer — Foreign key → User.pk — NOT NULL
  • title — Char
  • poster (name) — Char
  • content (text) — Char

Profile (프로필(Abstractuser))

  • pk (Key) — Integer — Primary key — NOT NULL
  • nickname — Char
  • user_mbti (user's mbti)
  • pk (Key2) — Integer — Foreign key → User.pk — NOT NULL

User (유저(AUTH))

  • pk (Key) — Integer — Primary key — NOT NULL
  • username (name) — Char
  • password1 (pw1) — Char
  • password2 (pw2) — Char