VOC REPORT
Tables (3)
TB_REPORT_ITEM
- REPORT_ID — UNIQUEIDENTIFIER — Primary key — NOT NULL
- TITLE — NVARCHAR(256)
- CREATOR_ID — VARCHAR(32)
- CREATOR_NAME — VARCHAR(256)
- CREATED_DATE — DATETIME
TB_REPORT_ITEM_ACL
- UNID — UNIQUEIDENTIFIER — NOT NULL
- REPORT_ID (REPORT_ID2) — UNIQUEIDENTIFIER — Foreign key → TB_REPORT_ITEM.REPORT_ID — NOT NULL
- MEMBER_ID — VARCHAR(32)
- MEMBER_NAME — VARCHAR(256)
- MEMBER_TYPE — VARCHAR(50)
TB_REPORT_ITEM_MENTION
- UNID — UNIQUEIDENTIFIER — Primary key
- REPORT_ID — UNIQUEIDENTIFIER — Foreign key → TB_REPORT_ITEM.REPORT_ID — NOT NULL
- MENTION_ID — NVARCHAR(256) — NOT NULL