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)