API GetWorkshops: Porovnání verzí

Aktuální verze z 25. 7. 2017, 13:52

Method gives You overview of existing workshop in system.

API_GetWorkshops

Standard view.

Column	Data type	Description	Relation
ID	int	Internal system id
Name	nvarchar(100)	Workshop name
Street	nvarchar(200)	Street
City	nvarchar(120)	City
ZIPCode	nvarchar(15)	ZIP code
Country	nvarchar(70)	Country
Region	nvarchar(70)	Region
State	nvarchar(80)	State
StateID	int	ID of country from country list (see relation)	API_GetCountry.ID
PhoneNumber	nvarchar(50)	Phone number
Fax	nvarchar(50)	Fax
MobilePhone	nvarchar(50)	Mobile phone
Email	nvarchar(70)	Email
Web	nvarchar(120)	Web address

SELECT TOP 1000 * FROM [API_GetWorkshops]

None.

@@ Řádek 1: / Řádek 1: @@
-Description
+==== Description ====
-Method gives You overview of existing branches in system
+Method gives You overview of existing workshop in system.
+====Exact name====
-Exact name
+<code>API_GetWorkshops</code>
-API_GetBranches
+====Type====
-Type
 Standard view.
+====Specification====
-Specification
+{| class="wikitable"
+!Column
+!Data type
+!Description
+!Relation
+|-
+|ID
+|int
+|Internal system id
+|
+|-
+|Name
+|nvarchar(100)
+|Workshop name
+|
+|-
+|Street
+|nvarchar(200)
+|Street
+|
+|-
+|City
+|nvarchar(120)
+|City
+|
+|-
+|ZIPCode
+|nvarchar(15)
+|ZIP code
+|
+|-
+|Country
+|nvarchar(70)
+|Country
+|
+|-
+|Region
+|nvarchar(70)
+|Region
+|
+|-
+|State
+|nvarchar(80)
+|State
+|
+|-
+|StateID
+|int
+|ID of country from country list (see relation)
+|API_GetCountry.ID
+|-
+|PhoneNumber
+|nvarchar(50)
+|Phone number
+|
+|-
+|Fax
+|nvarchar(50)
+|Fax
+|
+|-
+|MobilePhone
+|nvarchar(50)
+|Mobile phone
+|
+|-
+|Email
+|nvarchar(70)
+|Email
+|
+|-
+|Web
+|nvarchar(120)
+|Web address
+|
+|}
+====Example====
+<syntaxhighlight lang="sql">
+SELECT TOP 1000 * FROM [API_GetWorkshops]
+</syntaxhighlight>
+====Notices====
+<span> </span>None.