NameDescriptionTypeAdditional 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

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}$)