채팅

테이블 (6)

chat_info

  • chat_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member_info.member_id — NOT NULL
  • chat_room_id — BIGINT — 외래 키 → chat_room_info.chat_room_id — NOT NULL
  • contents — CLOB
  • contents_ko — CLOB
  • contents_en — CLOB

chat_member_info

  • chat_member_id — BIGINT — 기본 키 — NOT NULL
  • member_id — BIGINT — 외래 키 → member_info.member_id — NOT NULL
  • chat_room_id — BIGINT — 외래 키 → chat_room_info.chat_room_id — NOT NULL

chat_room_info

  • chat_room_id — BIGINT — 기본 키 — NOT NULL
  • chat_room_title — VARCHAR(255)
  • chat_room_type — VARCHAR(10)

chat_view_info

  • chat_id — BIGINT — 외래 키 → chat_info.chat_id — NOT NULL
  • member_id — BIGINT — 외래 키 → chat_info.member_id — NOT NULL

member_info

  • member_id — BIGINT — 기본 키 — NOT NULL
  • member_email — VARCHAR(100)
  • member_pwd — VARCHAR(50)
  • member_name — VARCHAR(50)
  • lang — VARCHAR(2)
  • call_number — VARCHAR(20)

member_link_info

  • member_id — BIGINT — 외래 키 → member_info.member_id — NOT NULL
  • friend_id — BIGINT
  • friend_name — VARCHAR(30)