Proteen_entity

Tables (3)

Users (유저)

  • pk — bigint — Primary key — NOT NULL
  • 유저 id (userId) — varchar — NOT NULL
  • 유저 비번 (userPassword) — varchar — NOT NULL
  • 닉네임 (nickName) — varchar — NOT NULL
  • 생성날짜,시간 (createdDate) — datetime — NOT NULL
  • fk (chattingRoom_id) — bigint — Foreign key → chattingRoom.pk — NOT NULL

chattingRoom (채팅방)

  • pk — bigint — Primary key — NOT NULL
  • 상담사 (counselor) — User — NOT NULL
  • 피상담자 (client) — User — NOT NULL

message (메세지)

  • pk — bigint — Primary key — NOT NULL
  • 타입 (type) — varchar — NOT NULL
  • 보내는 사람 (sender) — User — NOT NULL
  • 받는 사람 (receiver) — User — NOT NULL
  • 데이터(내용) (data) — varchar — NOT NULL
  • fk (chattingRoom_id) — bigint — Foreign key → chattingRoom.pk — NOT NULL