4차

테이블 (9)

ChatMessage

  • id — BIGINT
  • roomId — BIGINT
  • senderId — BIGINT
  • content — TEXT
  • createdAt — TIMESTAMP

ChatRoom

  • id — BIGINT
  • member1Id — BIGINT
  • member2Id — BIGINT

Interest

  • id — BIGINT
  • category — VARCHAR(100)
  • value — VARCHAR(100)

MatchLog

  • id — BIGINT
  • member1Id — BIGINT
  • member2Id — BIGINT
  • matchedAt — TIMESTAMP

Member

  • id — BIGINT
  • email — VARCHAR(255)
  • nickname — VARCHAR(100)
  • profileImageUrl — VARCHAR(500)
  • trustScore — INT
  • createdAt — TIMESTAMP

MemberInterest

  • memberId — BIGINT
  • interestId — BIGINT

Order

  • id — BIGINT
  • payerId — BIGINT
  • receiverId — BIGINT
  • orderId — VARCHAR(100)
  • totalPrice — INT
  • paymentStatus — VARCHAR(50)
  • isShared — BOOLEAN

Rating

  • id — BIGINT
  • raterId — BIGINT
  • targetId — BIGINT
  • stars — INT
  • createdAt — TIMESTAMP

Report

  • id — BIGINT
  • reporterId — BIGINT
  • targetId — BIGINT
  • reason — TEXT
  • createdAt — TIMESTAMP