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