sd

Tables (5)

IMG_FILE

  • postImgURLIdx — int — Primary key — NOT NULL
  • postIdx — int — Foreign key → Post.postIdx — NOT NULL
  • imgUrl — VARCHAR(255) — NOT NULL
  • status — varChar(10) — NOT NULL — active 활성화, inactive 비활성화, deleted 삭제된 계정
  • createdAt — int — NOT NULL
  • updatedAt — int — NOT NULL

Post

  • postIdx — int — Primary key — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • content — varChar(300)
  • status — varChar(10) — active 활성화, inactive 비활성화, deleted 삭제된 계정
  • createdAt — int — NOT NULL
  • updatedAt — int — NOT NULL

User

  • userIdx — int — Primary key — NOT NULL
  • nickName — varChar(45) — NOT NULL — 유저 닉네임
  • name — varChar(45) — NOT NULL — 유저 이름
  • profilImgURL — a — NOT NULL — 유저 프로필 사진
  • webSite — varChar(45) — 유저 웹사이트
  • status — varChar(10) — NOT NULL — active 활성화, inactive 비활성화, deleted 삭제된 계정
  • instroduce — varChar(45) — 유저 소개글
  • createdAt — int — NOT NULL
  • updatedAt — int — NOT NULL

comment

  • commentIdx — int — Primary key — NOT NULL
  • userIdx — int — Foreign key → User.userIdx — NOT NULL
  • postIdx — int — Foreign key → Post.postIdx — NOT NULL
  • content — varChar(300) — NOT NULL
  • parentCommentIdx — int — NOT NULL — 0 for root comment
  • status — varChar(10) — NOT NULL
  • createdAt — int — NOT NULL
  • updatedAt — int — NOT NULL

follow

  • followIdx — int — Primary key — NOT NULL
  • followingIdx — int — Primary key — NOT NULL
  • followerIdx — int — Foreign key — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)