create table mas_common_receptionist(
id bigint NOT NULL AUTO_INCREMENT,
vendor_id bigint null,
vendor_type_id bigint null,
receptionist_name varchar(250) null,
profile_path text null,
civil_id_path text null,
nationality varchar(250) null,
contact_email varchar(250) null,
contact_number varchar(250) null,
referal_code varchar(100) null,
civil_id_number varchar(250) null,
bank_name varchar(250) null,
account_name varchar(250) null,
account_number varchar(250) null,
iban varchar(500) null,
address varchar(300) null,
beneficiary_contact_number varchar(50) null,
salesAdmin_approveSts varchar(45) not null,
active_status varchar(45) not null,
created_on datetime not null,
decline_reason varchar(250) null,
salesAdminApproved_on datetime not null,
superAdminApproved_on datetime null,
modified_on datetime null,
modified_by varchar(45) null
)





--- For the Send Link to Member Table

create table sent_link_receptionist(
id bigint NOT NULL AUTO_INCREMENT,
receptionist_id bigint null,
vendor_name varchar(250) null,
vendor_mobileNo varchar(100) null,
created_by varchar(45) null,
created_date datetime null,
salesman_id varchar(45) null,
vendorType_id varchar(45) null,
country_code varchar(45) null,
e_mail varchar(45) null,
modified_by varchar(45) null,
modified_date datetime null,

PRIMARY KEY (id)
)




------ For the Move Mas common vendor to mas vendor



create table mas_receptionist(
id bigint not null,
vendor_type_id bigint null,
reception_contact varchar(250) null,
reception_clinic_name varchar(250) null,
reception_mobile varchar(250) null,
reception_code varchar(45) null,
reception_contact_mobile varchar(250) null,
reception_email varchar(250) null,
nationality varchar(250) null,
reception_address varchar(250) null,
active_flag tinyint(1) null,
created_by bigint null,
created_on datetime null,
modified_by int(11) null,
modified_on datetime null,
reception_approve_status varchar(1) not null,
apprrove_reject_time datetime null,
reception_profile_path text null,
reception_civil_path text null,
bank_name varchar(100) null,
account_name varchar(100) null,
account_number varchar(100) null,
iban varchar(100) null,
is_active varchar(45) null
);


--- Mas Commision Table For Receptionist

create table mas_commission_receptionist(
id bigint NOT NULL AUTO_INCREMENT,
receptionist_id bigint null,
contract_terms varchar(400) null,
active_flag tinyint(1) null,
created_by varchar(128) null,
created_on datetime null,
modified_by varchar(128) null,
modified_on datetime  null,
vendor_type_id int(11) null,
contact_acceptance_status  varchar(45) not null,
start_date datetime null,
end_date datetime null,
contract_accept_date datetime null,
signature_image longtext null,
signed_contract_file longtext null,
terms_and_condition_file longtext null,
admin_upload_status varchar(45) null,

PRIMARY KEY (id)
)


--- For Receptionist Vendor Tables

create table other_vendor_type(
id bigint NOT NULL AUTO_INCREMENT,
vendor varchar(100) null,
active_flag tinyint(1) null,
created_by varchar(128) null,
created_on datetime null,
modified_by varchar(128) null,
modified_on datetime  null,
web_url varchar(45) null,
reg_url varchar(45) null,
vendor_payment_days int(11) null,
doc_receive_thirty_days int(10) null,
doc_receive_sixty_days int(10) null,
PRIMARY KEY (id)
)