UMC Instagram
테이블 (10)
Untitled (Follower)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field2 (user_idx) — bigint — NOT NULL
- Field (status) — varchar(10) — NOT NULL
- Field2 (createdAt) — timestamp — NOT NULL
- Field (updatedAt) — timestamp — NOT NULL
Untitled (Story)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field (user_idx) — bigint — NOT NULL
- Field (status) — varchar(10) — NOT NULL
- Field (createdAt) — timestamp — NOT NULL
- Field (updatedAt) — timestamp — NOT NULL
Untitled (StoryImage)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field (story_idx) — bigint — NOT NULL
- Field (image_url) — text — NOT NULL
- Field (status) — varchar(10) — NOT NULL
- Field (createdAt) — timestamp — NOT NULL
- Field (updatedAt) — timestamp — NOT NULL
Untitled2 (Following)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field (user_idx) — bigint — NOT NULL
- Field (status) — varchar(10) — NOT NULL
- Field2 (createdAt) — timestamp — NOT NULL
- Field (updatedAt) — timestamp — NOT NULL
게시글 (Posts)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field2 (user_idx) — bigint — NOT NULL
- Field (content) — text
- Field (status) — varchar(10) — NOT NULL
- Field3 (createdAt) — timestamp — NOT NULL
- Field4 (updatedAt) — timestamp — NOT NULL
게시글 사진 (PostImage)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field (post_idx) — bigint — NOT NULL
- Field (image_url) — text — NOT NULL
- Field2 (status) — varchar(10) — NOT NULL
- Field (createdAt) — timestamp — NOT NULL
- Field2 (updatedAt) — timestamp — NOT NULL
댓글 (Reply)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field (user_idx) — bigint — NOT NULL
- Field2 (post_idx) — bigint — NOT NULL
- Field (content) — text — NOT NULL
- Field (status) — varchar(10) — NOT NULL
- Field2 (createdAt) — timestamp — NOT NULL
- Field3 (updatedAt) — timestamp — NOT NULL
사용자 (User)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field (email) — varchar(50) — NOT NULL
- Field2 (nickname) — varchar(50) — NOT NULL
- Field3 (password) — text — NOT NULL
- Field4 (status) — varchar(10) — NOT NULL
- Field5 (createdAt) — timestamp — NOT NULL
- Field (updatedAt) — timestamp — NOT NULL
좋아요 (Likes)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field (user_idx) — bigint — NOT NULL
- Field2 (post_idx) — bigint — NOT NULL
- Field (reply_idx) — bigint — NOT NULL
- Field (story_idx) — bigint — NOT NULL
- Field (status) — varchar(10) — NOT NULL
- Field2 (createdAt) — timestamp — NOT NULL
- Field3 (updatedAt) — timestamp — NOT NULL
프로필 사진 (ProfileImage)
- Key (idx) — bigint — 기본 키 — NOT NULL
- Field (user_idx) — bigint — NOT NULL
- Field (image_url) — text
- Field2 (status) — varchar(10) — NOT NULL
- Field (createdAt) — timestamp — NOT NULL
- Field2 (updatedAt) — timestamp — NOT NULL