오픈톡방
테이블 (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)