채팅
테이블 (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)