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