API GetPrivacyConsents - Historie editací

Chrzaszcz v 31. 5. 2018, 12:12

2018-05-31T12:12:45Z

2018-05-31T12:11:11Z

2018-05-31T12:09:46Z

2018-05-31T12:05:09Z

2018-05-31T12:04:56Z

Založena nová stránka s textem „df“

Nová stránka

@@ Řádka 15: / Řádka 15: @@
 !Relation
 |-
-|PRIVACYConsentID
+|ID
 |int
 |Internal system id

@@ Řádka 52: / Řádka 52: @@
 |IP
 |nvarchar(50)
-|IP
+|IP address
+|
 |-

@@ Řádka 32: / Řádka 32: @@
 |CompanyName
 |nvarchar(250)
-|Company name
+|Company name of customer from customer list (see relation)
+|API_GetCustomers.CompanyName
 |-
 |ConsentTypeID
 |int
+|Consent type ID
+|
 |-
 |ConsentType
 |nvarchar(100)
+|Consent type
+|
 |-
@@ Řádka 52: / Řádka 52: @@
 |IP
 |nvarchar(50)
+|IP
+|
 |-
 |Headers
 |text
+|Headers
+|
 |-
 |State
 |int
+|State
+|
 |}

← Starší verze		Verze z 31. 5. 2018, 12:05
Řádka 1:		Řádka 1:
−	df	+	==== Description ====
		+	Method gives You overview of existing privacy consents in system.
		+
		+	==== Exact name ====
		+	<code>API_GetPrivacyConsents</code>
		+
		+	==== Type ====
		+	Standard view.
		+
		+	==== Specification ====
		+	{\| class="wikitable"
		+	!Column
		+	!Data type
		+	!Description
		+	!Relation
		+	\|-
		+	\|PRIVACYConsentID
		+	\|int
		+	\|Internal system id
		+	\|
		+	\|-
		+	\|CustomersID
		+	\|int
		+	\|ID of customer from customer list (see relation)
		+	\|API_GetCustomers.ID
		+	\|-
		+	\|BranchID
		+	\|int
		+	\|ID of branche from branch list (see relation)
		+	\|API_GetBranches.ID
		+	\|-
		+	\|CompanyName
		+	\|nvarchar(250)
		+	\|Company name
		+	\|
		+	\|-
		+	\|ConsentTypeID
		+	\|int
		+	\|
		+	\|
		+	\|-
		+	\|ConsentType
		+	\|nvarchar(100)
		+	\|
		+	\|
		+	\|-
		+	\|Timestamp
		+	\|datetime
		+	\|Timestamp
		+	\|
		+	\|-
		+	\|IP
		+	\|nvarchar(50)
		+	\|
		+	\|
		+	\|-
		+	\|Headers
		+	\|text
		+	\|
		+	\|
		+	\|-
		+	\|State
		+	\|int
		+	\|
		+	\|
		+	\|}
		+
		+	==== Example ====
		+	<syntaxhighlight lang="sql">
		+	SELECT TOP 1000 * FROM [API_GetPrivacyConsents]
		+	</syntaxhighlight>
		+
		+	==== Notices ====
		+	None.