new_erd

Tables (9)

Application (커피챗 신청)

  • application_id (PK) — bigint — Primary key — NOT NULL
  • memo (Field1) — varchar
  • accept (Field2) — ApplicationStatus
  • mentor_id (FK1) — Foreign key → Mentor.id — NOT NULL
  • mentee_id (FK2) — Foreign key → Mentee.mentee_id — NOT NULL
  • possible_date_id (FK3) — Foreign key → PossibleDate.id — NOT NULL

Chat (채팅)

  • chat_id (PK) — Primary key — NOT NULL
  • chat_room_id (Field1) — bigint
  • message (Field2) — varchar
  • createdAt (BaseEntityField1) — localdatetime
  • updatedDate (BaseEntityField2) — localdatetime
  • chat_room_id (FK1) — bigint — Foreign key → ChatRoom.chat_room_id — NOT NULL
  • sender (FK2) — bigint (user_id) — Foreign key → User.id — NOT NULL

ChatRoom (채팅방)

  • chat_room_id (PK) — bigint — Primary key — NOT NULL
  • name (Field1) — varchar
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

ChatRoomUser (채팅방 이용자)

  • chat_room_user_id (PK) — bigint — Primary key — NOT NULL
  • chat_room_id (FK1) — bigint — Foreign key → ChatRoom.chat_room_id — NOT NULL
  • user_id (FK2) — bigint — Foreign key → User.id — NOT NULL

Introduction (멘토 설명)

  • introduction_id (PK) — bigint — Primary key — NOT NULL
  • title (Field1) — varchar
  • description (Field2) — varchar
  • answer1 (Field3) — varchar
  • answer2 (Field4) — varchar

Mentee (멘티)

  • mentee_id (PK) — bigint — Primary key — NOT NULL
  • part (Field) — PartEnum

Mentor (멘토)

  • id (PK) — Primary key — NOT NULL
  • part (Field1) — PartEnum
  • club (Field2) — ClubEnum
  • mentor_introduction (FK) — bigint — Foreign key → Introduction.introduction_id — NOT NULL

PossibleDate (가능한 날짜)

  • id (PK) — Primary key — NOT NULL
  • date (Field1) — LocalDate
  • startTime (Field2) — LocalTime (JSON pattern)
  • endTime (Field3) — LocalTime (JSON pattern)
  • isActive (Field4) — boolean
  • mentor_id (FK1) — Foreign key → Mentor.id — NOT NULL

User (사용자)

  • id (PK) — Type — Primary key — NOT NULL
  • user_id (bigint) — bigint
  • user_name (varchar) — varchar
  • name (Field1) — varchar
  • email (Field2) — varchar
  • role (Field3) — enum
  • phone_number (Field4) — varchar
  • picture (Field5) — varchar
  • is_deleted (Field6) — boolean
  • deleted_at (Field7) — localdatetime
  • user_metor (FK1) — Foreign key → Mentor.id — NOT NULL
  • user_mentee (FK2) — Foreign key → Mentee.mentee_id — NOT NULL