message_service_erd - 2023-09-07 16:24:02 - 2023-09-07 16:56:44

Tables (6)

CONVERSATION (대화 정보(변경 전))

  • CONVERSATION_ID (conversationId) — NUMBER — Primary key — NOT NULL — 대화 ID
  • Field (content) — VARCHAR2(4000) — 대화내용

Copy Of CONVERSATION (소통 내용)

  • CONVERSATION_ID (COMUNICATION_ID) — NUMBER — Primary key — NOT NULL — 소통 ID
  • SUBSCRIPTION_ID (CUSTOMER_ID) — NUMBER — Foreign key — NOT NULL — 소통하는 고객의 ID
  • Field (CONTENT) — VARCHAR2(4000) — NOT NULL — 소통 내용

Copy Of SUBSCRIPTION (고객)

  • SUBSCRIPTION_ID (CUSTOMER_ID) — NUMBER — Primary key — NOT NULL — 고객ID
  • Field (NAME) — VARCHAR2(100) — 고객이름
  • Field (PHONE_NUMBER) — VARCHAR2(256) — NOT NULL — 고객연락처
  • CONVERSATION_ID (LATEST_COMUNICATION_ID) — NUMBER — Foreign key — 고객별 마지막 소통 ID

SUBSCRIPTION (연락처 정보(변경 전))

  • SUBSCRIPTION_ID (subscriptionId) — NUMBER — Primary key — NOT NULL — 연락처 ID
  • LATEST_CONVERSATION_ID (latestConversationId) — NUMBER — Foreign key — NOT NULL — 연락처별 마지막 메세지 ID

Untitled (연락 수단)

  • Key (CONTACT_ID) — NUMBER — Primary key — NOT NULL — 연락수단ID
  • Field (CUSTOMER_ID) — NUMBER — NOT NULL — 고객ID
  • Field (CONTACT_TYPE) — NUMBER — NOT NULL — 연락수단
  • Field (CONTACT_DATA) — VARCHAR2(256) — NOT NULL — 연락데이터

Untitled (고객의 연락 수단 별 마지막 소통)

  • Key (LAST_COMUNICATION_ID) — NUMBER — Primary key — NOT NULL — 마지막연락ID
  • Field (CUSTOMER_ID) — NUMBER — NOT NULL — 고객ID
  • Field (CONTACT_TYPE) — NUMBER — NOT NULL — 연락수단
  • Field (COMUNICATION_ID) — NUMBER — NOT NULL — 소통ID