Make you feel better ERD

Tables (13)

chat_message

  • chat_id — VARCHAR(255) — Primary key — NOT NULL — document_id
  • chat_room_id (chat_room_id2) — VARCHAR(255) — Foreign key → chat_room_document.chat_room_id — NOT NULL — chat_room document_id
  • sender_id — VARCHAR(255) — Foreign key → user.uuid — NOT NULL — 유저 ID
  • message — TEXT — NOT NULL — 채팅 본문
  • state — TINYINT — NOT NULL — 삭제 여부
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

chat_room_document

  • chat_room_id — VARCHAR(255) — Primary key — NOT NULL — document_id
  • user_id — LIST<String> — Foreign key → user.uuid — NOT NULL — 유저 ID list
  • state — TINYINT — NOT NULL — 삭제 여부
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

comment

  • id — INT — Primary key — NOT NULL — pk
  • user_id — VARCHAR(255) — Foreign key → user.uuid — NOT NULL — 유저 ID
  • target_id — INT — Foreign key → posting.id — NOT NULL — 댓글 타겟 id (pk)
  • content — TEXT — NOT NULL — 본문
  • category — TINYINT — NOT NULL — 댓글 타겟 종류 ( 1 : posting, 2: comment )
  • state — TINYINT — NOT NULL — 삭제 여부
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

follow

  • id — INT — Primary key — NOT NULL — pk
  • follower — VARCHAR(255) — Foreign key → user.uuid — NOT NULL — follower 유저 ID
  • followee — VARCHAR(255) — NOT NULL — followee 유저 ID
  • state — TINYINT — NOT NULL — 삭제 여부
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

letter

  • id — INT — Primary key — NOT NULL — pk
  • user_id — VARCHAR(255) — Foreign key → user.uuid — NOT NULL — 발송자 유저 ID
  • receiver_user_id — VARCHAR(255) — NOT NULL — 수신자 유저 ID
  • conetnet (content) — TEXT — NOT NULL — 편지 본문
  • sended — TINYINT — NOT NULL — 발송 여부
  • received — TINYINT — NOT NULL — 수신 여부
  • receiver_state — TINYINT — NOT NULL — 수신자 삭제 여부
  • state — TINYINT — NOT NULL — 삭제 여부
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

like

  • id — INT — Primary key — NOT NULL — pk
  • user_id — VARCHAR(255) — Foreign key → user.uuid — NOT NULL — 유저 ID
  • target_id (id2) — INT — Foreign key → comment.id — NOT NULL — 좋아요 타겟 id (pk)
  • target_id — INT — Foreign key → posting.id — NOT NULL — 좋아요 타겟 id (pk)
  • category — TINYINT — NOT NULL — 좋아요 타겟 종류 ( 1 : posting, 2: comment )
  • state — TINYINT — NOT NULL — 삭제 여부
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

posting

  • id — INT — Primary key — NOT NULL — pk
  • user_id — VARCHAR(255) — Foreign key → user.uuid — NOT NULL — 유저 ID
  • content — TEXT — NOT NULL — 본문
  • media_exist — TINYINT — NOT NULL — 멀티미디어 존재 여부
  • state — TINYINT — NOT NULL — 삭제 여부
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

privilege

  • id — INT — Primary key — NOT NULL — pk
  • privilege_name — VARCHAR(10) — NOT NULL — 권한명
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

report

  • id — INT — Primary key — NOT NULL — pk
  • user_id — VARCHAR(255) — Foreign key → user.uuid — NOT NULL — 유저 ID
  • category — TINYINT — NOT NULL — 신고 타겟 종류 ( 1 : posting, 2: comment, 3: user )
  • target_id — INT — NOT NULL — 신고 타겟 ID (pk)
  • state — TINYINT — NOT NULL — 삭제 여부
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

role

  • id — INT — Primary key — NOT NULL — pk
  • role_name — VARCHAR(10) — NOT NULL — 역할명
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

role_privilege

  • id — INT — Primary key — NOT NULL — pk
  • role_id — INT — Foreign key → role.id — NOT NULL — 역할 pk
  • privilege_id — INT — Foreign key → privilege.id — NOT NULL — 권한 pk
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

user

  • uuid — INT — Primary key — NOT NULL — pk
  • user_id — VARCHAR(255) — NOT NULL — 유저 ID
  • password — VARCHAR(300) — NOT NULL — 비밀번호
  • nickname — VARCHAR(15) — NOT NULL — 닉네임
  • email — VARCHAR(123) — NOT NULL — 이메일
  • phone_number — VARCHAR(20) — 휴대폰 번호
  • oauth — TINYINT — NOT NULL — OAuth 여부
  • registration_id — VARCHAR(20) — OAuth resource registration id
  • state — TINYINT — NOT NULL — 삭제 여부
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자

user_role

  • id — INT — Primary key — NOT NULL — pk
  • uuid — INT — Foreign key → user.uuid — NOT NULL — 유저 pk
  • role_id — INT — Foreign key → role.id — NOT NULL — 역할 pk
  • created_at — TIMESTAMP — NOT NULL — 생성 시점
  • created_by — VARCHAR(255) — NOT NULL — 생성자
  • updated_at — TIMESTAMP — 수정 시점
  • updated_by — VARCHAR(2550) — 수정자