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