udemy-insta

Tables (5)

Comment (Untitled3)

  • commentIdx (Key) — INT — Primary key — NOT NULL
  • postIdx (Key2) — INT — Foreign key → Post.postIdx — NOT NULL
  • userIdx (Key4) — INT — Foreign key → User.userIdx — NOT NULL — auto-increment
  • content (Field) — VARCHAR(100)
  • parentComment (Field2) — INT
  • status (Field3) — VARCHAR(10) — NOT NULL — ACTIVE: 활성화 INACTIVE: 비활성화 DELETED: 삭제된 계정
  • createAt (Field4) — TIMESTAMP — NOT NULL
  • updateAt (Field5) — TIMESTAMP — NOT NULL

Follow (Untitled4)

  • followIdx (Key) — INT — Primary key — NOT NULL
  • followerIdx (Key3) — INT — Foreign key → User.userIdx — NOT NULL
  • followeeIdx (Key2) — INT — Foreign key → User.userIdx — NOT NULL
  • status (Field) — VARCHAR(10) — NOT NULL — ACTIVE: 활성화 INACTIVE: 비활성화 DELETED: 삭제된 계정
  • createAt (Field2) — TIMESTAMP — NOT NULL
  • updateAt (Field3) — TIMESTAMP — NOT NULL

Post

  • postIdx (Key2) — INT — Primary key — NOT NULL
  • userIdx (Key) — INT — Foreign key → User.userIdx — NOT NULL — auto-increment
  • content (Field) — VARCHAR(300)
  • status (Field2) — VARCHAR(10) — NOT NULL — ACTIVE: 활성화 INACTIVE: 비활성화 DELETED: 삭제된 계정
  • createAt (Field3) — TIMESTAMP — NOT NULL
  • updateAt (Field4) — TIMESTAMP

PostImgUrl (Untitled2)

  • postImgUrl (Key) — INT — Primary key — NOT NULL
  • postIdx (Key2) — INT — Foreign key → Post.postIdx — NOT NULL
  • imgUrl (Field) — TEXT — NOT NULL
  • status (Field2) — VARCHAR(10) — NOT NULL — ACTIVE: 활성화 INACTIVE: 비활성화 DELETED: 삭제된 계정
  • createAt (Field3) — TIMESTAMP — NOT NULL
  • updateAt (Field4) — TIMESTAMP — NOT NULL

User (유저 테이블)

  • userIdx (Key) — INT — Primary key — NOT NULL — auto-increment
  • nickName (Field) — VARCHAR(45) — NOT NULL — 유저 닉네임
  • name (Field2) — VARCHAR(45) — NOT NULL — 유저 이름
  • profileImgUrl (Field3) — TEXT — NOT NULL — 유저 프로필 사진
  • website (Field4) — VARCHAR(45) — 유저 웹사이트
  • introduce (Field5) — VARCHAR(45) — 유저 소개
  • status (Field6) — VARCHAR(10) — NOT NULL — ACTIVE: 활성화 INACTIVE: 비활성화 DELETED: 삭제된 계정
  • createAt (Field7) — TIMESTAMP — NOT NULL
  • updateAt (Field8) — TIMESTAMP — NOT NULL