| Name | Description | Type | Additional information |
|---|---|---|---|
| CustomerID |
Primary Key |
integer |
None. |
| FullName |
Full name of customer |
string |
None. |
| EmpCode |
Employee code of customer if any restaurant offers any discount to any company |
string |
None. |
|
Email address of customer it can be null |
string |
None. |
|
| CarDetails |
Detail of customer car, can be null |
string |
None. |
| Country |
Country Name |
string |
None. |
| City |
City Name |
string |
None. |
| Area |
Area name in city |
string |
None. |
| Address |
Full Address detail of customer |
string |
Max length: 400 |
| ZipCode |
Zip code of the area |
string |
None. |
| DOB |
Date of Birth with mentioned format : 2020-06-25 |
string |
Matching regular expression pattern: ^\d{4}-\d{2}-\d{2}$ |
| Gender |
Gender Male or Female |
string |
None. |
| TelePhone |
Any Landline contact number |
string |
None. |
| Mobile |
Mobile phone contact number |
string |
Required Matching regular expression pattern: ^[+]\d{10,15}$ |
| Notes |
Any notes related to customer |
string |
None. |
| AddedAt | string |
Matching regular expression pattern: ^\d{4}-\d{2}-\d{2}-\d{2}-\d{2}-\d{2}$ |
|
| VatID | string |
None. |
|
| SyncStatus | RStatus |
None. |
|
| StatusID | DStatus |
None. |
|
| NationalID | string |
Matching regular expression pattern: (^$)|(^[0-9]{10}$) |