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)