TIMELINE_DB

Tables (6)

CRM_TEAM

  • TEAM_ID — NUMBER — Primary key — NOT NULL
  • TEAM_NAME — VARCHAR(50)

CRM_USER

  • USER_ID — NUMBER — Primary key — NOT NULL
  • USER_NAME — VARCHAR(20)
  • USER_PHONE — VARCHAR(20)
  • USER_EMAIL — VARCHAR(50)

CRM_USER_TEAM_REL

  • TEAM_ID — NUMBER — Foreign key → CRM_TEAM.TEAM_ID — NOT NULL
  • USER_ID — NUMBER — Foreign key → CRM_USER.USER_ID — NOT NULL

EVENT

  • EVENT_TYPE_ID — NUMBER — Primary key — NOT NULL
  • EVENT_TYPE_NAME — VARCHAR(20)

MONITORED_TABLE

  • TABLE_ID — NUMBER — Primary key — NOT NULL
  • TABLE_NAME — VARCHAR(50)
  • MONITORED_OBJECT_COLUMN — VARCHAR(50)
  • MONITORED_PK_COLUMN — VARCHAR(50)

TIMELINE

  • EVENT_ID — NUMBER — Primary key — NOT NULL
  • USER_ID — NUMBER — Foreign key → CRM_USER.USER_ID — NOT NULL
  • EVENT_TYPE_ID — NUMBER — Foreign key → EVENT.EVENT_TYPE_ID — NOT NULL
  • TABLE_ID — NUMBER — Foreign key → MONITORED_TABLE.TABLE_ID — NOT NULL
  • EVENT_TIME — TIMESTAMP
  • OBJECT_NAME — VARCHAR(100)