NameDescriptionTypeAdditional information
cust_num

integer

None.

last_name

string

Required

String length: inclusive between 0 and 40

first_name

string

Required

String length: inclusive between 0 and 40

id_num

string

Matching regular expression pattern: ^[0-9]{9}$|null

String length: inclusive between 0 and 9

street

string

String length: inclusive between 0 and 33

home

integer

None.

p_o_b

integer

None.

email

string

Max length: 30

mailing

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

sex

string

Matching regular expression pattern: ^[mfu/s]{1}$

String length: inclusive between 0 and 1

born

date

None.

brit_name

string

String length: inclusive between 0 and 40

father_name

string

String length: inclusive between 0 and 40

creation_date

date

None.

remark

string

String length: inclusive between 0 and 254

created_record

date

None.

updated_record

date

None.

city_code

integer

None.

branch_code

integer

None.

business_branch_code

integer

None.

insur_code

integer

None.

district_code

integer

None.

active

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

prefix

string

String length: inclusive between 0 and 1

oocust

integer

None.

addphone_rem

string

String length: inclusive between 0 and 20

mactokef

date

None.

status_code

integer

None.

pasport

string

String length: inclusive between 0 and 16

adviser_code

integer

None.

menahel_code

string

String length: inclusive between 0 and 15

apartment_num

string

String length: inclusive between 0 and 4

oow_code

integer

None.

azip

string

String length: inclusive between 0 and 7

file_finish

string

String length: inclusive between 0 and 5

sensitivity

string

String length: inclusive between 0 and 240

brit_name_first

string

String length: inclusive between 0 and 40

smoker

string

Matching regular expression pattern: ^[yna]{1}$

String length: inclusive between 0 and 1

jump_sensitivity

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

with_password

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

sendmail_from

date

None.

palestinian

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

get_reminder_sms

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

internet_answers

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

old_cust_num

integer

None.

archive_num

integer

None.

clalit_num

string

Max length: 11

String length: inclusive between 0 and 11

homephone

string

String length: inclusive between 0 and 12

workphone

string

String length: inclusive between 0 and 12

mobilephone

string

String length: inclusive between 0 and 12

fax

string

Max length: 12

addphone

string

Max length: 12

import_cust_num

integer

None.

entrance

string

String length: inclusive between 0 and 2

country_code

integer

None.

blood_type

string

String length: inclusive between 0 and 5

escort_phone

string

Max length: 12

prof_code

integer

None.

parent_account

integer

None.

interface_code

string

String length: inclusive between 0 and 10

old_code

integer

None.

system_customer

string

String length: inclusive between 0 and 1

date_came_daycare

date

None.

birth_week

integer

None.

birth_weight

decimal number

None.

corrected_age_date

date

None.

calculated_age

integer

None.

room

integer

None.

Countries

Country

None.

Employees

Employee

None.

InsurerBranches

InsurerBranch

None.

InsurerDistricts

InsurerDistrict

None.

Insurers

Insurer

None.

Statuses

Status

None.

custPermanentDrugs

Collection of custPermanentDrug

None.

DelAppointments

Collection of DelAppointment

None.

MedicalSheets

Collection of MedicalSheet

None.

MedicalSheetHistorys

Collection of MedicalSheetHistory

None.

Prescriptions

Collection of Prescription

None.

EligPayments

Collection of EligPayment

None.

TimeTable

Collection of TimeTable

None.

TransferAppointmentsLog

Collection of TransferAppointmentsLogLine

None.

WaitForAppointments

Collection of WaitForAppointment

None.

DocumentsStores

Collection of DocumentsStore

None.

FeaturesCust

Collection of FeaturesCust

None.

ServiceRecord

Collection of ServiceRecord

None.

CustContact

Collection of CustContact

None.

MedicalMeasurements

Collection of MedicalMeasurement

None.

WithPicture

boolean

None.

city_name

string

None.

FullName

string

None.

AgeYears

integer

None.

AgeMonth

integer

None.

FullAddress

string

None.

WithDrugs

boolean

None.

CustAccountNum

integer

None.