db_study

Tables (5)

follow

  • id — int auto_increment primary key — Primary key — NOT NULL — 아이디
  • follower — int — Foreign key → users.id — NOT NULL — user id
  • following — int — Foreign key → users.id — NOT NULL — user id

hashtags

  • id — int auto_increment primary key — Primary key — NOT NULL
  • name — varchar(15) — NOT NULL

post

  • id — int auto_increment primary key — Primary key — NOT NULL — 게시물 번호 자동증가
  • content — varchar(255) — NOT NULL — 게시물 이미지 경로
  • img
  • userid — int — Foreign key → users.id — NOT NULL — user id
  • createAt — datetime — NOT NULL
  • updateAt — datetime — NOT NULL

posthashtag

  • id — int auto_increment primary key — Primary key — NOT NULL
  • hashtagid — int auto_increment primary key — Foreign key → hashtags.id — NOT NULL
  • postid — int auto_increment primary key — Foreign key → post.id — NOT NULL — 게시물 번호 자동증가

users

  • id — int — Primary key — NOT NULL — user id
  • email — varchar(50)
  • password — varchar(100) — NOT NULL — 사용자비번
  • gender — enum('남','여')
  • birthday — date — NOT NULL
  • address — NOT NULL — 사용자 주소
  • creatAt — datetime — NOT NULL — 가입일
  • updateAt — datetime — NOT NULL — 수정일
  • deleteAt — datetime — NOT NULL — 탈퇴일