7.data-dictionaries_v055.sql

CRM源码This file describes some issues that should be implemented in future and how it should be imple

CREATE VIEW dbo.QW_DD_TICKETSTATUS_VW AS
SELECT
  qw_enumvalue AS pkey, qw_enumlabel AS value
FROM
  QW_FIELDINFO
WHERE (qw_tablename = 'qw_ticket')
  AND (qw_columnname = 'qw_status')
GO

CREATE VIEW dbo.QW_DD_TICKETPRIORITY_VW AS
SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
FROM QW_FIELDINFO
WHERE (qw_tablename = 'qw_ticket')
  AND (qw_columnname = 'qw_priority')
GO

CREATE VIEW dbo.QW_DD_TICKETTYPE_VW AS
SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
FROM QW_FIELDINFO
WHERE (qw_tablename = 'qw_ticket')
  AND (qw_columnname = 'qw_type')
GO

CREATE VIEW dbo.QW_DD_TICKETSOURCE_VW AS
SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
FROM QW_FIELDINFO
WHERE (qw_tablename = 'qw_ticket')
  AND (qw_columnname = 'qw_source')
GO

CREATE VIEW dbo.QW_DD_TICKETIMPACT_VW AS
SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
FROM QW_FIELDINFO
WHERE (qw_tablename = 'qw_ticket')
  AND (qw_columnname = 'qw_impact')
GO

CREATE VIEW dbo.QW_DD_ADDRESSTYPE_VW AS
SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
FROM QW_FIELDINFO
WHERE (qw_tablename = 'qw_address')
  AND (qw_columnname = 'qw_addresstype')
GO

CREATE VIEW dbo.QW_DD_EMPLOYEEREACHBY_VW AS
SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
FROM QW_FIELDINFO
WHERE (qw_tablename = 'qw_employee')
  AND (qw_columnname = 'qw_reachby')
GO

CREATE VIEW dbo.QW_DD_TICKETWHYCLOSED_VW AS
SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
FROM QW_FIELDINFO
WHERE (qw_tablename = 'qw_ticket')
  AND (qw_columnname = 'qw_reasoncallid')
GO

CREATE VIEW dbo.QW_DD_INTERSOURCE_VW AS
SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
FROM QW_FIELDINFO
WHERE (qw_tablename = 'qw_interaction')
  AND (qw_columnname = 'qw_source')
GO

CREATE VIEW dbo.QW_DD_INTERACTION_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_interaction')
		AND (qw_columnname = 'qw_action')
GO

CREATE VIEW dbo.QW_DD_TNSENDMODE_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_ticketnotification')
		  AND (qw_columnname = 'qw_sendmode')
go

CREATE VIEW dbo.QW_DD_NOTIFICATIONSTATUS_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_ticketnotification_status')
		AND (qw_columnname = 'qw_status')
go

CREATE VIEW dbo.QW_DD_NOTIFICATIONPRIORITY_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_ticketnotification_priority')
		AND (qw_columnname = 'qw_priority')
go

CREATE VIEW dbo.QW_DD_NOTIFICATIONRECIPIENT_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_ticketnotification_recip')
		AND (qw_columnname = 'qw_recipient')
go

CREATE VIEW dbo.QW_DD_ESCALATIONSTATUS_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_ticketescalation_status')
		AND (qw_columnname = 'qw_status')
go

CREATE VIEW dbo.QW_DD_ESCALATIONPRIORITY_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_ticketescalation_priority')
		AND (qw_columnname = 'qw_priority')
go

CREATE VIEW dbo.QW_DD_ESCALATIONRECIPIENT_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_ticketescalation_recipient')
		AND (qw_columnname = 'qw_recipient')
go

CREATE VIEW dbo.QW_DD_ESCALATIONFIREIF_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_ticketescalation')
		  AND (qw_columnname = 'qw_fireif')
go

CREATE VIEW dbo.QW_DD_ESCALATIONTIMEUNIT_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_ticketescalation')
		  AND (qw_columnname = 'qw_timeunit')
go

CREATE VIEW dbo.QW_DD_SOLUTIONTOPIC_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_solution')
		  AND (qw_columnname = 'qw_topic')
go

CREATE VIEW dbo.QW_DD_SOLUTIONSTATUS_VW AS
	SELECT qw_enumvalue AS pkey, qw_enumlabel AS value
	FROM QW_FIELDINFO
	WHERE (qw_tablename = 'qw_solution')
		  AND (qw_columnname = 'qw_solutionstatus')
go

CREATE VIEW dbo.QW_DD_WORKFLOWOBJECTS_VW AS
SELECT
  qw_enumvalue AS pkey, qw_enumlabel AS value
FROM
  QW_FIELDINFO
WHERE (qw_tablename = 'qw_workflow')
  AND (qw_columnname = 'qw_objecttype')
GO

CREATE VIEW QW_DD_WORKFLOWSTATUS_VW AS
SELECT 
  qw_enumvalue AS pkey, qw_enumlabel AS value, 0 AS object
FROM 
  QW_FIELDINFO
WHERE (qw_tablename = 'qw_solution')
  AND (qw_columnname = 'qw_solutionstatus')
UNION ALL
SELECT 
  qw_enumvalue AS pkey, qw_enumlabel AS value, 1
FROM 
  QW_FIELDINFO
WHERE (qw_tablename = 'qw_ticket')
  AND (qw_columnname = 'qw_status')
GO