message_model

Tables (8)

message_targets (메세지 수신 대상)

  • fk (message_id) — bigint — Foreign key → messages.pk — NOT NULL
  • fk (user_id) — bigint — Foreign key → user.pk — NOT NULL

messages (메세지)

  • pk (id) — bigint — Primary key — NOT NULL
  • fk (organization_id) — bigint — Foreign key → organizations.pk — NOT NULL
  • fk (sender_id) — bigint
  • fk (provider_id) — bigint — Foreign key → providers.pk — NOT NULL
  • 내용 (content) — text
  • 전송상태 (status) — vharchar(50)
  • 전송일자 (sent_at) — timestamp

organizations (조직)

  • pk (id) — bigint — Primary key — NOT NULL
  • fk (provider_id) — bigint — Foreign key → providers.pk — NOT NULL
  • 조직이름 (name) — varchar(100)
  • 등록일 (created_at) — timestamp
  • 변경일 (updated_at) — timestamp

provider_credentials (업체 연동 정보)

  • pk (id) — bigint — Primary key — NOT NULL
  • fk (organization_id) — bigint — Foreign key → organizations.pk — NOT NULL
  • fk (provider_id) — bigint — Foreign key → providers.pk — NOT NULL
  • api 연동키 (api_key) — varchar(255)
  • api 비밀키 (secret_key) — varchar(255)

providers (제공 업체)

  • pk (id) — bigint — Primary key — NOT NULL
  • 업체이름 (name) — varchar(100)
  • 타입 (type) — varchar(50)

user (회원)

  • pk (id) — bigint — Primary key — NOT NULL
  • fk (organization_id) — bigint — Foreign key → organizations.pk — NOT NULL
  • 이름 (name) — varchar(100)
  • 권한 (role) — varchar(50)

user_group_member (조직 - 회원 중간테이블)

  • fk (user_id) — bigint — Foreign key → user.pk — NOT NULL
  • fk (user_group_id) — bigint — Foreign key → user_groups.pk — NOT NULL

user_groups (조직 내 그룹)

  • pk (id) — bigint — Primary key — NOT NULL
  • 그룹이름 (name) — varchar(100)
  • fk (organization_id) — bigint — Foreign key → organizations.pk — NOT NULL