KafkaTest
Tables (13)
Account (계좌)
- Account_Id (계좌 아이디) — UUID — Primary key — NOT NULL
- account_number (계좌번호) — VARCHAR
- password (계좌 비밀번호) — VARCHAR
- is_closed (계좌폐쇄여부) — INTEGER(1)
- balance (계좌 잔액) — DECIMAL(20, 2)
- created_time (생성일자) — DATETIME(6)
- modified_time (수정일자) — DATETIME(6)
- member_id (멤버 아이디) — UUID — Foreign key → Member.member_id — NOT NULL
Announcement (공지)
- ANNOUNCEMENT_ID (공지 아이디) — NUMBER — Primary key — NOT NULL
- content (내용) — VARCHAR
- created_time (생성일자) — DATETIME(6)
- modified_time (수정일자) — DATETIME(6)
- CHATROOM_ID (채팅 방 아이디) — NUMBER — Foreign key → ChatRoom.CHATROOM_ID — NOT NULL
- created_by (멤버 아이디) — UUID — Foreign key → Member.member_id — NOT NULL
Articles (게시물)
- article_id (게시물 아이디) — NUMBER — Primary key — NOT NULL
- content (내용) — VARCHAR
- title (제목) — VARCHAR
- liked (좋아요 개수) — NUMBER
- member_id (멤버 아이디) — UUID — Foreign key → Member.member_id — NOT NULL
ChatMessage (채팅 메세지)
- CHATMESSAGE_ID (메세지 아이디) — NUMBER — Primary key — NOT NULL
- type (메세지 타입(m | i | e)) — VARCHAR
- message (메세지) — VARCHAR
- image (이미지) — VARCHAR
- emoticon (이모티콘) — VARCHAR
- numberOfUnread (메세지 읽지 않은 사람) — NUMBER
- created_time (생성일자) — DATETIME(6)
- modified_time (수정일자) — DATETIME(6)
- Field
- CHATROOM_ID (채팅 방 아이디) — NUMBER — Foreign key → ChatRoom.CHATROOM_ID — NOT NULL
ChatRoom (채팅룸)
- CHATROOM_ID (채팅 방 아이디) — NUMBER — Primary key — NOT NULL
- room_name (채팅 방 이름) — VARCHAR
- number_of_member (총 인원) — NUMBER
- created_time (생성일자) — DATETIME(6)
- modified_time (수정일자) — DATETIME(6)
- created_by (채팅방장) — UUID — Foreign key → Member.member_id — NOT NULL
Comments (댓글)
- comments_id (댓글 아이디) — NUMBER — Primary key — NOT NULL
- article_id (게시물 아이디) — NUMBER — Foreign key → Articles.article_id — NOT NULL
- content (댓글) — VARCHAR
- Field
- member_id (멤버 아이디) — UUID — Foreign key → Member.member_id — NOT NULL
Dashboards (실시간 현황판)
- dashboard_id (실시간 현황판 아이디) — VARCHAR — Primary key — NOT NULL
- Field
Keyword (키워드)
- keyword_id (키워드 아이디) — NUMBER — Primary key — NOT NULL
- keyword (키워드) — VARCHAR
- article_id (게시물 아이디) — NUMBER — Foreign key → Articles.article_id — NOT NULL
Liked Articles (좋아요 한 게시물)
- article_id (게시물 아이디) — NUMBER — Foreign key → Articles.article_id — NOT NULL
- member_id (멤버 아이디) — UUID — Foreign key → Member.member_id — NOT NULL
Member (유저)
- member_id (멤버 아이디) — UUID — Primary key — NOT NULL
- username (유저 이름) — VARCHAR
- user_id (유저 아이디) — VARCHAR
- password (유저 비밀번호) — VARCHAR
- unique_number (유저 고유번호) — VARCHAR
- created_time (생성일자) — DATETIME(6)
- modified_time (수정일자) — DATETIME(6)
MemberChatRoom (유저-채팅방 관계테이블)
- member_id (멤버 아이디) — UUID — Foreign key → Member.member_id — NOT NULL
- CHATROOM_ID (채팅 방 아이디) — NUMBER — Foreign key → ChatRoom.CHATROOM_ID — NOT NULL
- role (권한) — VARCHAR
Ranked Articles (실시간 인기 게시물)
- ranked_articles_id (실시간 인기 게시물 아이디) — NUMBER — Primary key — NOT NULL
- Field
Ranked Keywords (실시간 키워드)
- ranked_keyword_id (실시간 키워드 아이디) — NUMBER — Primary key — NOT NULL
- keyword (키워드) — VARCHAR
- ranking (등수) — NUMBER