API GetPrivacyConsents: Porovnání verzí
Skočit na navigaci
Skočit na vyhledávání
Založena nová stránka s textem „df“ |
Bez shrnutí editace |
||
| (Nejsou zobrazeny 3 mezilehlé verze od stejného uživatele.) | |||
| Řádek 1: | Řádek 1: | ||
==== 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 | |||
|- | |||
|ID | |||
|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 of customer from customer list (see relation) | |||
|API_GetCustomers.CompanyName | |||
|- | |||
|ConsentTypeID | |||
|int | |||
|Consent type ID | |||
| | |||
|- | |||
|ConsentType | |||
|nvarchar(100) | |||
|Consent type | |||
| | |||
|- | |||
|Timestamp | |||
|datetime | |||
|Timestamp | |||
| | |||
|- | |||
|IP | |||
|nvarchar(50) | |||
|IP address | |||
| | |||
|- | |||
|Headers | |||
|text | |||
|Headers | |||
| | |||
|- | |||
|State | |||
|int | |||
|State | |||
| | |||
|} | |||
==== Example ==== | |||
<syntaxhighlight lang="sql"> | |||
SELECT TOP 1000 * FROM [API_GetPrivacyConsents] | |||
</syntaxhighlight> | |||
==== Notices ==== | |||
None. | |||
Aktuální verze z 31. 5. 2018, 12:12
Description
Method gives You overview of existing privacy consents in system.
Exact name
API_GetPrivacyConsents
Type
Standard view.
Specification
| Column | Data type | Description | Relation |
|---|---|---|---|
| ID | 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 of customer from customer list (see relation) | API_GetCustomers.CompanyName |
| ConsentTypeID | int | Consent type ID | |
| ConsentType | nvarchar(100) | Consent type | |
| Timestamp | datetime | Timestamp | |
| IP | nvarchar(50) | IP address | |
| Headers | text | Headers | |
| State | int | State |
Example
SELECT TOP 1000 * FROM [API_GetPrivacyConsents]
Notices
None.