HBT4U
Tables (7)
chatroomparticipant (채팅방 참여자)
- chatroomparticipantpkey (pkey) — bigint — Primary key — NOT NULL
- userpkey (pk2) — bigint — Foreign key → user.userpkey — NOT NULL
- chatroompkey (pk3) — bigint — Foreign key → support.chatroompkey — NOT NULL
- lastreadmessage (마지막으로 읽은 메세지 id) — bigint
guide (가이드)
- guidpkey (pk) — bigint — Primary key — NOT NULL
- userpkey (pk2) — bigint — Foreign key → user.userpkey — NOT NULL
- guidename (이름) — varchar
- createdat (생성시간) — datetime
- isdeleted (삭제여부) — tirnyint
message (채팅방 메세지)
- messagepkey (pk) — bigint — Primary key — NOT NULL
- chatroompkey (pk2) — bigint — Foreign key → support.chatroompkey — NOT NULL
- userpkey (pk3) — bigint — Foreign key → user.userpkey — NOT NULL
- content (내용) — longtext
- sendat (메세지 전송 시간) — datetime
- Field (메세지 삭제) — tinyint
schedule (스케줄)
- schedulepkey (pk) — bigint — Primary key — NOT NULL
- userpkey (pk2) — bigint — Foreign key → user.userpkey — NOT NULL
- isdeleted (삭제여부) — tinyint
- scheduletitle (예약 제목) — varchar
- scheduledecription (예약 내용) — longtext
- location (시술 받기 위한 위치) — varchar
subschedule (가이드 위치 업데이트 되면 추가)
- locationpkey (pk) — bigint — Primary key — NOT NULL
- schedulepkey (pk2) — bigint — Foreign key → schedule.schedulepkey — NOT NULL
- latitude (위도) — double
- longitude (경도) — double
support (채팅방)
- chatroompkey (pk) — bigint — Primary key — NOT NULL
- scheduleOrUserpeky (Field)
- type (schedule 또는 support) — enum
- createdAt (채팅방 생성 시간) — datetime
user (유저)
- userpkey (pk) — bigint — Primary key — NOT NULL
- username (이름) — varchar
- userrole (권한) — varchar
- createdat (생성시간) — datetime
- isdeleted (삭제여부) — tinyint