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