instagram
Tables (5)
Comment (댓글테이블)
- id (Key) — Primary key — NOT NULL
- content (Field)
- USER (Field2)
- image (Field3)
- id (Key2) — Foreign key → Image.id — NOT NULL
- id (Key3) — Foreign key → User.id — NOT NULL
Image (이미지테이블)
- id (Key) — Primary key — NOT NULL
- caption (Field)
- postImageUrl (Field2)
- USER (Field3)
- like (Field4)
- comment (Field5)
- likeCount (Field7)
- id (Key2) — Foreign key → User.id — NOT NULL
Subscribe (구독테이블)
- id (Field) — Primary key
- toUser (Field3)
- fromUser (Field2)
- id (Key) — Foreign key → User.id — NOT NULL
User (유저)
- id (Key) — Primary key — NOT NULL
- username (유저네임)
- password (비밀번호)
- name (이름)
- bio (Field5)
- email (Field6)
- phon (Field7)
- gender (Field8)
- profileImageUrl (사진주소)
- role (권한)
like (좋아요테이블)
- id (Key) — Primary key — NOT NULL
- Image (Field)
- User (Field2)
- id (Key2) — Foreign key → Image.id — NOT NULL