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