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