chat-server
Tables (22)
AUDIT_LOGS
- ID — BIGSERIAL — Primary key — NOT NULL
- CREATED_AT — TIMESTAMPTZ — Primary key — NOT NULL — hypertable
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- AUDIT_SCOPE — VARCHAR(20) — NOT NULL — PLATFORM:
- ACTOR_ID — BIGINT — NOT NULL — 행위자
- ACTOR_TYPE — VARCHAR(20) — NOT NULL — USER:
- ACTION_CATEGORY — VARCHAR(30) — NOT NULL — 행위
- ACTION — VARCHAR(50) — NOT NULL — 구체적
- RESOURCE_TYPE — VARCHAR(30) — NOT NULL — 대상
- RESOURCE_ID — BIGINT — 대상
- RESOURCE_UID — CHAR(26) — 대상
- DETAIL — JSONB — 행위
- IP_ADDR — VARCHAR(45) — NOT NULL — 행위자
- USER_AGENT — VARCHAR(500) — 행위자
- RESULT — VARCHAR(20) — NOT NULL — SUCCESS:
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
CHAT_ROOMS
- ID — BIGSERIAL — Primary key — NOT NULL
- ROOM_UID — CHAR(26) — NOT NULL
- TENANT_ID — BIGINT — NOT NULL
- ROOM_TYPE — VARCHAR(20) — NOT NULL
- ROOM_NAME — VARCHAR(100) — NOT NULL
- CREATED_BY — BIGINT — Foreign key → USERS.ID
- MAX_MEMBERS — INT
- DESCRIPTION — VARCHAR(500)
- CREATED_USER_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMPTZ — NOT NULL
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL
- UPDATED_AT — TIMESTAMPTZ
- UPDATED_USER_ID — BIGINT
- UPDATED_IP_ADDR — VARCHAR(45)
- USE_YN — CHAR(1) — NOT NULL
CHAT_ROOM_MEMBERS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL
- ROOM_ID — BIGINT — Foreign key → CHAT_ROOMS.ID — NOT NULL
- USER_ID — BIGINT — Foreign key → USERS.ID — NOT NULL
- MEMBER_ROLE — VARCHAR(20) — NOT NULL
- JOINED_AT — TIMESTAMPTZ — NOT NULL
- INVITED_BY — BIGINT — Foreign key → USERS.ID
- CREATED_USER_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMPTZ — NOT NULL
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL
- UPDATED_AT — TIMESTAMPTZ
- UPDATED_USER_ID — BIGINT
- UPDATED_IP_ADDR — VARCHAR(45)
- USE_YN — CHAR(1) — NOT NULL
- Field
- Field2
COMMON_CODES
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 0:
- GROUP_ID — BIGINT — Foreign key → COMMON_CODE_GROUPS.ID — NOT NULL — FK
- CODE — VARCHAR(50) — NOT NULL — 코드
- CODE_NAME — VARCHAR(100) — NOT NULL — 코드
- SORT_ORDER — INT — NOT NULL — 화면
- DESCRIPTION — VARCHAR(500) — 코드
- EXTRA_VALUE1 — VARCHAR(255) — 부가
- EXTRA_VALUE2 — VARCHAR(255) — 부가
- EXTRA_VALUE3 — VARCHAR(255) — 부가
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
COMMON_CODE_GROUPS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 0:
- GROUP_CODE — VARCHAR(50) — NOT NULL — 그룹
- GROUP_NAME — VARCHAR(100) — NOT NULL — 그룹
- DESCRIPTION — VARCHAR(500) — 그룹
- SYSTEM_YN — CHAR(1) — NOT NULL — Y:
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
FILE_ATTACHMENTS
- ID — BIGSERIAL — Primary key — NOT NULL
- 테넌트 (TENANT_ID) — BIGINT — NOT NULL
- MESSAGE_UID — CHAR(26) — NOT NULL
- FILE_PATH — VARCHAR(500) — NOT NULL
- ORIGINAL_NAME — VARCHAR(255) — NOT NULL
- MIME_TYPE — VARCHAR(100) — NOT NULL
- FILE_SIZE — BIGINT — NOT NULL
- FILE_HASH — CHAR(64)
- THUMBNAIL_PATH — VARCHAR(500)
- IMAGE_WIDTH — INT
- IMAGE_HEIGHT — INT
- CREATED_USER_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMPTZ — NOT NULL
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL
- UPDATED_AT — TIMESTAMPTZ
- UPDATED_USER_ID — BIGINT
- UPDATED_IP_ADDR — VARCHAR(45)
- USE_YN — CHAR(1) — NOT NULL
FILE_GROUPS
- ID — BIGSERIAL — Primary key — NOT NULL
- FILE_GROUP_UID — CHAR(26) — NOT NULL — 외부
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- USAGE_TYPE — VARCHAR(20) — NOT NULL — CHAT_MESSAGE:
- STATUS — VARCHAR(20) — NOT NULL — UPLOADING:
- MESSAGE_UID — CHAR(26) — MESSAGES.MESSAGE_UID
- REFERENCE_ID — BIGINT — 프로필/아바타
- TOTAL_FILE_COUNT — INT — NOT NULL — 그룹
- TOTAL_FILE_SIZE — BIGINT — NOT NULL — 그룹
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
FILE_GROUP_ITEMS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- FILE_GROUP_ID — BIGINT — Foreign key → FILE_GROUPS.ID — NOT NULL — FK
- SORT_ORDER — INT — NOT NULL — 그룹
- FILE_PATH — VARCHAR(500) — NOT NULL — 저장
- ORIGINAL_NAME — VARCHAR(255) — NOT NULL — 원본
- MIME_TYPE — VARCHAR(100) — NOT NULL — MIME
- FILE_SIZE — BIGINT — NOT NULL — 파일
- FILE_HASH — CHAR(64) — SHA-256.
- THUMBNAIL_PATH — VARCHAR(500) — 이미지
- IMAGE_WIDTH — INT — 이미지
- IMAGE_HEIGHT — INT — 이미지
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
MESSAGES
- ID — BIGSERIAL — Primary key — NOT NULL
- CREATED_AT — TIMESTAMPTZ — Primary key — NOT NULL
- MESSAGE_UID — CHAR(26) — NOT NULL
- TENANT_ID — BIGINT — NOT NULL
- ROOM_ID — BIGINT — NOT NULL
- SENDER_ID — BIGINT — NOT NULL
- MESSAGE_TYPE — VARCHAR(20) — NOT NULL
- PARENT_MESSAGE_UID — CHAR(26)
- DATA — JSONB — NOT NULL
- EDITED_AT — TIMESTAMPTZ
- CREATED_USER_ID — BIGINT — NOT NULL
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL
- UPDATED_AT — TIMESTAMPTZ
- UPDATED_USER_ID — BIGINT
- UPDATED_IP_ADDR — VARCHAR(45)
- USE_YN — CHAR(1) — NOT NULL
MESSAGE_BOOKMARKS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- USER_ID — BIGINT — Foreign key — NOT NULL — FK
- MESSAGE_UID — CHAR(26) — NOT NULL — MESSAGES.MESSAGE_UID
- ROOM_ID — BIGINT — NOT NULL — 메시지가
- MEMO — VARCHAR(500) — 사용자
- BOOKMARKED_AT — TIMESTAMPTZ — NOT NULL — 북마크
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
MESSAGE_MENTIONS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- MESSAGE_UID — CHAR(26) — NOT NULL — MESSAGES.MESSAGE_UID
- MENTIONED_USER_ID — BIGINT — Foreign key — NOT NULL — FK
- MENTION_TYPE — VARCHAR(20) — NOT NULL — USER:
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
MESSAGE_REACTIONS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL
- MESSAGE_UID — CHAR(26) — NOT NULL
- USER_ID — BIGINT — Foreign key → USERS.ID — NOT NULL
- EMOJI — VARCHAR(10) — NOT NULL
- REACTED_AT — TIMESTAMPTZ — NOT NULL
- CREATED_USER_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMPTZ — NOT NULL
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL
- UPDATED_AT — TIMESTAMPTZ
- UPDATED_USER_ID — BIGINT
- UPDATED_IP_ADDR — VARCHAR(45)
- USE_YN — CHAR(1) — NOT NULL
MODERATION_LOG
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- ROOM_ID — BIGINT — NOT NULL — 위반이
- USER_ID — BIGINT — NOT NULL — 위반자
- MESSAGE_UID — CHAR(26) — NOT NULL — MESSAGES.MESSAGE_UID
- RULE_ID — BIGINT — Foreign key → MODERATION_RULES.ID — NOT NULL — FK
- ACTION_TAKEN — VARCHAR(20) — NOT NULL — 실제
- ORIGINAL_CONTENT — TEXT — NOT NULL — 위반
- PROCESSED_AT — TIMESTAMPTZ — NOT NULL — 처리
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
MODERATION_RULES
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- RULE_TYPE — VARCHAR(30) — NOT NULL — BANNED_WORD:
- PATTERN — VARCHAR(500) — NOT NULL — 매칭
- ACTION — VARCHAR(20) — NOT NULL — BLOCK:
- SEVERITY — VARCHAR(20) — NOT NULL — LOW:
- PRIORITY — INT — NOT NULL — 우선순위.
- ENABLED_YN — CHAR(1) — NOT NULL — Y:
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
NOTIFICATIONS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- USER_ID — BIGINT — Foreign key — NOT NULL — FK
- NOTIFICATION_TYPE — VARCHAR(50) — NOT NULL — 알림
- REFERENCE_TYPE — VARCHAR(30) — 참조
- REFERENCE_ID — BIGINT — 참조
- TITLE — VARCHAR(200) — NOT NULL — 알림
- BODY — VARCHAR(1000) — NOT NULL — 알림
- CHANNEL — VARCHAR(20) — NOT NULL — IN_APP:
- DELIVERY_STATUS — VARCHAR(20) — NOT NULL — PENDING:
- READ_YN — CHAR(1) — NOT NULL — Y:
- SENT_AT — TIMESTAMPTZ — 발송
- FAILED_REASON — VARCHAR(500) — 발송
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
PINNED_MESSAGES
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- ROOM_ID — BIGINT — Foreign key — NOT NULL — FK
- MESSAGE_UID — CHAR(26) — NOT NULL — MESSAGES.MESSAGE_UID
- PINNED_BY — BIGINT — Foreign key — NOT NULL — FK
- PINNED_AT — TIMESTAMPTZ — NOT NULL — 고정
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
ROOM_INVITATIONS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- ROOM_ID — BIGINT — Foreign key — NOT NULL — FK
- INVITE_CODE — VARCHAR(32) — NOT NULL — 초대
- CREATED_BY_USER_ID — BIGINT — Foreign key — NOT NULL — FK
- EXPIRES_AT — TIMESTAMPTZ — NULL:
- MAX_USES — INT — NULL:
- USE_COUNT — INT — NOT NULL — 현재
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
ROOM_SUMMARY
- ID — BIGSERIAL — Primary key — NOT NULL
- ROOM_ID — BIGINT — Foreign key → CHAT_ROOMS.ID — NOT NULL
- TENANT_ID — BIGINT — NOT NULL
- LAST_MESSAGE_UID — CHAR(26)
- LAST_MESSAGE_AT — TIMESTAMPTZ
- LAST_MESSAGE_PREVIEW — VARCHAR(100)
- MESSAGE_COUNT — BIGINT — NOT NULL
- LAST_SENDER_ID — BIGINT
- CREATED_USER_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMPTZ — NOT NULL
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL
- UPDATED_AT — TIMESTAMPTZ
- UPDATED_USER_ID — BIGINT
- UPDATED_IP_ADDR — VARCHAR(45)
- USE_YN — CHAR(1) — NOT NULL
TENANTS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_UID — CHAR(26) — NOT NULL — 외부
- TENANT_NAME — VARCHAR(100) — NOT NULL — 테넌트
- DOMAIN — VARCHAR(255) — 커스텀
- SUBDOMAIN — VARCHAR(63) — NOT NULL — 테넌트
- OWNER_USER_ID — BIGINT — 테넌트
- STATUS — VARCHAR(20) — NOT NULL — TRIAL:
- TIMEZONE — VARCHAR(50) — NOT NULL — IANA
- LOCALE — VARCHAR(10) — NOT NULL — 언어/지역
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
USERS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL
- LOGIN_ID — VARCHAR(100) — NOT NULL
- PASSWORD — VARCHAR(100) — NOT NULL
- DISPLAY_NAME — VARCHAR(100) — NOT NULL
- ROLE — VARCHAR(20) — NOT NULL
- EMAIL — VARCHAR(255)
- LAST_LOGIN_AT — TIMESTAMPTZ
- LOCKED_YN — CHAR(1) — NOT NULL
- CREATED_USER_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMPTZ — NOT NULL
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL
- UPDATED_AT — TIMESTAMPTZ
- UPDATED_USER_ID — BIGINT
- UPDATED_IP_ADDR — VARCHAR(45)
- USE_YN — CHAR(1) — NOT NULL
USER_BLOCKS
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL — 테넌트
- BLOCKER_USER_ID — BIGINT — Foreign key — NOT NULL — FK
- BLOCKED_USER_ID — BIGINT — Foreign key — NOT NULL — FK
- BLOCK_TYPE — VARCHAR(20) — NOT NULL — PERSONAL:
- BLOCK_REASON — VARCHAR(500) — 차단
- BLOCKED_UNTIL — TIMESTAMPTZ — NULL:
- BLOCKED_AT — TIMESTAMPTZ — NOT NULL — 차단
- CREATED_USER_ID — BIGINT — NOT NULL — 생성자
- CREATED_AT — TIMESTAMPTZ — NOT NULL — 생성
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL — 생성자
- UPDATED_AT — TIMESTAMPTZ — 수정
- UPDATED_USER_ID — BIGINT — 수정자
- UPDATED_IP_ADDR — VARCHAR(45) — 수정자
- USE_YN — CHAR(1) — NOT NULL — Y:
USER_ROOM_STATE
- ID — BIGSERIAL — Primary key — NOT NULL
- TENANT_ID — BIGINT — NOT NULL
- ROOM_ID — BIGINT — Foreign key → CHAT_ROOMS.ID — NOT NULL
- USER_ID — BIGINT — Foreign key → USERS.ID — NOT NULL
- LAST_READ_MESSAGE_UID — CHAR(26)
- LAST_READ_AT — TIMESTAMPTZ
- UNREAD_COUNT — INT — NOT NULL
- MUTED_YN — CHAR(1) — NOT NULL
- MUTE_UNTIL — TIMESTAMPTZ
- PINNED_YN — CHAR(1) — NOT NULL
- ALARM_YN — CHAR(1) — NOT NULL
- CREATED_USER_ID — BIGINT — NOT NULL
- CREATED_AT — TIMESTAMPTZ — NOT NULL
- CREATED_IP_ADDR — VARCHAR(45) — NOT NULL
- UPDATED_AT — TIMESTAMPTZ
- UPDATED_USER_ID — BIGINT
- UPDATED_IP_ADDR — VARCHAR(45)
- USE_YN — CHAR(1) — NOT NULL