오픈톡방

테이블 (7)

chatRoom_Hashtag (Untitled5)

  • hashtag_id (Key) — bigint — 외래 키 → chatroom_hashtag.id — NOT NULL
  • chatroom_id (Key2) — bigint — 외래 키 → opentalk_room_list.id — NOT NULL

chatRoom_Member (Untitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — varChar(255) — 외래 키 → chat_member_list.id — NOT NULL
  • chatroom_id (Key3) — varChar(255) — 외래 키 → opentalk_room_list.id — NOT NULL

chat_log (Untitled7)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • message (Field) — varchar(255)
  • room_id (Field2) — varchar(255)
  • Field3 — varchar(255)

chat_member_list (Untitled6)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • role (Field) — varChar(255)
  • member_id (Field2) — varChar(255)
  • member_nick_name (Field3) — varChar(255)
  • room_id (Field4) — varChar(255)

chatroom_hashtag (Untitled3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • tagName (Field) — varChar(100)
  • tag_accumulate (Field2) — INT

open_talk_member (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • memberId (Field) — varChar(100)
  • memberPassword (Field2) — varChar(100)
  • memberName (Field3) — varChar(100)
  • memberNickName (Field4) — varChar(100)
  • memberEmail (Field5) — varChar(100)
  • authority (Field6) — varChar(100)

opentalk_room_list (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • roomName (Field) — varChar(100)
  • roomId (Field2) — varChar(100)
  • manager (Field3) — varChar(100)
  • participates (Field4) — int
  • limitParticipates (Field5) — int
  • introduction (Field6) — varChar(100)
  • existLock (Field7) — int
  • roomPassword (Field8) — varChar(100)