SOOLO
Tables (7)
Chat (Untitled4)
- message_id (Key) — Primary key — NOT NULL
- chatRoom_id (Key2) — Foreign key → ChatRoomMember.chatRoom_id — NOT NULL
- Member_id (Key22) — VARCHAR — Foreign key → ChatRoomMember.Member_id — NOT NULL
- chat_message (Field)
- chat_time (Field2)
ChatRoom (Untitled3)
- chatRoom_id (Key) — Primary key — NOT NULL
- post_id (Key2) — Foreign key → Party_Post.post_id — NOT NULL
- organizer_id (Key22) — Foreign key → Party_Post.Member_id — NOT NULL
ChatRoomMember (Untitled2)
- chatRoom_id (Key) — Foreign key → ChatRoom.chatRoom_id — NOT NULL
- Member_id (Key2) — VARCHAR — Foreign key → Member.Member_id — NOT NULL
- post_id (Key22) — Foreign key → ChatRoom.post_id — NOT NULL
Member (Untitled)
- Member_id (Key) — VARCHAR — Primary key — NOT NULL
- password (Field) — VARCHAR
- gender (Field2) — INT
- username (Field3) — VARCHAR
- character (Field4) — LIST
- member_image (Field5)
- 참가했던모임 (Field6)
- 매너온도 (Field7)
- Field9
Party_Post (Untitled5)
- post_id (Key) — Primary key — NOT NULL
- Member_id (Key2) — VARCHAR — Foreign key → Member.Member_id — NOT NULL
- 제목 (Field)
- 내용 (Field2)
- 작성일자 (Field3)
- 수정일자 (Field4)
- 가게정보 (Field5)
- 일정정보 (Field6)
- 모집인원 (Field7)
- 현재 참여자 (Field8)
RefreshKey (Untitled6)
- refresh_key (Key) — Primary key — NOT NULL
- Field
TempMemberForChat (Untitled7)
- organizer_id (Key) — VARCHAR — Foreign key → Member.Member_id — NOT NULL
- participant_id (Key2) — VARCHAR — Foreign key → Member.Member_id — NOT NULL