eat-together
Tables (4)
post (게시글)
- PostId (id) — BIGINT — Primary key — NOT NULL
- UserId (user_id) — BIGINT — Foreign key → user.UserId — NOT NULL
- PostTitle (title) — VARCHAR(200)
- PostContent (content) — TEXT
- ImageUrl (image_url) — VARCHAR(500)
- PostCreateAt (created_at) — DATETIME
- PostUpdateAt (modified_at) — DATETIME
post_comment (댓글)
- Key — BIGINT — Primary key — NOT NULL
- UserId (user_id) — BIGINT — Foreign key → user.UserId — NOT NULL
- PostId (post_id) — BIGINT — Foreign key → post.PostId — NOT NULL
- CommentContent (content) — TEXT
- CommentCreatedAt (created_at) — DATETIME
post_like (게시물 좋아요)
- LikeId (id) — Primary key — NOT NULL
- PostId (post_id) — BIGINT — Foreign key → post.PostId — NOT NULL — UQ1
- UserId (id2) — BIGINT — Foreign key → user.UserId — NOT NULL — UQ1
- LikeCreatedAt (created_at) — DATETIME
user (유저)
- UserId (id) — BIGINT — Primary key — NOT NULL
- UserEmail (email) — VARCHAR(255) — Unique
- UserPassword (password) — VARCHAR(255)
- UserNickname (nickname) — VARCHAR(50)
- UserStatus (status) — ENUM — ACTIVE, INACTIVE
- UserCreatedAt (created_at) — DATETIME
- UserRole (role) — ENUM — USER, ADMIN