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