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 — 탈퇴일