1. Signup (req/inv)
        
        user_master insert user pan email password link phone

        INSERT INTO `user_master` (PAN_NO, EMAIL, CONTACT, PASSWORD, LINK) VALUES (?,?,?,?,?)

        roles pan role ?status ?kyc_status com_eth_add(opt)

        INSERT INTO `roles` (PAN_NO, ROLE) VALUES (???)

2.  Signin

        roles: select role, status, kyc_status

        SELECT role, status, kyc_status FROM roles WHERE PAN_NO = ''

        user_master: select  username , password, pan,   

        SELECT name, password FROM user_master WHERE PAN_NO = ''

3. kyc update

        user_master name address profile_pic

        UPDATE user_master SET name = '', address = 'Canyon 123', profile_pic = '' WHERE PAN_NO = ''

        bank_tax_master: pan_no, bankname, acc_no, acc_name, ifsc, uin?, gstin?

        INSERT INTO bank_tax_master (PAN_NO, BANK_NAME, ACCOUNT_NO, ACCOUNT_NAME, IFSC, UIN, GSTIN) VALUES (??????)

        relationship: (if requestor) re_pan, com_pan, app_pan, status

        INSERT INTO relationship (REQ_PAN, COM_PAN, APP_PAN, STATUS) VALUES (?????)

        roles: status kyc_status com_eth_add(if comp/req)

        UPDATE roles SET status = 1, kyc_status = 1, (com_eth_add = ''?) WHERE PAN_NO = ''

4. 

5. change password

        user_master: PAN_NO, password

        SELECT PAN_NO, PASSWORD FROM user_master WHERE PAN_NO = '';

        user_master: update password

        UPDATE user_master SET PASSWORD = '' WHERE PAN_NO = '';




contractAdd? walletAdd? key?


requestor kyc insert procedure

req - name contact address -> update user_master

req - compan, name, address, contact, -> user_master

req - create com role

req - aapan name, address contact ect -> user_master

req - create app role

req - pan bankname accno accname ifsc uin gstin -> insert banking_master

req - reqpan compan app_pan status -> relationship

req - update kyc_status, company_eth_addr -> role


investor kyc insert procedure

inv - name contact address - > update user_master

inv pan bankname accno accname ifsc uin gstin - > banking_master

inv - update kyc_status -> role


change mail server
captcha
email verification status

hide validation marks
fullname 1 field
states and country