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