gdgd

Tables (5)

Board (Untitled6)

  • 게시판 ID (Board_Id) — PK — Primary key — NOT NULL
  • 장소이름 (placeName)
  • 매칭인원 (maxPartener)
  • 생성날짜 (CreateDate)
  • 수정날짜 (ModifyDate)
  • 유저 Id (User_id) — FK — Foreign key → User.유저 ID — NOT NULL

ChatUser (Untitled5)

  • 채팅 유저 ID (ChatUserId) — PK — Primary key — NOT NULL
  • 유저타입 (type)
  • 생성날짜 (CreateDate)
  • 수정날짜 (ModifyDate)
  • 유저 ID (User_Id) — FK — Foreign key → User.유저 ID — NOT NULL

Chating (Untitled2)

  • ChatId (Key) — PK — Primary key — NOT NULL
  • 메시지 내용 (content)
  • 생성날짜 (CreateDate)
  • 수정날짜 (ModifyDate)
  • 채팅방 ID (Key2) — FK — Foreign key → Room.RoomId — NOT NULL
  • 채팅 유저 ID (ChatUserId) — FK — Foreign key → ChatUser.채팅 유저 ID — NOT NULL

Room (Untitled3)

  • RoomId (Key) — PK — Primary key — NOT NULL
  • 생성날짜 (CreateDate)
  • 수정날짜 (ModifyDate)
  • UserId (userId) — FK — Foreign key → User.유저 ID — NOT NULL
  • 게시판 ID (Board_Id) — FK — Foreign key → Board.게시판 ID — NOT NULL

User (Untitled)

  • 유저 ID (Key) — PK — Primary key — NOT NULL
  • 유저 닉네임 (Field4)
  • 이메일 (Email)
  • 생성날짜 (CreateDate)
  • 수정날짜 (ModifyDate)
  • 타입 (type) — PK