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