chat-service

Tables (4)

CHAT (Untitled3)

  • cgat_id (기본 키) — Primary key — NOT NULL
  • message (메시지) — NOT NULL
  • sendDate (보낸 시간) — NOT NULL
  • room_id (기본 키2) — Foreign key → ROOM.room_id — NOT NULL

JOIN_CHAT (Untitled2)

  • join_chat_id (기본 키) — Primary key — NOT NULL
  • member_id (기본 키2) — Foreign key → MEMBER.member_id — NOT NULL
  • cgat_id (기본 키3) — Foreign key → CHAT.cgat_id — NOT NULL

MEMBER (Untitled)

  • member_id (기본 키) — Primary key — NOT NULL
  • loginId (아이디) — NOT NULL
  • password (비밀번호) — NOT NULL
  • name (이름) — NOT NULL
  • roles (롤) — NOT NULL

ROOM (Untitled4)

  • room_id (기본 키) — Primary key — NOT NULL
  • name (채팅방 이름) — NOT NULL