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