mystagram

Tables (8)

ChatMessage (CHAT_MESSAGE)

  • id — BIGINT — Primary key — NOT NULL
  • chatUserId (chat_user_id) — BIGINT — Foreign key → ChatUser.id — NOT NULL
  • content — VARCHAR — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

ChatRoom (CHAT_ROOM)

  • id — BIGINT — Primary key — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

ChatUser (CHAT_USER)

  • id — BIGINT — Primary key — NOT NULL
  • memberId (member_id) — BIGINT — Foreign key → Member.id
  • chatRommId (chat_room_id) — BIGINT — Foreign key → ChatRoom.id — NOT NULL

Comment (COMMENT)

  • id — BIGINT — Primary key — NOT NULL
  • writerId (writer_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • postId (post_id) — BIGINT — Foreign key → Post.id
  • content — VARCHAR — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

Follow (FOLLOW)

  • id — BIGINT — Primary key — NOT NULL
  • followerId (follower_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • followingId (following_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

Member (MEMBER)

  • id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR — NOT NULL
  • password — CHAR — NOT NULL
  • profileImageUrl (profile_image_url) — VARCHAR
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

Post (POST)

  • id — BIGINT — Primary key — NOT NULL
  • writerId (writer_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • imageUrl (image_url) — VARCHAR — NOT NULL
  • content — VARCHAR
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL

Reply (REPLY)

  • id — BIGINT — Primary key — NOT NULL
  • writerId (writer_id) — BIGINT — Foreign key → Member.id — NOT NULL
  • commentId (comment_id) — BIGINT — Foreign key → Comment.id
  • content — VARCHAR — NOT NULL
  • createdAt (created_at) — TIMESTAMP — NOT NULL
  • lastModifiedAt (last_modified_at) — TIMESTAMP — NOT NULL