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