--
--


SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: admin_auth_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.admin_auth_status_enum AS ENUM (
    'Enabled',
    'Disabled'
);


ALTER TYPE public.admin_auth_status_enum OWNER TO nbcbanq;

--
-- Name: admin_earn_crypto_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.admin_earn_crypto_type_enum AS ENUM (
    'Crypto',
    'Fiat'
);


ALTER TYPE public.admin_earn_crypto_type_enum OWNER TO nbcbanq;

--
-- Name: admin_earn_fees_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.admin_earn_fees_type_enum AS ENUM (
    'Percentage',
    'Fixed',
    'Range'
);


ALTER TYPE public.admin_earn_fees_type_enum OWNER TO nbcbanq;

--
-- Name: admin_is_deleted_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.admin_is_deleted_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.admin_is_deleted_enum OWNER TO nbcbanq;

--
-- Name: admin_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.admin_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.admin_status_enum OWNER TO nbcbanq;

--
-- Name: apikey_add_broker_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.apikey_add_broker_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.apikey_add_broker_enum OWNER TO nbcbanq;

--
-- Name: apikey_add_customer_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.apikey_add_customer_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.apikey_add_customer_enum OWNER TO nbcbanq;

--
-- Name: apikey_add_manager_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.apikey_add_manager_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.apikey_add_manager_enum OWNER TO nbcbanq;

--
-- Name: apikey_broker_list_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.apikey_broker_list_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.apikey_broker_list_enum OWNER TO nbcbanq;

--
-- Name: apikey_customer_list_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.apikey_customer_list_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.apikey_customer_list_enum OWNER TO nbcbanq;

--
-- Name: apikey_is_deleted_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.apikey_is_deleted_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.apikey_is_deleted_enum OWNER TO nbcbanq;

--
-- Name: apikey_manager_list_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.apikey_manager_list_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.apikey_manager_list_enum OWNER TO nbcbanq;

--
-- Name: authotp_auth_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.authotp_auth_status_enum AS ENUM (
    'Authentication not required',
    'Google Authentication',
    'SMS OTP Authentication'
);


ALTER TYPE public.authotp_auth_status_enum OWNER TO nbcbanq;

--
-- Name: authotp_auth_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.authotp_auth_type_enum AS ENUM (
    'Fiat Deposit',
    'Internal Transfer',
    'Withdrawal',
    'Crypto Deposit',
    'Cypto Transfer',
    'Crypto Withdrawal',
    'Buy',
    'Sell',
    'Swap',
    'Account Card',
    'Card Account',
    'Card Approved',
    'Issue',
    'Login',
    'Transaction',
    'Cardtopup',
    'Accounttopup'
);


ALTER TYPE public.authotp_auth_type_enum OWNER TO nbcbanq;

--
-- Name: autologout_autologout_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.autologout_autologout_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.autologout_autologout_enum OWNER TO nbcbanq;

--
-- Name: autologout_diffips_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.autologout_diffips_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.autologout_diffips_enum OWNER TO nbcbanq;

--
-- Name: autologout_usertype_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.autologout_usertype_enum AS ENUM (
    'User',
    'Broker',
    'Manager',
    'Admin'
);


ALTER TYPE public.autologout_usertype_enum OWNER TO nbcbanq;

--
-- Name: broker_address_is_default_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.broker_address_is_default_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.broker_address_is_default_enum OWNER TO nbcbanq;

--
-- Name: broker_admin_approve_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.broker_admin_approve_status_enum AS ENUM (
    'Pending',
    'Approved',
    'Declined'
);


ALTER TYPE public.broker_admin_approve_status_enum OWNER TO nbcbanq;

--
-- Name: broker_auth_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.broker_auth_status_enum AS ENUM (
    'Enabled',
    'Disabled'
);


ALTER TYPE public.broker_auth_status_enum OWNER TO nbcbanq;

--
-- Name: broker_earn_crypto_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.broker_earn_crypto_type_enum AS ENUM (
    'Crypto',
    'Fiat'
);


ALTER TYPE public.broker_earn_crypto_type_enum OWNER TO nbcbanq;

--
-- Name: broker_is_deleted_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.broker_is_deleted_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.broker_is_deleted_enum OWNER TO nbcbanq;

--
-- Name: broker_notification_notification_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.broker_notification_notification_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.broker_notification_notification_status_enum OWNER TO nbcbanq;

--
-- Name: broker_notification_notification_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.broker_notification_notification_type_enum AS ENUM (
    'Fiat_Deposit',
    'Crypto_Deposit',
    'Fiat_Withdraw',
    'Cypto_Trasaction',
    'Exchange',
    'Swap',
    'Crypto_Transfer',
    'Fiat_Transfer',
    'Login',
    'Transaction'
);


ALTER TYPE public.broker_notification_notification_type_enum OWNER TO nbcbanq;

--
-- Name: broker_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.broker_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.broker_status_enum OWNER TO nbcbanq;

--
-- Name: broker_withdraw_request_broker_withdraw_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.broker_withdraw_request_broker_withdraw_status_enum AS ENUM (
    'Completed',
    'Pending',
    'Failed'
);


ALTER TYPE public.broker_withdraw_request_broker_withdraw_status_enum OWNER TO nbcbanq;

--
-- Name: broker_withdraw_request_withdraw_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.broker_withdraw_request_withdraw_type_enum AS ENUM (
    'Automatic',
    'Manual'
);


ALTER TYPE public.broker_withdraw_request_withdraw_type_enum OWNER TO nbcbanq;

--
-- Name: card_information_cardinfo_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.card_information_cardinfo_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.card_information_cardinfo_status_enum OWNER TO nbcbanq;

--
-- Name: card_limit_limit_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.card_limit_limit_type_enum AS ENUM (
    'Daily',
    'Weekly',
    'Monthly',
    'Transaction'
);


ALTER TYPE public.card_limit_limit_type_enum OWNER TO nbcbanq;

--
-- Name: card_transaction_cardtra_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.card_transaction_cardtra_type_enum AS ENUM (
    'Debit',
    'Credit'
);


ALTER TYPE public.card_transaction_cardtra_type_enum OWNER TO nbcbanq;

--
-- Name: card_transaction_issue_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.card_transaction_issue_status_enum AS ENUM (
    'Pending',
    'Completed'
);


ALTER TYPE public.card_transaction_issue_status_enum OWNER TO nbcbanq;

--
-- Name: card_type_cardtype_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.card_type_cardtype_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.card_type_cardtype_status_enum OWNER TO nbcbanq;

--
-- Name: cardissue_transaction_issue_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.cardissue_transaction_issue_status_enum AS ENUM (
    'Pending',
    'Completed'
);


ALTER TYPE public.cardissue_transaction_issue_status_enum OWNER TO nbcbanq;

--
-- Name: company_company_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.company_company_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.company_company_status_enum OWNER TO nbcbanq;

--
-- Name: company_is_deleted_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.company_is_deleted_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.company_is_deleted_enum OWNER TO nbcbanq;

--
-- Name: contact_us_user_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.contact_us_user_type_enum AS ENUM (
    'User',
    'SuperAdmin',
    'Broker',
    'Manager'
);


ALTER TYPE public.contact_us_user_type_enum OWNER TO nbcbanq;

--
-- Name: country_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.country_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.country_status_enum OWNER TO nbcbanq;

--
-- Name: crypto_currancy_crypto_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.crypto_currancy_crypto_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.crypto_currancy_crypto_status_enum OWNER TO nbcbanq;

--
-- Name: customer_transaction_fees_fee_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.customer_transaction_fees_fee_type_enum AS ENUM (
    'Fixed',
    'Percentage',
    'Range'
);


ALTER TYPE public.customer_transaction_fees_fee_type_enum OWNER TO nbcbanq;

--
-- Name: customer_transaction_fees_transaction_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.customer_transaction_fees_transaction_type_enum AS ENUM (
    'Outgoing',
    'Internal',
    'Buy',
    'Sell',
    'Exchange',
    'Withdraw',
    'Transfer',
    'Swap',
    'Manager',
    'Broker'
);


ALTER TYPE public.customer_transaction_fees_transaction_type_enum OWNER TO nbcbanq;

--
-- Name: deliverypartner_dstatus_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.deliverypartner_dstatus_enum AS ENUM (
    'Disable',
    'Enable'
);


ALTER TYPE public.deliverypartner_dstatus_enum OWNER TO nbcbanq;

--
-- Name: document_type_document_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.document_type_document_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.document_type_document_status_enum OWNER TO nbcbanq;

--
-- Name: email_formats_transaction_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.email_formats_transaction_type_enum AS ENUM (
    'Outgoing',
    'Internal',
    'Buy',
    'Sell',
    'Exchange',
    'Withdraw',
    'Transfer',
    'Swap',
    'Manager',
    'Broker'
);


ALTER TYPE public.email_formats_transaction_type_enum OWNER TO nbcbanq;

--
-- Name: email_formats_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.email_formats_type_enum AS ENUM (
    'User',
    'SuperAdmin',
    'Broker',
    'Manager'
);


ALTER TYPE public.email_formats_type_enum OWNER TO nbcbanq;

--
-- Name: faq_category_role_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.faq_category_role_type_enum AS ENUM (
    'Manager',
    'Broker',
    'User'
);


ALTER TYPE public.faq_category_role_type_enum OWNER TO nbcbanq;

--
-- Name: faq_category_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.faq_category_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.faq_category_status_enum OWNER TO nbcbanq;

--
-- Name: faq_role_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.faq_role_type_enum AS ENUM (
    'Manager',
    'Broker',
    'User'
);


ALTER TYPE public.faq_role_type_enum OWNER TO nbcbanq;

--
-- Name: fees_fees_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.fees_fees_type_enum AS ENUM (
    'Outgoing',
    'Internal',
    'Buy',
    'Sell',
    'Exchange',
    'Withdraw',
    'Transfer',
    'Swap',
    'Manager',
    'Broker',
    'CardTopUp',
    'AccountTopUp',
    'IssueCard',
    'BusinessCard'
);


ALTER TYPE public.fees_fees_type_enum OWNER TO nbcbanq;

--
-- Name: fees_price_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.fees_price_type_enum AS ENUM (
    'Percentage',
    'Fixed'
);


ALTER TYPE public.fees_price_type_enum OWNER TO nbcbanq;

--
-- Name: fees_type_settings_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.fees_type_settings_type_enum AS ENUM (
    'Percentage',
    'Fixed'
);


ALTER TYPE public.fees_type_settings_type_enum OWNER TO nbcbanq;

--
-- Name: fiat_currancy_basecurrancy_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.fiat_currancy_basecurrancy_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.fiat_currancy_basecurrancy_enum OWNER TO nbcbanq;

--
-- Name: fiat_currancy_fiat_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.fiat_currancy_fiat_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.fiat_currancy_fiat_status_enum OWNER TO nbcbanq;

--
-- Name: limits_transaction_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.limits_transaction_type_enum AS ENUM (
    'Outgoing',
    'Internal',
    'Buy',
    'Sell',
    'Exchange',
    'Withdraw',
    'Transfer',
    'Swap'
);


ALTER TYPE public.limits_transaction_type_enum OWNER TO nbcbanq;

--
-- Name: login_logs_admin_admin_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.login_logs_admin_admin_type_enum AS ENUM (
    'Admin',
    'Manager',
    'Broker'
);


ALTER TYPE public.login_logs_admin_admin_type_enum OWNER TO nbcbanq;

--
-- Name: manager_address_is_default_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_address_is_default_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.manager_address_is_default_enum OWNER TO nbcbanq;

--
-- Name: manager_auth_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_auth_status_enum AS ENUM (
    'Enabled',
    'Disabled'
);


ALTER TYPE public.manager_auth_status_enum OWNER TO nbcbanq;

--
-- Name: manager_earn_crypto_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_earn_crypto_type_enum AS ENUM (
    'Crypto',
    'Fiat'
);


ALTER TYPE public.manager_earn_crypto_type_enum OWNER TO nbcbanq;

--
-- Name: manager_is_deleted_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_is_deleted_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.manager_is_deleted_enum OWNER TO nbcbanq;

--
-- Name: manager_notification_notification_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_notification_notification_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.manager_notification_notification_status_enum OWNER TO nbcbanq;

--
-- Name: manager_notification_notification_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_notification_notification_type_enum AS ENUM (
    'Fiat_Deposit',
    'Crypto_Deposit',
    'Fiat_Withdraw',
    'Cypto_Trasaction',
    'Exchange',
    'Swap',
    'Crypto_Transfer',
    'Fiat_Transfer',
    'Login',
    'Transaction'
);


ALTER TYPE public.manager_notification_notification_type_enum OWNER TO nbcbanq;

--
-- Name: manager_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.manager_status_enum OWNER TO nbcbanq;

--
-- Name: manager_withdraw_admin_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_withdraw_admin_type_enum AS ENUM (
    'Manager',
    'Broker'
);


ALTER TYPE public.manager_withdraw_admin_type_enum OWNER TO nbcbanq;

--
-- Name: manager_withdraw_req_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_withdraw_req_type_enum AS ENUM (
    'Automatic',
    'Manual'
);


ALTER TYPE public.manager_withdraw_req_type_enum OWNER TO nbcbanq;

--
-- Name: manager_withdraw_request_manager_withdraw_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_withdraw_request_manager_withdraw_status_enum AS ENUM (
    'Completed',
    'Pending',
    'Failed'
);


ALTER TYPE public.manager_withdraw_request_manager_withdraw_status_enum OWNER TO nbcbanq;

--
-- Name: manager_withdraw_request_withdraw_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_withdraw_request_withdraw_type_enum AS ENUM (
    'Automatic',
    'Manual'
);


ALTER TYPE public.manager_withdraw_request_withdraw_type_enum OWNER TO nbcbanq;

--
-- Name: manager_withdraw_withdraw_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.manager_withdraw_withdraw_status_enum AS ENUM (
    'Pending',
    'Approved',
    'Rejected'
);


ALTER TYPE public.manager_withdraw_withdraw_status_enum OWNER TO nbcbanq;

--
-- Name: notification_read_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.notification_read_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.notification_read_enum OWNER TO nbcbanq;

--
-- Name: notification_transaction_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.notification_transaction_type_enum AS ENUM (
    'Outgoing',
    'Internal',
    'Buy',
    'Sell',
    'Exchange',
    'Withdraw',
    'Transfer',
    'Swap',
    'Manager',
    'Broker',
    'Deposit'
);


ALTER TYPE public.notification_transaction_type_enum OWNER TO nbcbanq;

--
-- Name: notification_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.notification_type_enum AS ENUM (
    'User',
    'SuperAdmin',
    'Broker',
    'Manager'
);


ALTER TYPE public.notification_type_enum OWNER TO nbcbanq;

--
-- Name: otherreq_other_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.otherreq_other_status_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.otherreq_other_status_enum OWNER TO nbcbanq;

--
-- Name: sem_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.sem_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.sem_status_enum OWNER TO nbcbanq;

--
-- Name: seo_seo_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.seo_seo_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.seo_seo_status_enum OWNER TO nbcbanq;

--
-- Name: setting_setting_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.setting_setting_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.setting_setting_status_enum OWNER TO nbcbanq;

--
-- Name: state_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.state_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.state_status_enum OWNER TO nbcbanq;

--
-- Name: taskmanager_apistatus_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.taskmanager_apistatus_enum AS ENUM (
    'Pending',
    'Failed',
    'Completed'
);


ALTER TYPE public.taskmanager_apistatus_enum OWNER TO nbcbanq;

--
-- Name: taskmanager_cron_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.taskmanager_cron_status_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.taskmanager_cron_status_enum OWNER TO nbcbanq;

--
-- Name: taskmanager_roletype_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.taskmanager_roletype_enum AS ENUM (
    'Manager',
    'Broker',
    'User',
    'Admin'
);


ALTER TYPE public.taskmanager_roletype_enum OWNER TO nbcbanq;

--
-- Name: taskmanager_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.taskmanager_status_enum AS ENUM (
    'Pending',
    'Failed',
    'Completed'
);


ALTER TYPE public.taskmanager_status_enum OWNER TO nbcbanq;

--
-- Name: taskmanager_transaction_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.taskmanager_transaction_type_enum AS ENUM (
    'Outgoing',
    'Internal',
    'Buy',
    'Sell',
    'Exchange',
    'Withdraw',
    'Transfer',
    'Swap',
    'Cardtopup',
    'Accounttopup'
);


ALTER TYPE public.taskmanager_transaction_type_enum OWNER TO nbcbanq;

--
-- Name: taskmanager_user_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.taskmanager_user_type_enum AS ENUM (
    'Manager',
    'Broker',
    'User',
    'Admin'
);


ALTER TYPE public.taskmanager_user_type_enum OWNER TO nbcbanq;

--
-- Name: themesettings_defaultheme_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.themesettings_defaultheme_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.themesettings_defaultheme_enum OWNER TO nbcbanq;

--
-- Name: timezone_tstatus_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.timezone_tstatus_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.timezone_tstatus_enum OWNER TO nbcbanq;

--
-- Name: user_accounts_is_deleted_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_accounts_is_deleted_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_accounts_is_deleted_enum OWNER TO nbcbanq;

--
-- Name: user_accounts_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_accounts_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.user_accounts_status_enum OWNER TO nbcbanq;

--
-- Name: user_accounts_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_accounts_type_enum AS ENUM (
    'Domestic',
    'International'
);


ALTER TYPE public.user_accounts_type_enum OWNER TO nbcbanq;

--
-- Name: user_address_is_default_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_address_is_default_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_address_is_default_enum OWNER TO nbcbanq;

--
-- Name: user_auth_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_auth_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.user_auth_status_enum OWNER TO nbcbanq;

--
-- Name: user_cards_card_currancy_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_cards_card_currancy_enum AS ENUM (
    'EUR',
    'USD'
);


ALTER TYPE public.user_cards_card_currancy_enum OWNER TO nbcbanq;

--
-- Name: user_cards_contactless_enabled_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_cards_contactless_enabled_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_cards_contactless_enabled_enum OWNER TO nbcbanq;

--
-- Name: user_cards_internet_purchase_enabled_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_cards_internet_purchase_enabled_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_cards_internet_purchase_enabled_enum OWNER TO nbcbanq;

--
-- Name: user_cards_overall_limits_enabled_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_cards_overall_limits_enabled_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_cards_overall_limits_enabled_enum OWNER TO nbcbanq;

--
-- Name: user_cards_smsalert_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_cards_smsalert_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_cards_smsalert_enum OWNER TO nbcbanq;

--
-- Name: user_cards_usercard_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_cards_usercard_status_enum AS ENUM (
    'Pending',
    'Approved',
    'Active',
    'Blocked',
    'Rejected'
);


ALTER TYPE public.user_cards_usercard_status_enum OWNER TO nbcbanq;

--
-- Name: user_cards_withdraw_fromaccount_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_cards_withdraw_fromaccount_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_cards_withdraw_fromaccount_enum OWNER TO nbcbanq;

--
-- Name: user_cards_withdrawal_enabled_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_cards_withdrawal_enabled_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_cards_withdrawal_enabled_enum OWNER TO nbcbanq;

--
-- Name: user_crypto_wallets_wallet_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_crypto_wallets_wallet_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.user_crypto_wallets_wallet_status_enum OWNER TO nbcbanq;

--
-- Name: user_demouser_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_demouser_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_demouser_enum OWNER TO nbcbanq;

--
-- Name: user_deposit_fund_withdraw_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_deposit_fund_withdraw_status_enum AS ENUM (
    'Pending',
    'Completed',
    'Failed'
);


ALTER TYPE public.user_deposit_fund_withdraw_status_enum OWNER TO nbcbanq;

--
-- Name: user_deposit_transaction_deposit_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_deposit_transaction_deposit_status_enum AS ENUM (
    'Pending',
    'Completed',
    'Failed'
);


ALTER TYPE public.user_deposit_transaction_deposit_status_enum OWNER TO nbcbanq;

--
-- Name: user_emailnotification_notification_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_emailnotification_notification_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.user_emailnotification_notification_status_enum OWNER TO nbcbanq;

--
-- Name: user_emailnotification_notification_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_emailnotification_notification_type_enum AS ENUM (
    'Fiat Deposit',
    'Internal Transfer',
    'Withdrawal',
    'Crypto Deposit',
    'Cypto Transfer',
    'Crypto Withdrawal',
    'Buy',
    'Sell',
    'Swap',
    'Account Card',
    'Card Account',
    'Card Approved',
    'Issue',
    'Login',
    'Transaction'
);


ALTER TYPE public.user_emailnotification_notification_type_enum OWNER TO nbcbanq;

--
-- Name: user_exchange_transaction_exchange_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_exchange_transaction_exchange_type_enum AS ENUM (
    'Buy',
    'Sell'
);


ALTER TYPE public.user_exchange_transaction_exchange_type_enum OWNER TO nbcbanq;

--
-- Name: user_exchange_transaction_transfer_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_exchange_transaction_transfer_status_enum AS ENUM (
    'Pending',
    'Completed',
    'Failed'
);


ALTER TYPE public.user_exchange_transaction_transfer_status_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_balancesheet_transaction_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_balancesheet_transaction_type_enum AS ENUM (
    'Internal',
    'Outgoing',
    'Deposit',
    'Buy',
    'Sell',
    'CardTopUp',
    'Card Fund Withdrawal',
    'Card Issuance Fee'
);


ALTER TYPE public.user_fiat_balancesheet_transaction_type_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_balancesheet_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_balancesheet_type_enum AS ENUM (
    'Debit',
    'Credit'
);


ALTER TYPE public.user_fiat_balancesheet_type_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_depoist_transaction_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_depoist_transaction_status_enum AS ENUM (
    'Pending',
    'Completed',
    'Failed'
);


ALTER TYPE public.user_fiat_depoist_transaction_status_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_depoist_transaction_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_depoist_transaction_type_enum AS ENUM (
    'Debit',
    'Credit'
);


ALTER TYPE public.user_fiat_depoist_transaction_type_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_internal_transaction_currency_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_internal_transaction_currency_enum AS ENUM (
    'USD',
    'EUR'
);


ALTER TYPE public.user_fiat_internal_transaction_currency_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_internal_transaction_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_internal_transaction_status_enum AS ENUM (
    'Pending',
    'Completed',
    'Failed'
);


ALTER TYPE public.user_fiat_internal_transaction_status_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_withdraw_transaction_account_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_withdraw_transaction_account_type_enum AS ENUM (
    'Checking',
    'Saving'
);


ALTER TYPE public.user_fiat_withdraw_transaction_account_type_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_withdraw_transaction_bank_currency_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_withdraw_transaction_bank_currency_enum AS ENUM (
    'USD',
    'EUR'
);


ALTER TYPE public.user_fiat_withdraw_transaction_bank_currency_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_withdraw_transaction_check_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_withdraw_transaction_check_type_enum AS ENUM (
    'Personal',
    'Business'
);


ALTER TYPE public.user_fiat_withdraw_transaction_check_type_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_withdraw_transaction_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_withdraw_transaction_status_enum AS ENUM (
    'Pending',
    'Completed',
    'Failed'
);


ALTER TYPE public.user_fiat_withdraw_transaction_status_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_withdraw_transaction_temp_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_withdraw_transaction_temp_type_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_fiat_withdraw_transaction_temp_type_enum OWNER TO nbcbanq;

--
-- Name: user_fiat_withdraw_transaction_transfer_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_fiat_withdraw_transaction_transfer_type_enum AS ENUM (
    'Ach',
    'Wire'
);


ALTER TYPE public.user_fiat_withdraw_transaction_transfer_type_enum OWNER TO nbcbanq;

--
-- Name: user_is_deleted_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_is_deleted_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_is_deleted_enum OWNER TO nbcbanq;

--
-- Name: user_kyc_address_kyc_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_kyc_address_kyc_status_enum AS ENUM (
    'Pending',
    'Approved',
    'Rejected'
);


ALTER TYPE public.user_kyc_address_kyc_status_enum OWNER TO nbcbanq;

--
-- Name: user_kyc_aml_kyc_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_kyc_aml_kyc_status_enum AS ENUM (
    'Pending',
    'Approved',
    'Rejected'
);


ALTER TYPE public.user_kyc_aml_kyc_status_enum OWNER TO nbcbanq;

--
-- Name: user_kyc_cip_kyc_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_kyc_cip_kyc_status_enum AS ENUM (
    'Pending',
    'Approved',
    'Rejected'
);


ALTER TYPE public.user_kyc_cip_kyc_status_enum OWNER TO nbcbanq;

--
-- Name: user_kyc_iddoc_kyc_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_kyc_iddoc_kyc_status_enum AS ENUM (
    'Pending',
    'Approved',
    'Rejected'
);


ALTER TYPE public.user_kyc_iddoc_kyc_status_enum OWNER TO nbcbanq;

--
-- Name: user_kyc_kyc_api_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_kyc_kyc_api_status_enum AS ENUM (
    'Pending',
    'Approved',
    'Rejected'
);


ALTER TYPE public.user_kyc_kyc_api_status_enum OWNER TO nbcbanq;

--
-- Name: user_kyc_kyc_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_kyc_kyc_status_enum AS ENUM (
    'Pending',
    'Approved',
    'Rejected'
);


ALTER TYPE public.user_kyc_kyc_status_enum OWNER TO nbcbanq;

--
-- Name: user_notification_notification_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_notification_notification_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.user_notification_notification_status_enum OWNER TO nbcbanq;

--
-- Name: user_notification_notification_type_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_notification_notification_type_enum AS ENUM (
    'Fiat Deposit',
    'Internal Transfer',
    'Withdrawal',
    'Crypto Deposit',
    'Cypto Transfer',
    'Crypto Withdrawal',
    'Buy',
    'Sell',
    'Swap',
    'Account Card',
    'Card Account',
    'Card Approved',
    'Issue',
    'Login',
    'Transaction'
);


ALTER TYPE public.user_notification_notification_type_enum OWNER TO nbcbanq;

--
-- Name: user_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_status_enum AS ENUM (
    'Enable',
    'Disable'
);


ALTER TYPE public.user_status_enum OWNER TO nbcbanq;

--
-- Name: user_swap_transaction_swap_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_swap_transaction_swap_status_enum AS ENUM (
    'Pending',
    'Completed',
    'Failed'
);


ALTER TYPE public.user_swap_transaction_swap_status_enum OWNER TO nbcbanq;

--
-- Name: user_transfer_transfer_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_transfer_transfer_status_enum AS ENUM (
    'Pending',
    'Completed',
    'Failed'
);


ALTER TYPE public.user_transfer_transfer_status_enum OWNER TO nbcbanq;

--
-- Name: user_verification_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_verification_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.user_verification_enum OWNER TO nbcbanq;

--
-- Name: user_withdraw_transaction_withdraw_status_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.user_withdraw_transaction_withdraw_status_enum AS ENUM (
    'Pending',
    'Completed',
    'Failed'
);


ALTER TYPE public.user_withdraw_transaction_withdraw_status_enum OWNER TO nbcbanq;

--
-- Name: usergroups_group_default_enum; Type: TYPE; Schema: public; Owner: nbcbanq
--

CREATE TYPE public.usergroups_group_default_enum AS ENUM (
    'Yes',
    'No'
);


ALTER TYPE public.usergroups_group_default_enum OWNER TO nbcbanq;



--
-- Name: admin; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.admin (
    admin_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    first_name character varying(255),
    last_name character varying(255),
    email_id character varying(255),
    temp_secret jsonb,
    image character varying(255),
    admin_slug character varying(255),
    contact_no character varying(255),
    is_deleted public.admin_is_deleted_enum DEFAULT 'No'::public.admin_is_deleted_enum NOT NULL,
    status public.admin_status_enum DEFAULT 'Enable'::public.admin_status_enum NOT NULL,
    auth_status public.admin_auth_status_enum DEFAULT 'Disabled'::public.admin_auth_status_enum NOT NULL,
    google_auth_code character varying(512),
    password character varying(255),
    total_reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_date timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_date timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.admin OWNER TO nbcbanq;

--
-- Name: admin_admin_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.admin_admin_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_admin_id_pk_seq OWNER TO nbcbanq;

--
-- Name: admin_admin_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.admin_admin_id_pk_seq OWNED BY public.admin.admin_id_pk;


--
-- Name: admin_earn; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.admin_earn (
    admin_earn_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    admin_id bigint DEFAULT '0'::bigint NOT NULL,
    transaction_id bigint DEFAULT '0'::bigint NOT NULL,
    customer_tra_fee_id bigint DEFAULT '0'::bigint NOT NULL,
    total_reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fees_type public.admin_earn_fees_type_enum DEFAULT 'Percentage'::public.admin_earn_fees_type_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    crypto_type public.admin_earn_crypto_type_enum DEFAULT 'Crypto'::public.admin_earn_crypto_type_enum NOT NULL,
    crypto_id bigint DEFAULT '0'::bigint NOT NULL,
    coin_code character varying(255)
);


ALTER TABLE public.admin_earn OWNER TO nbcbanq;

--
-- Name: admin_earn_admin_earn_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.admin_earn_admin_earn_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_earn_admin_earn_id_seq OWNER TO nbcbanq;

--
-- Name: admin_earn_admin_earn_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.admin_earn_admin_earn_id_seq OWNED BY public.admin_earn.admin_earn_id;


--
-- Name: admin_links; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.admin_links (
    link_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    linkurl text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.admin_links OWNER TO nbcbanq;

--
-- Name: admin_links_link_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.admin_links_link_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admin_links_link_id_seq OWNER TO nbcbanq;

--
-- Name: admin_links_link_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.admin_links_link_id_seq OWNED BY public.admin_links.link_id;


--
-- Name: admincrypto_reward; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.admincrypto_reward (
    admin_reward_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    admin_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    crypto_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    coin_code character varying(255),
    reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.admincrypto_reward OWNER TO nbcbanq;

--
-- Name: admincrypto_reward_admin_reward_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.admincrypto_reward_admin_reward_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.admincrypto_reward_admin_reward_id_seq OWNER TO nbcbanq;

--
-- Name: admincrypto_reward_admin_reward_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.admincrypto_reward_admin_reward_id_seq OWNED BY public.admincrypto_reward.admin_reward_id;


--
-- Name: adminfiat_reward; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.adminfiat_reward (
    admin_fiatreward_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    admin_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    fiat_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    coin_code character varying(255),
    reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.adminfiat_reward OWNER TO nbcbanq;

--
-- Name: adminfiat_reward_admin_fiatreward_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.adminfiat_reward_admin_fiatreward_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.adminfiat_reward_admin_fiatreward_id_seq OWNER TO nbcbanq;

--
-- Name: adminfiat_reward_admin_fiatreward_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.adminfiat_reward_admin_fiatreward_id_seq OWNED BY public.adminfiat_reward.admin_fiatreward_id;


--
-- Name: apikey; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.apikey (
    api_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    api_key character varying(255),
    secret_key character varying(255),
    expire_date date DEFAULT now(),
    manager_list public.apikey_manager_list_enum DEFAULT 'No'::public.apikey_manager_list_enum NOT NULL,
    broker_list public.apikey_broker_list_enum DEFAULT 'No'::public.apikey_broker_list_enum NOT NULL,
    customer_list public.apikey_customer_list_enum DEFAULT 'No'::public.apikey_customer_list_enum NOT NULL,
    add_manager public.apikey_add_manager_enum DEFAULT 'No'::public.apikey_add_manager_enum NOT NULL,
    add_broker public.apikey_add_broker_enum DEFAULT 'No'::public.apikey_add_broker_enum NOT NULL,
    add_customer public.apikey_add_customer_enum DEFAULT 'No'::public.apikey_add_customer_enum NOT NULL,
    is_deleted public.apikey_is_deleted_enum DEFAULT 'No'::public.apikey_is_deleted_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.apikey OWNER TO nbcbanq;

--
-- Name: apikey_api_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.apikey_api_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.apikey_api_id_seq OWNER TO nbcbanq;

--
-- Name: apikey_api_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.apikey_api_id_seq OWNED BY public.apikey.api_id;


--
-- Name: authotp; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.authotp (
    authotp_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    auth_title text,
    auth_type public.authotp_auth_type_enum DEFAULT 'Login'::public.authotp_auth_type_enum NOT NULL,
    auth_status public.authotp_auth_status_enum DEFAULT 'Authentication not required'::public.authotp_auth_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.authotp OWNER TO nbcbanq;

--
-- Name: authotp_authotp_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.authotp_authotp_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.authotp_authotp_id_seq OWNER TO nbcbanq;

--
-- Name: authotp_authotp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.authotp_authotp_id_seq OWNED BY public.authotp.authotp_id;


--
-- Name: autologout; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.autologout (
    autologout_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    autologouttime text,
    attempts text,
    persecond text,
    message text,
    padding text,
    aftermessage text,
    usertype public.autologout_usertype_enum DEFAULT 'User'::public.autologout_usertype_enum NOT NULL,
    autologout public.autologout_autologout_enum DEFAULT 'Yes'::public.autologout_autologout_enum NOT NULL,
    diffips public.autologout_diffips_enum DEFAULT 'No'::public.autologout_diffips_enum NOT NULL,
    unblock text
);


ALTER TABLE public.autologout OWNER TO nbcbanq;

--
-- Name: autologout_autologout_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.autologout_autologout_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.autologout_autologout_id_seq OWNER TO nbcbanq;

--
-- Name: autologout_autologout_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.autologout_autologout_id_seq OWNED BY public.autologout.autologout_id;


--
-- Name: banks; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.banks (
    bank_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    fiat_currancy_fk bigint DEFAULT '0'::bigint NOT NULL,
    account_number character varying(255),
    routing_number character varying(255),
    swift_code character varying(255),
    bank_name character varying(255),
    address character varying(255),
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.banks OWNER TO nbcbanq;

--
-- Name: banks_bank_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.banks_bank_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.banks_bank_id_seq OWNER TO nbcbanq;

--
-- Name: banks_bank_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.banks_bank_id_seq OWNED BY public.banks.bank_id;


--
-- Name: blockadmin_ip; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.blockadmin_ip (
    adminipid bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    ipaddress text,
    browser text,
    os text,
    country text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.blockadmin_ip OWNER TO nbcbanq;

--
-- Name: blockadmin_ip_adminipid_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.blockadmin_ip_adminipid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.blockadmin_ip_adminipid_seq OWNER TO nbcbanq;

--
-- Name: blockadmin_ip_adminipid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.blockadmin_ip_adminipid_seq OWNED BY public.blockadmin_ip.adminipid;


--
-- Name: blockedip; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.blockedip (
    ipid bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    ipaddress text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    counter bigint DEFAULT '0'::bigint NOT NULL,
    browser text,
    os text,
    country text
);


ALTER TABLE public.blockedip OWNER TO nbcbanq;

--
-- Name: blockedip_ipid_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.blockedip_ipid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.blockedip_ipid_seq OWNER TO nbcbanq;

--
-- Name: blockedip_ipid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.blockedip_ipid_seq OWNED BY public.blockedip.ipid;


--
-- Name: blockedipbroker; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.blockedipbroker (
    ipid bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    counter bigint DEFAULT '0'::bigint NOT NULL,
    ipaddress text,
    browser text,
    os text,
    country text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.blockedipbroker OWNER TO nbcbanq;

--
-- Name: blockedipbroker_ipid_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.blockedipbroker_ipid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.blockedipbroker_ipid_seq OWNER TO nbcbanq;

--
-- Name: blockedipbroker_ipid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.blockedipbroker_ipid_seq OWNED BY public.blockedipbroker.ipid;


--
-- Name: blockedipmanager; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.blockedipmanager (
    ipid bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    counter bigint DEFAULT '0'::bigint NOT NULL,
    ipaddress text,
    browser text,
    os text,
    country text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.blockedipmanager OWNER TO nbcbanq;

--
-- Name: blockedipmanager_ipid_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.blockedipmanager_ipid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.blockedipmanager_ipid_seq OWNER TO nbcbanq;

--
-- Name: blockedipmanager_ipid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.blockedipmanager_ipid_seq OWNED BY public.blockedipmanager.ipid;


--
-- Name: broker; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.broker (
    broker_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    country_id bigint DEFAULT '0'::bigint NOT NULL,
    manager_id bigint DEFAULT '0'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    lang_id bigint DEFAULT '1'::bigint NOT NULL,
    first_name character varying(255),
    last_name character varying(255),
    email_id character varying(255),
    total_reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    phone_number character varying(255),
    password character varying(255),
    status public.broker_status_enum DEFAULT 'Enable'::public.broker_status_enum NOT NULL,
    auth_status public.broker_auth_status_enum DEFAULT 'Disabled'::public.broker_auth_status_enum NOT NULL,
    google_auth_code character varying(512),
    temp_secret jsonb,
    is_deleted public.broker_is_deleted_enum DEFAULT 'No'::public.broker_is_deleted_enum NOT NULL,
    profile_photo character varying(255),
    email_ref_code character varying(255),
    timezone character varying(255),
    country_code character varying(255),
    ref_code character varying(255),
    admin_approve_status public.broker_admin_approve_status_enum DEFAULT 'Pending'::public.broker_admin_approve_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_date timestamp without time zone DEFAULT now(),
    modified_ip character varying(255),
    sessionip character varying(255)
);


ALTER TABLE public.broker OWNER TO nbcbanq;

--
-- Name: broker_address; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.broker_address (
    broker_address_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    broker_id bigint DEFAULT '0'::bigint NOT NULL,
    country_id bigint DEFAULT '0'::bigint NOT NULL,
    state_id bigint DEFAULT '0'::bigint NOT NULL,
    address_line1 character varying(512),
    address_line2 character varying(512),
    city character varying(255),
    zipcode character varying(255),
    is_default public.broker_address_is_default_enum DEFAULT 'No'::public.broker_address_is_default_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.broker_address OWNER TO nbcbanq;

--
-- Name: broker_address_broker_address_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.broker_address_broker_address_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.broker_address_broker_address_id_pk_seq OWNER TO nbcbanq;

--
-- Name: broker_address_broker_address_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.broker_address_broker_address_id_pk_seq OWNED BY public.broker_address.broker_address_id_pk;


--
-- Name: broker_broker_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.broker_broker_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.broker_broker_id_seq OWNER TO nbcbanq;

--
-- Name: broker_broker_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.broker_broker_id_seq OWNED BY public.broker.broker_id;


--
-- Name: broker_contact; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.broker_contact (
    contact_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    item_id bigint DEFAULT '0'::bigint NOT NULL,
    broker_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    name text,
    email text,
    phone text,
    address text,
    city text,
    state text,
    zip text,
    country text,
    "companyName" text,
    fulljson text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.broker_contact OWNER TO nbcbanq;

--
-- Name: broker_contact_contact_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.broker_contact_contact_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.broker_contact_contact_id_seq OWNER TO nbcbanq;

--
-- Name: broker_contact_contact_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.broker_contact_contact_id_seq OWNED BY public.broker_contact.contact_id;


--
-- Name: broker_contact_order; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.broker_contact_order (
    contact_order_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    contact_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    item_id bigint DEFAULT '0'::bigint NOT NULL,
    broker_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    "memberId" bigint DEFAULT '0'::bigint NOT NULL,
    token text,
    "invoiceNo" text,
    "customerName" text,
    "customerEmail" text,
    "billingAddress" text,
    "shippingAddress" text,
    "shippingRequired" text,
    weight text,
    "weightUnit" text,
    "subTotal" text,
    total text,
    "discountCode" text,
    "discountType" text,
    "transactionId" text,
    "shippingAmount" text,
    "shippingName" text,
    paid text,
    "paymentMethod" text,
    status text,
    "discountAmount" text,
    taxes text,
    items text,
    currency text,
    fulljson text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.broker_contact_order OWNER TO nbcbanq;

--
-- Name: broker_contact_order_contact_order_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.broker_contact_order_contact_order_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.broker_contact_order_contact_order_id_seq OWNER TO nbcbanq;

--
-- Name: broker_contact_order_contact_order_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.broker_contact_order_contact_order_id_seq OWNED BY public.broker_contact_order.contact_order_id;


--
-- Name: broker_earn; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.broker_earn (
    broker_earn_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    broker_id bigint DEFAULT '0'::bigint NOT NULL,
    transaction_id bigint DEFAULT '0'::bigint NOT NULL,
    customer_tra_fee_id bigint DEFAULT '0'::bigint NOT NULL,
    total_reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fees_percentage numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    crypto_type public.broker_earn_crypto_type_enum DEFAULT 'Crypto'::public.broker_earn_crypto_type_enum NOT NULL,
    crypto_id bigint DEFAULT '0'::bigint NOT NULL,
    coin_code character varying(255)
);


ALTER TABLE public.broker_earn OWNER TO nbcbanq;

--
-- Name: broker_earn_broker_earn_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.broker_earn_broker_earn_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.broker_earn_broker_earn_id_seq OWNER TO nbcbanq;

--
-- Name: broker_earn_broker_earn_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.broker_earn_broker_earn_id_seq OWNED BY public.broker_earn.broker_earn_id;


--
-- Name: broker_feedback; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.broker_feedback (
    feedback_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    feedback_broker_id_fk bigint,
    rating character varying(255),
    comment text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.broker_feedback OWNER TO nbcbanq;

--
-- Name: broker_feedback_feedback_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.broker_feedback_feedback_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.broker_feedback_feedback_id_seq OWNER TO nbcbanq;

--
-- Name: broker_feedback_feedback_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.broker_feedback_feedback_id_seq OWNED BY public.broker_feedback.feedback_id;


--
-- Name: broker_notification; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.broker_notification (
    notification_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    broker_id bigint DEFAULT '0'::bigint NOT NULL,
    notification_title text,
    notification_type public.broker_notification_notification_type_enum DEFAULT 'Login'::public.broker_notification_notification_type_enum NOT NULL,
    notification_desc text,
    notification_status public.broker_notification_notification_status_enum DEFAULT 'Enable'::public.broker_notification_notification_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.broker_notification OWNER TO nbcbanq;

--
-- Name: broker_notification_notification_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.broker_notification_notification_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.broker_notification_notification_id_seq OWNER TO nbcbanq;

--
-- Name: broker_notification_notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.broker_notification_notification_id_seq OWNED BY public.broker_notification.notification_id;


--
-- Name: broker_withdraw_request; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.broker_withdraw_request (
    broker_withdraw_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    broker_id bigint DEFAULT '0'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id bigint DEFAULT '0'::bigint NOT NULL,
    withdraw_type public.broker_withdraw_request_withdraw_type_enum DEFAULT 'Automatic'::public.broker_withdraw_request_withdraw_type_enum NOT NULL,
    withdraw_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    broker_withdraw_status public.broker_withdraw_request_broker_withdraw_status_enum DEFAULT 'Pending'::public.broker_withdraw_request_broker_withdraw_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    currancy_type character varying(255),
    broker_reward_id bigint DEFAULT '0'::bigint NOT NULL
);


ALTER TABLE public.broker_withdraw_request OWNER TO nbcbanq;

--
-- Name: broker_withdraw_request_broker_withdraw_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.broker_withdraw_request_broker_withdraw_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.broker_withdraw_request_broker_withdraw_id_seq OWNER TO nbcbanq;

--
-- Name: broker_withdraw_request_broker_withdraw_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.broker_withdraw_request_broker_withdraw_id_seq OWNED BY public.broker_withdraw_request.broker_withdraw_id;


--
-- Name: brokercrypto_reward; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.brokercrypto_reward (
    broker_reward_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    admin_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    crypto_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    coin_code character varying(255),
    reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.brokercrypto_reward OWNER TO nbcbanq;

--
-- Name: brokercrypto_reward_broker_reward_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.brokercrypto_reward_broker_reward_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.brokercrypto_reward_broker_reward_id_seq OWNER TO nbcbanq;

--
-- Name: brokercrypto_reward_broker_reward_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.brokercrypto_reward_broker_reward_id_seq OWNED BY public.brokercrypto_reward.broker_reward_id;


--
-- Name: brokerfiat_reward; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.brokerfiat_reward (
    broker_fiatreward_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    admin_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    fiat_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    coin_code character varying(255),
    reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.brokerfiat_reward OWNER TO nbcbanq;

--
-- Name: brokerfiat_reward_broker_fiatreward_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.brokerfiat_reward_broker_fiatreward_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.brokerfiat_reward_broker_fiatreward_id_seq OWNER TO nbcbanq;

--
-- Name: brokerfiat_reward_broker_fiatreward_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.brokerfiat_reward_broker_fiatreward_id_seq OWNED BY public.brokerfiat_reward.broker_fiatreward_id;


--
-- Name: card_information; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.card_information (
    cardinfo_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    card_type_id bigint DEFAULT '0'::bigint NOT NULL,
    card_name text,
    card_desc text,
    joining_fees_usd numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    annual_fees_usd numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    joining_fees_eur numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    annual_fees_eur numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    cardinfo_status public.card_information_cardinfo_status_enum DEFAULT 'Enable'::public.card_information_cardinfo_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now() NOT NULL,
    modified_ip character varying(255)
);


ALTER TABLE public.card_information OWNER TO nbcbanq;

--
-- Name: card_information_cardinfo_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.card_information_cardinfo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.card_information_cardinfo_id_seq OWNER TO nbcbanq;

--
-- Name: card_information_cardinfo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.card_information_cardinfo_id_seq OWNED BY public.card_information.cardinfo_id;


--
-- Name: card_limit; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.card_limit (
    cardlimit_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    card_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    purchase numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    withdraw numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    internet numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    contactless numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    limit_type public.card_limit_limit_type_enum DEFAULT 'Daily'::public.card_limit_limit_type_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.card_limit OWNER TO nbcbanq;

--
-- Name: card_limit_cardlimit_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.card_limit_cardlimit_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.card_limit_cardlimit_id_seq OWNER TO nbcbanq;

--
-- Name: card_limit_cardlimit_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.card_limit_cardlimit_id_seq OWNED BY public.card_limit.cardlimit_id;


--
-- Name: card_transaction; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.card_transaction (
    cardtra_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    card_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    acc_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    cardtra_type public.card_transaction_cardtra_type_enum DEFAULT 'Credit'::public.card_transaction_cardtra_type_enum NOT NULL,
    issue_status public.card_transaction_issue_status_enum DEFAULT 'Pending'::public.card_transaction_issue_status_enum NOT NULL,
    message text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    hash text,
    broker_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    final_final character varying(255) DEFAULT '0'::character varying NOT NULL,
    tenpercnt character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeesper character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeestype character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    broker_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    fee_flag character varying(255) DEFAULT '0'::character varying NOT NULL
);


ALTER TABLE public.card_transaction OWNER TO nbcbanq;

--
-- Name: card_transaction_cardtra_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.card_transaction_cardtra_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.card_transaction_cardtra_id_seq OWNER TO nbcbanq;

--
-- Name: card_transaction_cardtra_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.card_transaction_cardtra_id_seq OWNED BY public.card_transaction.cardtra_id;


--
-- Name: card_type; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.card_type (
    cardtype_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    cardtype_name character varying(255),
    cardtype_status public.card_type_cardtype_status_enum DEFAULT 'Enable'::public.card_type_cardtype_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now() NOT NULL,
    modified_ip character varying(255)
);


ALTER TABLE public.card_type OWNER TO nbcbanq;

--
-- Name: card_type_cardtype_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.card_type_cardtype_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.card_type_cardtype_id_seq OWNER TO nbcbanq;

--
-- Name: card_type_cardtype_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.card_type_cardtype_id_seq OWNED BY public.card_type.cardtype_id;


--
-- Name: cardissue_transaction; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.cardissue_transaction (
    cardissue_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    card_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    acc_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    card_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    admin_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    issue_status public.cardissue_transaction_issue_status_enum DEFAULT 'Pending'::public.cardissue_transaction_issue_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    hash text
);


ALTER TABLE public.cardissue_transaction OWNER TO nbcbanq;

--
-- Name: cardissue_transaction_cardissue_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.cardissue_transaction_cardissue_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.cardissue_transaction_cardissue_id_seq OWNER TO nbcbanq;

--
-- Name: cardissue_transaction_cardissue_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.cardissue_transaction_cardissue_id_seq OWNED BY public.cardissue_transaction.cardissue_id;


--
-- Name: company; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.company (
    company_id bigint NOT NULL,
    company_name character varying(255),
    company_status public.company_company_status_enum DEFAULT 'Enable'::public.company_company_status_enum NOT NULL,
    is_deleted public.company_is_deleted_enum DEFAULT 'No'::public.company_is_deleted_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.company OWNER TO nbcbanq;

--
-- Name: company_company_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.company_company_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.company_company_id_seq OWNER TO nbcbanq;

--
-- Name: company_company_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.company_company_id_seq OWNED BY public.company.company_id;


--
-- Name: contact_us; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.contact_us (
    contact_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    fullname character varying(255),
    emailid character varying(255),
    subject character varying(255),
    details text,
    user_type public.contact_us_user_type_enum DEFAULT 'User'::public.contact_us_user_type_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.contact_us OWNER TO nbcbanq;

--
-- Name: contact_us_contact_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.contact_us_contact_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.contact_us_contact_id_seq OWNER TO nbcbanq;

--
-- Name: contact_us_contact_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.contact_us_contact_id_seq OWNED BY public.contact_us.contact_id;


--
-- Name: country; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.country (
    country_id_pk bigint NOT NULL,
    phonecode character varying(150),
    sortname character varying(255),
    name character varying(150),
    status public.country_status_enum DEFAULT 'Enable'::public.country_status_enum NOT NULL,
    country_flag text,
    company_id bigint DEFAULT '1'::bigint NOT NULL
);


ALTER TABLE public.country OWNER TO nbcbanq;

--
-- Name: country_country_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.country_country_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.country_country_id_pk_seq OWNER TO nbcbanq;

--
-- Name: country_country_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.country_country_id_pk_seq OWNED BY public.country.country_id_pk;


--
-- Name: crypto_currancy; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.crypto_currancy (
    crypto_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    coin_code character varying(255),
    coin_fullname character varying(255),
    coin_image character varying(255),
    crypto_status public.crypto_currancy_crypto_status_enum DEFAULT 'Enable'::public.crypto_currancy_crypto_status_enum NOT NULL,
    depositnote text,
    withdrawnote text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now() NOT NULL,
    modified_ip character varying(255),
    exchangerate numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    marginrate numeric(16,2) DEFAULT '0'::numeric NOT NULL
);


ALTER TABLE public.crypto_currancy OWNER TO nbcbanq;

--
-- Name: crypto_currancy_crypto_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.crypto_currancy_crypto_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.crypto_currancy_crypto_id_seq OWNER TO nbcbanq;

--
-- Name: crypto_currancy_crypto_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.crypto_currancy_crypto_id_seq OWNED BY public.crypto_currancy.crypto_id;


--
-- Name: crypto_rates; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.crypto_rates (
    crypto_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    coincode text,
    coinname text,
    current_price text,
    usd_price text,
    euro_price text
);


ALTER TABLE public.crypto_rates OWNER TO nbcbanq;

--
-- Name: crypto_rates_crypto_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.crypto_rates_crypto_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.crypto_rates_crypto_id_seq OWNER TO nbcbanq;

--
-- Name: crypto_rates_crypto_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.crypto_rates_crypto_id_seq OWNED BY public.crypto_rates.crypto_id;


--
-- Name: cryptopair_rates; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.cryptopair_rates (
    pair_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    coincode text,
    coinname text,
    pairname text,
    current_price text,
    exchangeprice text,
    marginrate numeric(16,2) DEFAULT '0'::numeric NOT NULL
);


ALTER TABLE public.cryptopair_rates OWNER TO nbcbanq;

--
-- Name: cryptopair_rates_pair_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.cryptopair_rates_pair_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.cryptopair_rates_pair_id_seq OWNER TO nbcbanq;

--
-- Name: cryptopair_rates_pair_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.cryptopair_rates_pair_id_seq OWNED BY public.cryptopair_rates.pair_id;


--
-- Name: customer_transaction_fees; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.customer_transaction_fees (
    customer_tra_fee_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    transaction_id bigint DEFAULT '0'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    broker_id bigint DEFAULT '0'::bigint NOT NULL,
    manager_id bigint DEFAULT '0'::bigint NOT NULL,
    transaction_table_name character varying(255),
    transaction_type public.customer_transaction_fees_transaction_type_enum DEFAULT 'Broker'::public.customer_transaction_fees_transaction_type_enum NOT NULL,
    amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fees_percent numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fees_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    total_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fee_type public.customer_transaction_fees_fee_type_enum DEFAULT 'Fixed'::public.customer_transaction_fees_fee_type_enum NOT NULL,
    from_cur character varying(255),
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.customer_transaction_fees OWNER TO nbcbanq;

--
-- Name: customer_transaction_fees_customer_tra_fee_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.customer_transaction_fees_customer_tra_fee_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.customer_transaction_fees_customer_tra_fee_id_seq OWNER TO nbcbanq;

--
-- Name: customer_transaction_fees_customer_tra_fee_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.customer_transaction_fees_customer_tra_fee_id_seq OWNED BY public.customer_transaction_fees.customer_tra_fee_id;


--
-- Name: deliverypartner; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.deliverypartner (
    deliveryid bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    dname text,
    workingdays text,
    usdprice numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    europrice numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    dstatus public.deliverypartner_dstatus_enum DEFAULT 'Disable'::public.deliverypartner_dstatus_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.deliverypartner OWNER TO nbcbanq;

--
-- Name: deliverypartner_deliveryid_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.deliverypartner_deliveryid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.deliverypartner_deliveryid_seq OWNER TO nbcbanq;

--
-- Name: deliverypartner_deliveryid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.deliverypartner_deliveryid_seq OWNED BY public.deliverypartner.deliveryid;


--
-- Name: deposit_address; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.deposit_address (
    deposit_address_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    crypto_wallet_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id bigint DEFAULT '0'::bigint NOT NULL,
    wallet_address character varying(255),
    coin_code character varying(255),
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    status character varying(255)
);


ALTER TABLE public.deposit_address OWNER TO nbcbanq;

--
-- Name: deposit_address_deposit_address_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.deposit_address_deposit_address_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.deposit_address_deposit_address_id_seq OWNER TO nbcbanq;

--
-- Name: deposit_address_deposit_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.deposit_address_deposit_address_id_seq OWNED BY public.deposit_address.deposit_address_id;


--
-- Name: document_type; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.document_type (
    document_type_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    document_name character varying(255),
    document_status public.document_type_document_status_enum DEFAULT 'Enable'::public.document_type_document_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now() NOT NULL,
    modified_ip character varying(255)
);


ALTER TABLE public.document_type OWNER TO nbcbanq;

--
-- Name: document_type_document_type_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.document_type_document_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.document_type_document_type_id_seq OWNER TO nbcbanq;

--
-- Name: document_type_document_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.document_type_document_type_id_seq OWNED BY public.document_type.document_type_id;


--
-- Name: email_formats; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.email_formats (
    email_format_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    type public.email_formats_type_enum DEFAULT 'User'::public.email_formats_type_enum NOT NULL,
    title character varying(255),
    variables text,
    subject character varying(255),
    email_template text,
    transaction_type public.email_formats_transaction_type_enum DEFAULT 'Broker'::public.email_formats_transaction_type_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone,
    modified_ip character varying(255)
);


ALTER TABLE public.email_formats OWNER TO nbcbanq;

--
-- Name: email_formats_email_format_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.email_formats_email_format_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.email_formats_email_format_id_pk_seq OWNER TO nbcbanq;

--
-- Name: email_formats_email_format_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.email_formats_email_format_id_pk_seq OWNED BY public.email_formats.email_format_id_pk;


--
-- Name: faq; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.faq (
    faq_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    faq_category_id bigint DEFAULT '1'::bigint NOT NULL,
    language_id bigint DEFAULT '1'::bigint NOT NULL,
    added_by bigint DEFAULT '0'::bigint NOT NULL,
    question text,
    answer text,
    role_type public.faq_role_type_enum DEFAULT 'User'::public.faq_role_type_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone,
    modified_ip character varying(255)
);


ALTER TABLE public.faq OWNER TO nbcbanq;

--
-- Name: faq_category; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.faq_category (
    faq_cat_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    language_id bigint DEFAULT '1'::bigint NOT NULL,
    category_name character varying(255),
    status public.faq_category_status_enum DEFAULT 'Enable'::public.faq_category_status_enum NOT NULL,
    role_type public.faq_category_role_type_enum DEFAULT 'User'::public.faq_category_role_type_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone,
    modified_ip character varying(255)
);


ALTER TABLE public.faq_category OWNER TO nbcbanq;

--
-- Name: faq_category_faq_cat_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.faq_category_faq_cat_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.faq_category_faq_cat_id_seq OWNER TO nbcbanq;

--
-- Name: faq_category_faq_cat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.faq_category_faq_cat_id_seq OWNED BY public.faq_category.faq_cat_id;


--
-- Name: faq_faq_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.faq_faq_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.faq_faq_id_seq OWNER TO nbcbanq;

--
-- Name: faq_faq_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.faq_faq_id_seq OWNED BY public.faq.faq_id;


--
-- Name: fee_transaction_type; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.fee_transaction_type (
    fee_settings_type_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    setting_name text,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.fee_transaction_type OWNER TO nbcbanq;

--
-- Name: fee_transaction_type_fee_settings_type_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.fee_transaction_type_fee_settings_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.fee_transaction_type_fee_settings_type_id_seq OWNER TO nbcbanq;

--
-- Name: fee_transaction_type_fee_settings_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.fee_transaction_type_fee_settings_type_id_seq OWNED BY public.fee_transaction_type.fee_settings_type_id;


--
-- Name: feedback; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.feedback (
    feedback_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    feedback_user_id_fk bigint,
    rating character varying(255),
    comment text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.feedback OWNER TO nbcbanq;

--
-- Name: feedback_feedback_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.feedback_feedback_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.feedback_feedback_id_seq OWNER TO nbcbanq;

--
-- Name: feedback_feedback_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.feedback_feedback_id_seq OWNED BY public.feedback.feedback_id;


--
-- Name: fees; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.fees (
    fees_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    price_type public.fees_price_type_enum DEFAULT 'Fixed'::public.fees_price_type_enum NOT NULL,
    price_value numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fees_type public.fees_fees_type_enum DEFAULT 'Broker'::public.fees_fees_type_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.fees OWNER TO nbcbanq;

--
-- Name: fees_fees_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.fees_fees_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.fees_fees_id_seq OWNER TO nbcbanq;

--
-- Name: fees_fees_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.fees_fees_id_seq OWNED BY public.fees.fees_id;


--
-- Name: fees_group_settings; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.fees_group_settings (
    fees_group_settings_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    fee_settings_type_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    setting_group_name text,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.fees_group_settings OWNER TO nbcbanq;

--
-- Name: fees_group_settings_fees_group_settings_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.fees_group_settings_fees_group_settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.fees_group_settings_fees_group_settings_id_seq OWNER TO nbcbanq;

--
-- Name: fees_group_settings_fees_group_settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.fees_group_settings_fees_group_settings_id_seq OWNED BY public.fees_group_settings.fees_group_settings_id;


--
-- Name: fees_multiplegroup; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.fees_multiplegroup (
    fees_multiplegroup_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    fee_settings_type_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    fees_group_settings_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    group_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.fees_multiplegroup OWNER TO nbcbanq;

--
-- Name: fees_multiplegroup_fees_multiplegroup_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.fees_multiplegroup_fees_multiplegroup_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.fees_multiplegroup_fees_multiplegroup_id_seq OWNER TO nbcbanq;

--
-- Name: fees_multiplegroup_fees_multiplegroup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.fees_multiplegroup_fees_multiplegroup_id_seq OWNED BY public.fees_multiplegroup.fees_multiplegroup_id;


--
-- Name: fees_range; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.fees_range (
    range_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    fees_id bigint DEFAULT '0'::bigint NOT NULL,
    min_price numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    max_price numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    per_price numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.fees_range OWNER TO nbcbanq;

--
-- Name: fees_range_range_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.fees_range_range_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.fees_range_range_id_seq OWNER TO nbcbanq;

--
-- Name: fees_range_range_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.fees_range_range_id_seq OWNED BY public.fees_range.range_id;


--
-- Name: fees_type_range_settings; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.fees_type_range_settings (
    fees_type_range_settings_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    fees_type_settings_id bigint DEFAULT '0'::bigint NOT NULL,
    fee_settings_type_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    min_range numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    max_range numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.fees_type_range_settings OWNER TO nbcbanq;

--
-- Name: fees_type_range_settings_fees_type_range_settings_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.fees_type_range_settings_fees_type_range_settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.fees_type_range_settings_fees_type_range_settings_id_seq OWNER TO nbcbanq;

--
-- Name: fees_type_range_settings_fees_type_range_settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.fees_type_range_settings_fees_type_range_settings_id_seq OWNED BY public.fees_type_range_settings.fees_type_range_settings_id;


--
-- Name: fees_type_settings; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.fees_type_settings (
    fees_type_settings_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    fee_settings_type_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    fees_group_settings_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    type public.fees_type_settings_type_enum DEFAULT 'Fixed'::public.fees_type_settings_type_enum NOT NULL,
    amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.fees_type_settings OWNER TO nbcbanq;

--
-- Name: fees_type_settings_fees_type_settings_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.fees_type_settings_fees_type_settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.fees_type_settings_fees_type_settings_id_seq OWNER TO nbcbanq;

--
-- Name: fees_type_settings_fees_type_settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.fees_type_settings_fees_type_settings_id_seq OWNED BY public.fees_type_settings.fees_type_settings_id;


--
-- Name: fiat_currancy; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.fiat_currancy (
    crypto_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    currancyname character varying(255),
    curracycode character varying(255),
    symbole character varying(255),
    fiat_status public.fiat_currancy_fiat_status_enum DEFAULT 'Enable'::public.fiat_currancy_fiat_status_enum NOT NULL,
    basecurrancy public.fiat_currancy_basecurrancy_enum DEFAULT 'No'::public.fiat_currancy_basecurrancy_enum NOT NULL,
    currantrate numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    exchangerate numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    marginrate numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now() NOT NULL,
    modified_ip character varying(255)
);


ALTER TABLE public.fiat_currancy OWNER TO nbcbanq;

--
-- Name: fiat_currancy_crypto_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.fiat_currancy_crypto_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.fiat_currancy_crypto_id_seq OWNER TO nbcbanq;

--
-- Name: fiat_currancy_crypto_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.fiat_currancy_crypto_id_seq OWNED BY public.fiat_currancy.crypto_id;


--
-- Name: inquiry; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.inquiry (
    inquiry_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    manager_id bigint DEFAULT '0'::bigint NOT NULL,
    first_name text,
    last_name text,
    email_id text,
    phone_number text,
    country_code text,
    jsondata text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.inquiry OWNER TO nbcbanq;

--
-- Name: inquiry_inquiry_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.inquiry_inquiry_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.inquiry_inquiry_id_seq OWNER TO nbcbanq;

--
-- Name: inquiry_inquiry_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.inquiry_inquiry_id_seq OWNED BY public.inquiry.inquiry_id;


--
-- Name: language; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.language (
    language_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    language_code character varying(10),
    language_name character varying(30)
);


ALTER TABLE public.language OWNER TO nbcbanq;

--
-- Name: language_language_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.language_language_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.language_language_id_pk_seq OWNER TO nbcbanq;

--
-- Name: language_language_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.language_language_id_pk_seq OWNED BY public.language.language_id_pk;


--
-- Name: limit_group_settings; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.limit_group_settings (
    limit_group_settings_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    fee_settings_type_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    setting_group_name text,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.limit_group_settings OWNER TO nbcbanq;

--
-- Name: limit_group_settings_limit_group_settings_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.limit_group_settings_limit_group_settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.limit_group_settings_limit_group_settings_id_seq OWNER TO nbcbanq;

--
-- Name: limit_group_settings_limit_group_settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.limit_group_settings_limit_group_settings_id_seq OWNED BY public.limit_group_settings.limit_group_settings_id;


--
-- Name: limit_multiplegroup; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.limit_multiplegroup (
    limit_multiplegroup_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    fee_settings_type_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    limit_group_settings_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    group_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.limit_multiplegroup OWNER TO nbcbanq;

--
-- Name: limit_multiplegroup_limit_multiplegroup_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.limit_multiplegroup_limit_multiplegroup_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.limit_multiplegroup_limit_multiplegroup_id_seq OWNER TO nbcbanq;

--
-- Name: limit_multiplegroup_limit_multiplegroup_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.limit_multiplegroup_limit_multiplegroup_id_seq OWNED BY public.limit_multiplegroup.limit_multiplegroup_id;


--
-- Name: limit_type_range_settings; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.limit_type_range_settings (
    limit_type_range_settings_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    limit_group_settings_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    fee_settings_type_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    min_range numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    max_range numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.limit_type_range_settings OWNER TO nbcbanq;

--
-- Name: limit_type_range_settings_limit_type_range_settings_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.limit_type_range_settings_limit_type_range_settings_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.limit_type_range_settings_limit_type_range_settings_id_seq OWNER TO nbcbanq;

--
-- Name: limit_type_range_settings_limit_type_range_settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.limit_type_range_settings_limit_type_range_settings_id_seq OWNED BY public.limit_type_range_settings.limit_type_range_settings_id;


--
-- Name: limits; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.limits (
    limit_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    transaction_type public.limits_transaction_type_enum DEFAULT 'Outgoing'::public.limits_transaction_type_enum NOT NULL,
    min_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    max_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.limits OWNER TO nbcbanq;

--
-- Name: limits_limit_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.limits_limit_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.limits_limit_id_seq OWNER TO nbcbanq;

--
-- Name: limits_limit_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.limits_limit_id_seq OWNED BY public.limits.limit_id;


--
-- Name: login_logs; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.login_logs (
    login_log_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint,
    login_log_ip character varying(255),
    login_datetime timestamp without time zone DEFAULT now() NOT NULL,
    login_browser character varying(255),
    login_os character varying(255)
);


ALTER TABLE public.login_logs OWNER TO nbcbanq;

--
-- Name: login_logs_admin; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.login_logs_admin (
    login_log_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    admin_id_fk bigint DEFAULT '0'::bigint,
    admin_type public.login_logs_admin_admin_type_enum DEFAULT 'Admin'::public.login_logs_admin_admin_type_enum NOT NULL,
    login_log_ip character varying(255),
    login_datetime timestamp without time zone DEFAULT now() NOT NULL,
    login_browser character varying(255),
    login_os character varying(255)
);


ALTER TABLE public.login_logs_admin OWNER TO nbcbanq;

--
-- Name: login_logs_admin_login_log_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.login_logs_admin_login_log_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.login_logs_admin_login_log_pk_seq OWNER TO nbcbanq;

--
-- Name: login_logs_admin_login_log_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.login_logs_admin_login_log_pk_seq OWNED BY public.login_logs_admin.login_log_pk;


--
-- Name: login_logs_login_log_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.login_logs_login_log_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.login_logs_login_log_pk_seq OWNER TO nbcbanq;

--
-- Name: login_logs_login_log_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.login_logs_login_log_pk_seq OWNED BY public.login_logs.login_log_pk;


--
-- Name: logosettings; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.logosettings (
    logo_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    logo_title character varying(255),
    tagline character varying(255),
    logo text,
    mobile_logo text,
    favicon text,
    whitelogo text,
    emaillogo text
);


ALTER TABLE public.logosettings OWNER TO nbcbanq;

--
-- Name: logosettings_logo_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.logosettings_logo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.logosettings_logo_id_seq OWNER TO nbcbanq;

--
-- Name: logosettings_logo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.logosettings_logo_id_seq OWNED BY public.logosettings.logo_id;


--
-- Name: manager; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.manager (
    manager_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    lang_id bigint DEFAULT '1'::bigint NOT NULL,
    country_id bigint DEFAULT '0'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    first_name character varying(255),
    last_name character varying(255),
    email_id character varying(255),
    total_reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    phone_number character varying(255),
    password character varying(255),
    status public.manager_status_enum DEFAULT 'Enable'::public.manager_status_enum NOT NULL,
    auth_status public.manager_auth_status_enum DEFAULT 'Disabled'::public.manager_auth_status_enum NOT NULL,
    google_auth_code character varying(512),
    temp_secret jsonb,
    is_deleted public.manager_is_deleted_enum DEFAULT 'No'::public.manager_is_deleted_enum NOT NULL,
    profile_photo character varying(255),
    email_ref_code character varying(255),
    timezone character varying(255),
    country_code character varying(255),
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_date timestamp without time zone DEFAULT now(),
    modified_ip character varying(255),
    sessionip character varying(255)
);


ALTER TABLE public.manager OWNER TO nbcbanq;

--
-- Name: manager_address; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.manager_address (
    manager_address_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    manager_id bigint DEFAULT '0'::bigint NOT NULL,
    country_id bigint DEFAULT '0'::bigint NOT NULL,
    state_id bigint DEFAULT '0'::bigint NOT NULL,
    address_line1 character varying(512),
    address_line2 character varying(512),
    city character varying(255),
    zipcode character varying(255),
    is_default public.manager_address_is_default_enum DEFAULT 'No'::public.manager_address_is_default_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.manager_address OWNER TO nbcbanq;

--
-- Name: manager_address_manager_address_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.manager_address_manager_address_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manager_address_manager_address_id_pk_seq OWNER TO nbcbanq;

--
-- Name: manager_address_manager_address_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.manager_address_manager_address_id_pk_seq OWNED BY public.manager_address.manager_address_id_pk;


--
-- Name: manager_earn; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.manager_earn (
    manager_earn_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    manager_id bigint DEFAULT '0'::bigint NOT NULL,
    transaction_id bigint DEFAULT '0'::bigint NOT NULL,
    customer_tra_fee_id bigint DEFAULT '0'::bigint NOT NULL,
    total_reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    fees_percentage numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    crypto_type public.manager_earn_crypto_type_enum DEFAULT 'Crypto'::public.manager_earn_crypto_type_enum NOT NULL,
    crypto_id bigint DEFAULT '0'::bigint NOT NULL,
    coin_code character varying(255)
);


ALTER TABLE public.manager_earn OWNER TO nbcbanq;

--
-- Name: manager_earn_manager_earn_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.manager_earn_manager_earn_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manager_earn_manager_earn_id_seq OWNER TO nbcbanq;

--
-- Name: manager_earn_manager_earn_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.manager_earn_manager_earn_id_seq OWNED BY public.manager_earn.manager_earn_id;


--
-- Name: manager_feedback; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.manager_feedback (
    feedback_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    feedback_manager_id_fk bigint,
    rating character varying(255),
    comment text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.manager_feedback OWNER TO nbcbanq;

--
-- Name: manager_feedback_feedback_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.manager_feedback_feedback_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manager_feedback_feedback_id_seq OWNER TO nbcbanq;

--
-- Name: manager_feedback_feedback_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.manager_feedback_feedback_id_seq OWNED BY public.manager_feedback.feedback_id;


--
-- Name: manager_manager_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.manager_manager_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manager_manager_id_seq OWNER TO nbcbanq;

--
-- Name: manager_manager_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.manager_manager_id_seq OWNED BY public.manager.manager_id;


--
-- Name: manager_notification; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.manager_notification (
    notification_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    notification_title text,
    notification_type public.manager_notification_notification_type_enum DEFAULT 'Login'::public.manager_notification_notification_type_enum NOT NULL,
    notification_desc text,
    notification_status public.manager_notification_notification_status_enum DEFAULT 'Enable'::public.manager_notification_notification_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.manager_notification OWNER TO nbcbanq;

--
-- Name: manager_notification_notification_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.manager_notification_notification_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manager_notification_notification_id_seq OWNER TO nbcbanq;

--
-- Name: manager_notification_notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.manager_notification_notification_id_seq OWNED BY public.manager_notification.notification_id;


--
-- Name: manager_withdraw; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.manager_withdraw (
    mwithdraw_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    admin_id bigint DEFAULT '0'::bigint NOT NULL,
    admin_type public.manager_withdraw_admin_type_enum DEFAULT 'Manager'::public.manager_withdraw_admin_type_enum NOT NULL,
    req_type public.manager_withdraw_req_type_enum DEFAULT 'Automatic'::public.manager_withdraw_req_type_enum NOT NULL,
    withdraw_status public.manager_withdraw_withdraw_status_enum DEFAULT 'Pending'::public.manager_withdraw_withdraw_status_enum NOT NULL,
    withdraw_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.manager_withdraw OWNER TO nbcbanq;

--
-- Name: manager_withdraw_mwithdraw_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.manager_withdraw_mwithdraw_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manager_withdraw_mwithdraw_id_seq OWNER TO nbcbanq;

--
-- Name: manager_withdraw_mwithdraw_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.manager_withdraw_mwithdraw_id_seq OWNED BY public.manager_withdraw.mwithdraw_id;


--
-- Name: manager_withdraw_request; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.manager_withdraw_request (
    manager_withdraw_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    manager_id bigint DEFAULT '0'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id bigint DEFAULT '0'::bigint NOT NULL,
    withdraw_type public.manager_withdraw_request_withdraw_type_enum DEFAULT 'Automatic'::public.manager_withdraw_request_withdraw_type_enum NOT NULL,
    withdraw_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    manager_withdraw_status public.manager_withdraw_request_manager_withdraw_status_enum DEFAULT 'Pending'::public.manager_withdraw_request_manager_withdraw_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    currancy_type character varying(255),
    manager_reward_id bigint DEFAULT '0'::bigint NOT NULL
);


ALTER TABLE public.manager_withdraw_request OWNER TO nbcbanq;

--
-- Name: manager_withdraw_request_manager_withdraw_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.manager_withdraw_request_manager_withdraw_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.manager_withdraw_request_manager_withdraw_id_seq OWNER TO nbcbanq;

--
-- Name: manager_withdraw_request_manager_withdraw_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.manager_withdraw_request_manager_withdraw_id_seq OWNED BY public.manager_withdraw_request.manager_withdraw_id;


--
-- Name: managercrypto_reward; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.managercrypto_reward (
    manager_reward_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    admin_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    crypto_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    coin_code character varying(255),
    reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.managercrypto_reward OWNER TO nbcbanq;

--
-- Name: managercrypto_reward_manager_reward_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.managercrypto_reward_manager_reward_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.managercrypto_reward_manager_reward_id_seq OWNER TO nbcbanq;

--
-- Name: managercrypto_reward_manager_reward_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.managercrypto_reward_manager_reward_id_seq OWNED BY public.managercrypto_reward.manager_reward_id;


--
-- Name: managerfiat_reward; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.managerfiat_reward (
    manager_fiatreward_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    admin_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    fiat_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    coin_code character varying(255),
    reward numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.managerfiat_reward OWNER TO nbcbanq;

--
-- Name: managerfiat_reward_manager_fiatreward_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.managerfiat_reward_manager_fiatreward_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.managerfiat_reward_manager_fiatreward_id_seq OWNER TO nbcbanq;

--
-- Name: managerfiat_reward_manager_fiatreward_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.managerfiat_reward_manager_fiatreward_id_seq OWNED BY public.managerfiat_reward.manager_fiatreward_id;


--
-- Name: module_role; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.module_role (
    module_role_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    module_name character varying(50) NOT NULL
);


ALTER TABLE public.module_role OWNER TO nbcbanq;

--
-- Name: module_role_module_role_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.module_role_module_role_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.module_role_module_role_id_pk_seq OWNER TO nbcbanq;

--
-- Name: module_role_module_role_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.module_role_module_role_id_pk_seq OWNED BY public.module_role.module_role_id_pk;


--
-- Name: news; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.news (
    news_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    added_by bigint DEFAULT '0'::bigint NOT NULL,
    language_id bigint DEFAULT '1'::bigint NOT NULL,
    title character varying(255),
    description text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone,
    modified_ip character varying(255)
);


ALTER TABLE public.news OWNER TO nbcbanq;

--
-- Name: news_news_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.news_news_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.news_news_id_seq OWNER TO nbcbanq;

--
-- Name: news_news_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.news_news_id_seq OWNED BY public.news.news_id;


--
-- Name: notification; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.notification (
    noti_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    type public.notification_type_enum DEFAULT 'User'::public.notification_type_enum NOT NULL,
    title character varying(255),
    description text,
    transaction_type public.notification_transaction_type_enum DEFAULT 'Broker'::public.notification_transaction_type_enum NOT NULL,
    read public.notification_read_enum DEFAULT 'No'::public.notification_read_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone,
    modified_ip character varying(255)
);


ALTER TABLE public.notification OWNER TO nbcbanq;

--
-- Name: notification_noti_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.notification_noti_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.notification_noti_id_seq OWNER TO nbcbanq;

--
-- Name: notification_noti_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.notification_noti_id_seq OWNED BY public.notification.noti_id;


--
-- Name: otherreq; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.otherreq (
    other_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    other_title character varying(255),
    other_status public.otherreq_other_status_enum DEFAULT 'No'::public.otherreq_other_status_enum NOT NULL
);


ALTER TABLE public.otherreq OWNER TO nbcbanq;

--
-- Name: otherreq_other_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.otherreq_other_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.otherreq_other_id_seq OWNER TO nbcbanq;

--
-- Name: otherreq_other_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.otherreq_other_id_seq OWNED BY public.otherreq.other_id;


--
-- Name: pages; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.pages (
    page_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    page_language_id bigint,
    page_title character varying(255),
    page_description text,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.pages OWNER TO nbcbanq;

--
-- Name: pages_page_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.pages_page_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.pages_page_id_pk_seq OWNER TO nbcbanq;

--
-- Name: pages_page_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.pages_page_id_pk_seq OWNED BY public.pages.page_id_pk;


--
-- Name: role; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.role (
    role_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    role_name text,
    module_array text
);


ALTER TABLE public.role OWNER TO nbcbanq;

--
-- Name: role_role_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.role_role_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.role_role_id_pk_seq OWNER TO nbcbanq;

--
-- Name: role_role_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.role_role_id_pk_seq OWNED BY public.role.role_id_pk;


--
-- Name: sem; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.sem (
    sem_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    sem_name text,
    sem_value text,
    status public.sem_status_enum DEFAULT 'Enable'::public.sem_status_enum NOT NULL
);


ALTER TABLE public.sem OWNER TO nbcbanq;

--
-- Name: sem_sem_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.sem_sem_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sem_sem_id_seq OWNER TO nbcbanq;

--
-- Name: sem_sem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.sem_sem_id_seq OWNED BY public.sem.sem_id;


--
-- Name: seo; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.seo (
    seo_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    seo_title text,
    seo_value text,
    seo_status public.seo_seo_status_enum DEFAULT 'Enable'::public.seo_seo_status_enum NOT NULL
);


ALTER TABLE public.seo OWNER TO nbcbanq;

--
-- Name: seo_seo_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.seo_seo_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.seo_seo_id_seq OWNER TO nbcbanq;

--
-- Name: seo_seo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.seo_seo_id_seq OWNED BY public.seo.seo_id;


--
-- Name: setting; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.setting (
    setting_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    setting_name character varying(255),
    setting_value character varying(255),
    setting_status public.setting_setting_status_enum DEFAULT 'Enable'::public.setting_setting_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.setting OWNER TO nbcbanq;

--
-- Name: setting_setting_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.setting_setting_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.setting_setting_id_pk_seq OWNER TO nbcbanq;

--
-- Name: setting_setting_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.setting_setting_id_pk_seq OWNED BY public.setting.setting_id_pk;


--
-- Name: state; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.state (
    id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    name character varying(30),
    country_id integer,
    status public.state_status_enum DEFAULT 'Enable'::public.state_status_enum NOT NULL
);


ALTER TABLE public.state OWNER TO nbcbanq;

--
-- Name: state_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.state_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.state_id_seq OWNER TO nbcbanq;

--
-- Name: state_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.state_id_seq OWNED BY public.state.id;


--
-- Name: taskmanager; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.taskmanager (
    task_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    table_id bigint DEFAULT '1'::bigint NOT NULL,
    table_name text,
    user_type public.taskmanager_user_type_enum DEFAULT 'User'::public.taskmanager_user_type_enum NOT NULL,
    transaction_type public.taskmanager_transaction_type_enum DEFAULT 'Buy'::public.taskmanager_transaction_type_enum NOT NULL,
    status public.taskmanager_status_enum DEFAULT 'Pending'::public.taskmanager_status_enum NOT NULL,
    cron_status public.taskmanager_cron_status_enum DEFAULT 'No'::public.taskmanager_cron_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    cron_datetime timestamp without time zone,
    cron_ip character varying(255),
    apistatus public.taskmanager_apistatus_enum DEFAULT 'Pending'::public.taskmanager_apistatus_enum NOT NULL,
    roletype public.taskmanager_roletype_enum DEFAULT 'Admin'::public.taskmanager_roletype_enum NOT NULL,
    role_id bigint DEFAULT '0'::bigint NOT NULL
);


ALTER TABLE public.taskmanager OWNER TO nbcbanq;

--
-- Name: taskmanager_task_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.taskmanager_task_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.taskmanager_task_id_seq OWNER TO nbcbanq;

--
-- Name: taskmanager_task_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.taskmanager_task_id_seq OWNED BY public.taskmanager.task_id;


--
-- Name: themesettings; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.themesettings (
    theme_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    theme_name character varying(255),
    primary_color character varying(255),
    primary_hover_color character varying(255),
    secondary_color character varying(255),
    secondary_page_font_color character varying(255),
    menu_default_color character varying(255),
    menu_background character varying(255),
    close_button_color character varying(255),
    defaultheme public.themesettings_defaultheme_enum DEFAULT 'No'::public.themesettings_defaultheme_enum NOT NULL
);


ALTER TABLE public.themesettings OWNER TO nbcbanq;

--
-- Name: themesettings_theme_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.themesettings_theme_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.themesettings_theme_id_seq OWNER TO nbcbanq;

--
-- Name: themesettings_theme_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.themesettings_theme_id_seq OWNED BY public.themesettings.theme_id;


--
-- Name: timezone; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.timezone (
    tid bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    gmtdata text,
    timezonedata text,
    tstatus public.timezone_tstatus_enum DEFAULT 'Enable'::public.timezone_tstatus_enum NOT NULL,
    timezonename text
);


ALTER TABLE public.timezone OWNER TO nbcbanq;

--
-- Name: timezone_tid_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.timezone_tid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.timezone_tid_seq OWNER TO nbcbanq;

--
-- Name: timezone_tid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.timezone_tid_seq OWNED BY public.timezone.tid;


--
-- Name: transaction_request; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.transaction_request (
    transaction_request_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    setting_name text,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    action character varying(255) DEFAULT 'Yes'::character varying NOT NULL,
    broker_min_trans_amt bigint,
    broker_max_trans_amt bigint,
    manager_min_trans_amt bigint,
    manager_max_trans_amt bigint,
    admin_min_trans_amt bigint
);


ALTER TABLE public.transaction_request OWNER TO nbcbanq;

--
-- Name: transaction_request_transaction_request_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.transaction_request_transaction_request_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.transaction_request_transaction_request_id_seq OWNER TO nbcbanq;

--
-- Name: transaction_request_transaction_request_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.transaction_request_transaction_request_id_seq OWNED BY public.transaction_request.transaction_request_id;


--
-- Name: user; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public."user" (
    user_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    lang_id bigint DEFAULT '1'::bigint NOT NULL,
    manager_id bigint DEFAULT '0'::bigint NOT NULL,
    broker_id bigint DEFAULT '0'::bigint NOT NULL,
    first_name character varying(255),
    last_name character varying(255),
    middle_name character varying(255),
    email_id character varying(255),
    customer_id character varying(255),
    dob character varying(255),
    phone_number character varying(255),
    image_64 text,
    user_validation_uuid text DEFAULT gen_random_uuid(),
    status public.user_status_enum DEFAULT 'Enable'::public.user_status_enum NOT NULL,
    google_auth_code character varying(255),
    auth_status public.user_auth_status_enum DEFAULT 'Disable'::public.user_auth_status_enum NOT NULL,
    is_deleted public.user_is_deleted_enum DEFAULT 'No'::public.user_is_deleted_enum NOT NULL,
    timezone character varying(255),
    email_ref_code character varying(255),
    country_code character varying(255),
    sms_otp character varying(255),
    sms_otp_expire_time timestamp without time zone DEFAULT now(),
    email_otp character varying(255),
    email_otp_expire_time timestamp without time zone DEFAULT now(),
    temp_secret jsonb,
    verification public.user_verification_enum DEFAULT 'No'::public.user_verification_enum NOT NULL,
    demouser public.user_demouser_enum DEFAULT 'No'::public.user_demouser_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now(),
    modified_ip character varying(255),
    sessionip character varying(255),
    user_group_id bigint DEFAULT '0'::bigint NOT NULL
);


ALTER TABLE public."user" OWNER TO nbcbanq;

--
-- Name: user_accounts; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_accounts (
    account_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    country_id bigint DEFAULT '0'::bigint NOT NULL,
    account_number character varying(255),
    branch_code character varying(255),
    customer_name character varying(255),
    customer_email character varying(255),
    customer_phone character varying(255),
    customer_address text,
    available_balance numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    holding_balance numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    account_balance numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    status public.user_accounts_status_enum DEFAULT 'Enable'::public.user_accounts_status_enum NOT NULL,
    is_deleted public.user_accounts_is_deleted_enum DEFAULT 'No'::public.user_accounts_is_deleted_enum NOT NULL,
    type public.user_accounts_type_enum DEFAULT 'Domestic'::public.user_accounts_type_enum NOT NULL,
    bank_name character varying(255),
    routing_number character varying(255),
    credit_to character varying(255),
    bank_address text,
    reference character varying(255),
    bank_phone character varying(255),
    swift_code character varying(255),
    address1 text,
    address2 text,
    city character varying(255),
    region character varying(255),
    postal_code character varying(255),
    iban_number character varying(255),
    admin_fee numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    virtual_balance numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_date timestamp without time zone DEFAULT now(),
    modified_ip character varying(255),
    account_type character varying(255),
    account_currency_type character varying(255)
);


ALTER TABLE public.user_accounts OWNER TO nbcbanq;

--
-- Name: user_accounts_account_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_accounts_account_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_accounts_account_id_pk_seq OWNER TO nbcbanq;

--
-- Name: user_accounts_account_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_accounts_account_id_pk_seq OWNED BY public.user_accounts.account_id_pk;


--
-- Name: user_address; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_address (
    user_address_id_pk bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    country_id bigint DEFAULT '0'::bigint NOT NULL,
    state_id bigint DEFAULT '0'::bigint NOT NULL,
    address_line1 character varying(512),
    address_line2 character varying(512),
    city character varying(255),
    zipcode character varying(255),
    is_default public.user_address_is_default_enum DEFAULT 'No'::public.user_address_is_default_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.user_address OWNER TO nbcbanq;

--
-- Name: user_address_user_address_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_address_user_address_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_address_user_address_id_pk_seq OWNER TO nbcbanq;

--
-- Name: user_address_user_address_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_address_user_address_id_pk_seq OWNED BY public.user_address.user_address_id_pk;


--
-- Name: user_cards; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_cards (
    card_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    cardinfo_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    account_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    cardtype_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    country_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    delivery_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    card_customer_name text,
    card_number text,
    exp_month text,
    exp_year text,
    cvv_number text,
    first_name text,
    last_name text,
    country_code text,
    phone_number text,
    password text,
    address1 text,
    address2 text,
    postalcode text,
    city text,
    virtual_balance numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    card_balance numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    atminternationallimit numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    poscircuitlimit numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    dailyoverall numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    weeklyoverall numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    monthlyoverall numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    usercard_status public.user_cards_usercard_status_enum DEFAULT 'Pending'::public.user_cards_usercard_status_enum NOT NULL,
    withdraw_fromaccount public.user_cards_withdraw_fromaccount_enum DEFAULT 'No'::public.user_cards_withdraw_fromaccount_enum NOT NULL,
    smsalert public.user_cards_smsalert_enum DEFAULT 'No'::public.user_cards_smsalert_enum NOT NULL,
    contactless_enabled public.user_cards_contactless_enabled_enum DEFAULT 'No'::public.user_cards_contactless_enabled_enum NOT NULL,
    withdrawal_enabled public.user_cards_withdrawal_enabled_enum DEFAULT 'No'::public.user_cards_withdrawal_enabled_enum NOT NULL,
    internet_purchase_enabled public.user_cards_internet_purchase_enabled_enum DEFAULT 'No'::public.user_cards_internet_purchase_enabled_enum NOT NULL,
    overall_limits_enabled public.user_cards_overall_limits_enabled_enum DEFAULT 'No'::public.user_cards_overall_limits_enabled_enum NOT NULL,
    card_currancy public.user_cards_card_currancy_enum DEFAULT 'USD'::public.user_cards_card_currancy_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now() NOT NULL,
    modified_ip character varying(255),
    state_id_fk bigint DEFAULT '0'::bigint NOT NULL
);


ALTER TABLE public.user_cards OWNER TO nbcbanq;

--
-- Name: user_cards_card_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_cards_card_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_cards_card_id_seq OWNER TO nbcbanq;

--
-- Name: user_cards_card_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_cards_card_id_seq OWNED BY public.user_cards.card_id;


--
-- Name: user_crypto_wallets; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_crypto_wallets (
    crypto_wallet_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    crypto_fk bigint DEFAULT '0'::bigint NOT NULL,
    coin_code character varying(255),
    wallet_balance numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    total_settled numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    total_available numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    total_unavailable numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    wallet_status public.user_crypto_wallets_wallet_status_enum DEFAULT 'Enable'::public.user_crypto_wallets_wallet_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now() NOT NULL,
    modified_ip character varying(255)
);


ALTER TABLE public.user_crypto_wallets OWNER TO nbcbanq;

--
-- Name: user_crypto_wallets_crypto_wallet_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_crypto_wallets_crypto_wallet_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_crypto_wallets_crypto_wallet_id_seq OWNER TO nbcbanq;

--
-- Name: user_crypto_wallets_crypto_wallet_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_crypto_wallets_crypto_wallet_id_seq OWNED BY public.user_crypto_wallets.crypto_wallet_id;


--
-- Name: user_deposit_fund; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_deposit_fund (
    depositfund_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id bigint DEFAULT '0'::bigint NOT NULL,
    transaction_hash character varying(255),
    information text,
    fund_amount numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    withdraw_status public.user_deposit_fund_withdraw_status_enum DEFAULT 'Pending'::public.user_deposit_fund_withdraw_status_enum NOT NULL,
    admin_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    transaction_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    total_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.user_deposit_fund OWNER TO nbcbanq;

--
-- Name: user_deposit_fund_depositfund_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_deposit_fund_depositfund_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_deposit_fund_depositfund_id_seq OWNER TO nbcbanq;

--
-- Name: user_deposit_fund_depositfund_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_deposit_fund_depositfund_id_seq OWNED BY public.user_deposit_fund.depositfund_id;


--
-- Name: user_deposit_transaction; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_deposit_transaction (
    deposit_tra_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    crypto_wallet_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id bigint DEFAULT '0'::bigint NOT NULL,
    deposit_address_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    transaction_hash character varying(255),
    deposit_amount numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    deposit_status public.user_deposit_transaction_deposit_status_enum DEFAULT 'Pending'::public.user_deposit_transaction_deposit_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    wallet_address_ref text,
    information text
);


ALTER TABLE public.user_deposit_transaction OWNER TO nbcbanq;

--
-- Name: user_deposit_transaction_deposit_tra_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_deposit_transaction_deposit_tra_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_deposit_transaction_deposit_tra_id_seq OWNER TO nbcbanq;

--
-- Name: user_deposit_transaction_deposit_tra_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_deposit_transaction_deposit_tra_id_seq OWNED BY public.user_deposit_transaction.deposit_tra_id;


--
-- Name: user_document; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_document (
    document_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    kyc_id bigint DEFAULT '0'::bigint NOT NULL,
    document_type_id bigint DEFAULT '0'::bigint NOT NULL,
    document_country bigint DEFAULT '0'::bigint NOT NULL,
    document_type_title character varying(512),
    document_front character varying(512),
    document_baack character varying(512),
    other character varying(512),
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.user_document OWNER TO nbcbanq;

--
-- Name: user_document_document_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_document_document_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_document_document_id_seq OWNER TO nbcbanq;

--
-- Name: user_document_document_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_document_document_id_seq OWNED BY public.user_document.document_id;


--
-- Name: user_emailnotification; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_emailnotification (
    notification_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    notification_title text,
    notification_type public.user_emailnotification_notification_type_enum DEFAULT 'Login'::public.user_emailnotification_notification_type_enum NOT NULL,
    notification_desc text,
    notification_status public.user_emailnotification_notification_status_enum DEFAULT 'Enable'::public.user_emailnotification_notification_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.user_emailnotification OWNER TO nbcbanq;

--
-- Name: user_emailnotification_notification_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_emailnotification_notification_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_emailnotification_notification_id_seq OWNER TO nbcbanq;

--
-- Name: user_emailnotification_notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_emailnotification_notification_id_seq OWNED BY public.user_emailnotification.notification_id;


--
-- Name: user_exchange_transaction; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_exchange_transaction (
    exchange_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    crypto_wallet_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id bigint DEFAULT '0'::bigint NOT NULL,
    exchnage_pair character varying(255),
    fiat_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    crypto_amount numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    transaction_hash character varying(255),
    exchange_type public.user_exchange_transaction_exchange_type_enum DEFAULT 'Buy'::public.user_exchange_transaction_exchange_type_enum NOT NULL,
    transfer_status public.user_exchange_transaction_transfer_status_enum DEFAULT 'Pending'::public.user_exchange_transaction_transfer_status_enum NOT NULL,
    admin_fees_fiat numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    transaction_fees_fiat numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    total_amount_fiat numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    current_crypto_rate numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    broker_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    final_final character varying(255) DEFAULT '0'::character varying NOT NULL,
    tenpercnt character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeesper character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeestype character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    broker_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    crypto_coin_id character varying(255) DEFAULT '0'::character varying NOT NULL,
    crypto_coin_code character varying(255) DEFAULT '0'::character varying NOT NULL,
    accountdetails character varying(255) DEFAULT '0'::character varying NOT NULL,
    fee_flag character varying(255) DEFAULT '0'::character varying NOT NULL
);


ALTER TABLE public.user_exchange_transaction OWNER TO nbcbanq;

--
-- Name: user_exchange_transaction_exchange_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_exchange_transaction_exchange_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_exchange_transaction_exchange_id_seq OWNER TO nbcbanq;

--
-- Name: user_exchange_transaction_exchange_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_exchange_transaction_exchange_id_seq OWNED BY public.user_exchange_transaction.exchange_id;


--
-- Name: user_fiat_balancesheet; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_fiat_balancesheet (
    balance_sheet_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    dynamic_tableid bigint DEFAULT '0'::bigint NOT NULL,
    transaction_hash character varying(255),
    type public.user_fiat_balancesheet_type_enum DEFAULT 'Debit'::public.user_fiat_balancesheet_type_enum NOT NULL,
    transaction_type public.user_fiat_balancesheet_transaction_type_enum DEFAULT 'Internal'::public.user_fiat_balancesheet_transaction_type_enum NOT NULL,
    amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    current_balance numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    currency_type character varying(255)
);


ALTER TABLE public.user_fiat_balancesheet OWNER TO nbcbanq;

--
-- Name: user_fiat_balancesheet_balance_sheet_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_fiat_balancesheet_balance_sheet_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_fiat_balancesheet_balance_sheet_id_seq OWNER TO nbcbanq;

--
-- Name: user_fiat_balancesheet_balance_sheet_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_fiat_balancesheet_balance_sheet_id_seq OWNED BY public.user_fiat_balancesheet.balance_sheet_id;


--
-- Name: user_fiat_depoist_transaction; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_fiat_depoist_transaction (
    fiat_trans_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    description text,
    type public.user_fiat_depoist_transaction_type_enum DEFAULT 'Debit'::public.user_fiat_depoist_transaction_type_enum NOT NULL,
    amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    current_balance numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    status public.user_fiat_depoist_transaction_status_enum DEFAULT 'Pending'::public.user_fiat_depoist_transaction_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255)
);


ALTER TABLE public.user_fiat_depoist_transaction OWNER TO nbcbanq;

--
-- Name: user_fiat_depoist_transaction_fiat_trans_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_fiat_depoist_transaction_fiat_trans_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_fiat_depoist_transaction_fiat_trans_id_seq OWNER TO nbcbanq;

--
-- Name: user_fiat_depoist_transaction_fiat_trans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_fiat_depoist_transaction_fiat_trans_id_seq OWNED BY public.user_fiat_depoist_transaction.fiat_trans_id;


--
-- Name: user_fiat_internal_transaction; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_fiat_internal_transaction (
    internal_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    from_user_id bigint DEFAULT '0'::bigint NOT NULL,
    to_user_id bigint DEFAULT '0'::bigint NOT NULL,
    from_account_fk bigint DEFAULT '0'::bigint NOT NULL,
    to_account_fk bigint DEFAULT '0'::bigint NOT NULL,
    email_address character varying(255),
    amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    currency public.user_fiat_internal_transaction_currency_enum DEFAULT 'USD'::public.user_fiat_internal_transaction_currency_enum NOT NULL,
    message text,
    admin_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    transaction_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    total_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    status public.user_fiat_internal_transaction_status_enum DEFAULT 'Pending'::public.user_fiat_internal_transaction_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    hash text,
    broker_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    final_final character varying(255) DEFAULT '0'::character varying NOT NULL,
    tenpercnt character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeesper character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeestype character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    broker_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    fee_flag character varying(255) DEFAULT '0'::character varying NOT NULL
);


ALTER TABLE public.user_fiat_internal_transaction OWNER TO nbcbanq;

--
-- Name: user_fiat_internal_transaction_internal_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_fiat_internal_transaction_internal_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_fiat_internal_transaction_internal_id_seq OWNER TO nbcbanq;

--
-- Name: user_fiat_internal_transaction_internal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_fiat_internal_transaction_internal_id_seq OWNED BY public.user_fiat_internal_transaction.internal_id;


--
-- Name: user_fiat_withdraw_transaction; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_fiat_withdraw_transaction (
    fiat_with_trans_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    country_id bigint DEFAULT '0'::bigint NOT NULL,
    label character varying(255),
    bank_account_name character varying(255),
    amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    account_number character varying(255),
    routing_number character varying(255),
    address1 text,
    address2 text,
    city character varying(255),
    region character varying(255),
    postal_code character varying(255),
    iban_number character varying(255),
    referance character varying(255),
    transfer_type public.user_fiat_withdraw_transaction_transfer_type_enum DEFAULT 'Ach'::public.user_fiat_withdraw_transaction_transfer_type_enum NOT NULL,
    status public.user_fiat_withdraw_transaction_status_enum DEFAULT 'Pending'::public.user_fiat_withdraw_transaction_status_enum NOT NULL,
    check_type public.user_fiat_withdraw_transaction_check_type_enum DEFAULT 'Personal'::public.user_fiat_withdraw_transaction_check_type_enum NOT NULL,
    account_type public.user_fiat_withdraw_transaction_account_type_enum DEFAULT 'Saving'::public.user_fiat_withdraw_transaction_account_type_enum NOT NULL,
    switch_code character varying(255),
    bank_name character varying(255),
    bank_currency public.user_fiat_withdraw_transaction_bank_currency_enum DEFAULT 'USD'::public.user_fiat_withdraw_transaction_bank_currency_enum NOT NULL,
    message text,
    admin_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    transaction_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    total_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    temp_type public.user_fiat_withdraw_transaction_temp_type_enum DEFAULT 'No'::public.user_fiat_withdraw_transaction_temp_type_enum NOT NULL,
    temp_name character varying(255) DEFAULT '0'::character varying,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    hash text
);


ALTER TABLE public.user_fiat_withdraw_transaction OWNER TO nbcbanq;

--
-- Name: user_fiat_withdraw_transaction_fiat_with_trans_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_fiat_withdraw_transaction_fiat_with_trans_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_fiat_withdraw_transaction_fiat_with_trans_id_seq OWNER TO nbcbanq;

--
-- Name: user_fiat_withdraw_transaction_fiat_with_trans_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_fiat_withdraw_transaction_fiat_with_trans_id_seq OWNED BY public.user_fiat_withdraw_transaction.fiat_with_trans_id;


--
-- Name: user_kyc; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_kyc (
    kyc_id bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    country_id bigint DEFAULT '0'::bigint NOT NULL,
    tax_country_id bigint DEFAULT '0'::bigint NOT NULL,
    tax_state_id bigint DEFAULT '0'::bigint NOT NULL,
    region bigint DEFAULT '0'::bigint NOT NULL,
    first_name character varying(255),
    last_name character varying(255),
    middle_name character varying(255),
    email character varying(255),
    phonecpde character varying(255),
    phone_number character varying(255),
    dob character varying(255),
    taxidssn_number character varying(255),
    address1 character varying(512),
    address2 character varying(512),
    city character varying(255),
    postalcode character varying(255),
    kyc_status public.user_kyc_kyc_status_enum DEFAULT 'Pending'::public.user_kyc_kyc_status_enum NOT NULL,
    kyc_api_status public.user_kyc_kyc_api_status_enum DEFAULT 'Pending'::public.user_kyc_kyc_api_status_enum NOT NULL,
    aml_kyc_status public.user_kyc_aml_kyc_status_enum DEFAULT 'Pending'::public.user_kyc_aml_kyc_status_enum NOT NULL,
    cip_kyc_status public.user_kyc_cip_kyc_status_enum DEFAULT 'Pending'::public.user_kyc_cip_kyc_status_enum NOT NULL,
    iddoc_kyc_status public.user_kyc_iddoc_kyc_status_enum DEFAULT 'Pending'::public.user_kyc_iddoc_kyc_status_enum NOT NULL,
    address_kyc_status public.user_kyc_address_kyc_status_enum DEFAULT 'Pending'::public.user_kyc_address_kyc_status_enum NOT NULL,
    aml_approved_datetime timestamp without time zone DEFAULT now(),
    cip_approved_datetime timestamp without time zone DEFAULT now(),
    iddoc_approved_datetime timestamp without time zone DEFAULT now(),
    address_approved_datetime timestamp without time zone DEFAULT now(),
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_date timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.user_kyc OWNER TO nbcbanq;

--
-- Name: user_kyc_kyc_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_kyc_kyc_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_kyc_kyc_id_seq OWNER TO nbcbanq;

--
-- Name: user_kyc_kyc_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_kyc_kyc_id_seq OWNED BY public.user_kyc.kyc_id;


--
-- Name: user_notification; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_notification (
    notification_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    notification_title text,
    notification_type public.user_notification_notification_type_enum DEFAULT 'Login'::public.user_notification_notification_type_enum NOT NULL,
    notification_desc text,
    notification_status public.user_notification_notification_status_enum DEFAULT 'Enable'::public.user_notification_notification_status_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.user_notification OWNER TO nbcbanq;

--
-- Name: user_notification_notification_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_notification_notification_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_notification_notification_id_seq OWNER TO nbcbanq;

--
-- Name: user_notification_notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_notification_notification_id_seq OWNED BY public.user_notification.notification_id;


--
-- Name: user_swap_transaction; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_swap_transaction (
    swap_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    from_crypto_wallet_id bigint DEFAULT '0'::bigint NOT NULL,
    to_crypto_wallet_id bigint DEFAULT '0'::bigint NOT NULL,
    from_amount numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    to_amount numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    transaction_hash character varying(255),
    swap_status public.user_swap_transaction_swap_status_enum DEFAULT 'Pending'::public.user_swap_transaction_swap_status_enum NOT NULL,
    admin_fees_from numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    transaction_fees_from numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    total_amount_from numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    current_crypto_rate numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    broker_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    final_final character varying(255) DEFAULT '0'::character varying NOT NULL,
    tenpercnt character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeesper character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeestype character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    broker_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    crypto_coin_id character varying(255) DEFAULT '0'::character varying NOT NULL,
    crypto_coin_code character varying(255) DEFAULT '0'::character varying NOT NULL,
    accountdetails character varying(255) DEFAULT '0'::character varying NOT NULL,
    fee_flag character varying(255) DEFAULT '0'::character varying NOT NULL
);


ALTER TABLE public.user_swap_transaction OWNER TO nbcbanq;

--
-- Name: user_swap_transaction_swap_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_swap_transaction_swap_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_swap_transaction_swap_id_seq OWNER TO nbcbanq;

--
-- Name: user_swap_transaction_swap_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_swap_transaction_swap_id_seq OWNED BY public.user_swap_transaction.swap_id;


--
-- Name: user_transfer; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_transfer (
    transfer_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    crypto_wallet_id bigint DEFAULT '0'::bigint NOT NULL,
    to_wallet_address character varying(255),
    to_user_id bigint DEFAULT '0'::bigint NOT NULL,
    transfer_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    transaction_hash character varying(255),
    transfer_status public.user_transfer_transfer_status_enum DEFAULT 'Pending'::public.user_transfer_transfer_status_enum NOT NULL,
    admin_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    transaction_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    total_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    broker_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    final_final character varying(255) DEFAULT '0'::character varying NOT NULL,
    tenpercnt character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeesper character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeestype character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    broker_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    crypto_coin_id character varying(255) DEFAULT '0'::character varying NOT NULL,
    crypto_coin_code character varying(255) DEFAULT '0'::character varying NOT NULL,
    fee_flag character varying(255) DEFAULT '0'::character varying NOT NULL
);


ALTER TABLE public.user_transfer OWNER TO nbcbanq;

--
-- Name: user_transfer_transfer_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_transfer_transfer_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_transfer_transfer_id_seq OWNER TO nbcbanq;

--
-- Name: user_transfer_transfer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_transfer_transfer_id_seq OWNED BY public.user_transfer.transfer_id;


--
-- Name: user_uploads; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_uploads (
    upload_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    kyc_id bigint DEFAULT '0'::bigint NOT NULL,
    upload_file_name character varying(512),
    created_datetime timestamp without time zone DEFAULT now()
);


ALTER TABLE public.user_uploads OWNER TO nbcbanq;

--
-- Name: user_uploads_upload_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_uploads_upload_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_uploads_upload_id_seq OWNER TO nbcbanq;

--
-- Name: user_uploads_upload_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_uploads_upload_id_seq OWNED BY public.user_uploads.upload_id;


--
-- Name: user_user_id_pk_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_user_id_pk_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_user_id_pk_seq OWNER TO nbcbanq;

--
-- Name: user_user_id_pk_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_user_id_pk_seq OWNED BY public."user".user_id_pk;


--
-- Name: user_withdraw_transaction; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.user_withdraw_transaction (
    withdraw_tra_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    crypto_wallet_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id bigint DEFAULT '0'::bigint NOT NULL,
    withdraw_address_id bigint DEFAULT '0'::bigint NOT NULL,
    withdraw_address character varying(512) NOT NULL,
    transaction_hash character varying(255),
    withdraw_amount numeric(16,8) DEFAULT '0'::numeric NOT NULL,
    withdraw_status public.user_withdraw_transaction_withdraw_status_enum DEFAULT 'Pending'::public.user_withdraw_transaction_withdraw_status_enum NOT NULL,
    admin_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    transaction_fees numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    total_amount numeric(16,2) DEFAULT '0'::numeric NOT NULL,
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255),
    broker_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_reward character varying(255) DEFAULT '0'::character varying NOT NULL,
    final_final character varying(255) DEFAULT '0'::character varying NOT NULL,
    tenpercnt character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeesper character varying(255) DEFAULT '0'::character varying NOT NULL,
    custtrafeestype character varying(255) DEFAULT '0'::character varying NOT NULL,
    manager_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    broker_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    admin_fees_per character varying(255) DEFAULT '0'::character varying NOT NULL,
    crypto_coin_id character varying(255) DEFAULT '0'::character varying NOT NULL,
    crypto_coin_code character varying(255) DEFAULT '0'::character varying NOT NULL,
    fee_flag character varying(255) DEFAULT '0'::character varying NOT NULL,
    originalwithamount character varying(255) DEFAULT '0'::character varying NOT NULL
);


ALTER TABLE public.user_withdraw_transaction OWNER TO nbcbanq;

--
-- Name: user_withdraw_transaction_withdraw_tra_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.user_withdraw_transaction_withdraw_tra_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_withdraw_transaction_withdraw_tra_id_seq OWNER TO nbcbanq;

--
-- Name: user_withdraw_transaction_withdraw_tra_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.user_withdraw_transaction_withdraw_tra_id_seq OWNED BY public.user_withdraw_transaction.withdraw_tra_id;


--
-- Name: usergroups; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.usergroups (
    group_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    group_name character varying(255),
    group_desc text,
    group_default public.usergroups_group_default_enum DEFAULT 'No'::public.usergroups_group_default_enum NOT NULL,
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_date timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.usergroups OWNER TO nbcbanq;

--
-- Name: usergroups_group_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.usergroups_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.usergroups_group_id_seq OWNER TO nbcbanq;

--
-- Name: usergroups_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.usergroups_group_id_seq OWNED BY public.usergroups.group_id;


--
-- Name: wallet_addresses; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.wallet_addresses (
    wallet_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    crypto_id_fk bigint DEFAULT '0'::bigint NOT NULL,
    wallet_address character varying(255),
    private_keys character varying(255),
    crypto_type character varying(255),
    lock character varying(255),
    created_datetime timestamp without time zone DEFAULT now(),
    created_ip character varying(255),
    modified_datetime timestamp without time zone DEFAULT now(),
    modified_ip character varying(255)
);


ALTER TABLE public.wallet_addresses OWNER TO nbcbanq;

--
-- Name: wallet_addresses_wallet_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.wallet_addresses_wallet_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.wallet_addresses_wallet_id_seq OWNER TO nbcbanq;

--
-- Name: wallet_addresses_wallet_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.wallet_addresses_wallet_id_seq OWNED BY public.wallet_addresses.wallet_id;


--
-- Name: webhook; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.webhook (
    webhook_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    jsondata text,
    created_datetime timestamp without time zone DEFAULT now()
);


ALTER TABLE public.webhook OWNER TO nbcbanq;

--
-- Name: webhook_webhook_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.webhook_webhook_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.webhook_webhook_id_seq OWNER TO nbcbanq;

--
-- Name: webhook_webhook_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.webhook_webhook_id_seq OWNED BY public.webhook.webhook_id;


--
-- Name: withdraw_address; Type: TABLE; Schema: public; Owner: nbcbanq
--

CREATE TABLE public.withdraw_address (
    withdraw_address_id bigint NOT NULL,
    company_id bigint DEFAULT '1'::bigint NOT NULL,
    user_id bigint DEFAULT '0'::bigint NOT NULL,
    crypto_wallet_id bigint DEFAULT '0'::bigint NOT NULL,
    account_id bigint DEFAULT '0'::bigint NOT NULL,
    wallet_address character varying(255),
    coin_code character varying(255),
    created_datetime timestamp without time zone DEFAULT now() NOT NULL,
    created_ip character varying(255)
);


ALTER TABLE public.withdraw_address OWNER TO nbcbanq;

--
-- Name: withdraw_address_withdraw_address_id_seq; Type: SEQUENCE; Schema: public; Owner: nbcbanq
--

CREATE SEQUENCE public.withdraw_address_withdraw_address_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.withdraw_address_withdraw_address_id_seq OWNER TO nbcbanq;

--
-- Name: withdraw_address_withdraw_address_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: nbcbanq
--

ALTER SEQUENCE public.withdraw_address_withdraw_address_id_seq OWNED BY public.withdraw_address.withdraw_address_id;


--
-- Name: admin admin_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.admin ALTER COLUMN admin_id_pk SET DEFAULT nextval('public.admin_admin_id_pk_seq'::regclass);


--
-- Name: admin_earn admin_earn_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.admin_earn ALTER COLUMN admin_earn_id SET DEFAULT nextval('public.admin_earn_admin_earn_id_seq'::regclass);


--
-- Name: admin_links link_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.admin_links ALTER COLUMN link_id SET DEFAULT nextval('public.admin_links_link_id_seq'::regclass);


--
-- Name: admincrypto_reward admin_reward_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.admincrypto_reward ALTER COLUMN admin_reward_id SET DEFAULT nextval('public.admincrypto_reward_admin_reward_id_seq'::regclass);


--
-- Name: adminfiat_reward admin_fiatreward_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.adminfiat_reward ALTER COLUMN admin_fiatreward_id SET DEFAULT nextval('public.adminfiat_reward_admin_fiatreward_id_seq'::regclass);


--
-- Name: apikey api_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.apikey ALTER COLUMN api_id SET DEFAULT nextval('public.apikey_api_id_seq'::regclass);


--
-- Name: authotp authotp_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.authotp ALTER COLUMN authotp_id SET DEFAULT nextval('public.authotp_authotp_id_seq'::regclass);


--
-- Name: autologout autologout_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.autologout ALTER COLUMN autologout_id SET DEFAULT nextval('public.autologout_autologout_id_seq'::regclass);


--
-- Name: banks bank_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.banks ALTER COLUMN bank_id SET DEFAULT nextval('public.banks_bank_id_seq'::regclass);


--
-- Name: blockadmin_ip adminipid; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.blockadmin_ip ALTER COLUMN adminipid SET DEFAULT nextval('public.blockadmin_ip_adminipid_seq'::regclass);


--
-- Name: blockedip ipid; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.blockedip ALTER COLUMN ipid SET DEFAULT nextval('public.blockedip_ipid_seq'::regclass);


--
-- Name: blockedipbroker ipid; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.blockedipbroker ALTER COLUMN ipid SET DEFAULT nextval('public.blockedipbroker_ipid_seq'::regclass);


--
-- Name: blockedipmanager ipid; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.blockedipmanager ALTER COLUMN ipid SET DEFAULT nextval('public.blockedipmanager_ipid_seq'::regclass);


--
-- Name: broker broker_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.broker ALTER COLUMN broker_id SET DEFAULT nextval('public.broker_broker_id_seq'::regclass);


--
-- Name: broker_address broker_address_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.broker_address ALTER COLUMN broker_address_id_pk SET DEFAULT nextval('public.broker_address_broker_address_id_pk_seq'::regclass);


--
-- Name: broker_contact contact_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.broker_contact ALTER COLUMN contact_id SET DEFAULT nextval('public.broker_contact_contact_id_seq'::regclass);


--
-- Name: broker_contact_order contact_order_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.broker_contact_order ALTER COLUMN contact_order_id SET DEFAULT nextval('public.broker_contact_order_contact_order_id_seq'::regclass);


--
-- Name: broker_earn broker_earn_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.broker_earn ALTER COLUMN broker_earn_id SET DEFAULT nextval('public.broker_earn_broker_earn_id_seq'::regclass);


--
-- Name: broker_feedback feedback_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.broker_feedback ALTER COLUMN feedback_id SET DEFAULT nextval('public.broker_feedback_feedback_id_seq'::regclass);


--
-- Name: broker_notification notification_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.broker_notification ALTER COLUMN notification_id SET DEFAULT nextval('public.broker_notification_notification_id_seq'::regclass);


--
-- Name: broker_withdraw_request broker_withdraw_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.broker_withdraw_request ALTER COLUMN broker_withdraw_id SET DEFAULT nextval('public.broker_withdraw_request_broker_withdraw_id_seq'::regclass);


--
-- Name: brokercrypto_reward broker_reward_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.brokercrypto_reward ALTER COLUMN broker_reward_id SET DEFAULT nextval('public.brokercrypto_reward_broker_reward_id_seq'::regclass);


--
-- Name: brokerfiat_reward broker_fiatreward_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.brokerfiat_reward ALTER COLUMN broker_fiatreward_id SET DEFAULT nextval('public.brokerfiat_reward_broker_fiatreward_id_seq'::regclass);


--
-- Name: card_information cardinfo_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.card_information ALTER COLUMN cardinfo_id SET DEFAULT nextval('public.card_information_cardinfo_id_seq'::regclass);


--
-- Name: card_limit cardlimit_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.card_limit ALTER COLUMN cardlimit_id SET DEFAULT nextval('public.card_limit_cardlimit_id_seq'::regclass);


--
-- Name: card_transaction cardtra_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.card_transaction ALTER COLUMN cardtra_id SET DEFAULT nextval('public.card_transaction_cardtra_id_seq'::regclass);


--
-- Name: card_type cardtype_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.card_type ALTER COLUMN cardtype_id SET DEFAULT nextval('public.card_type_cardtype_id_seq'::regclass);


--
-- Name: cardissue_transaction cardissue_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.cardissue_transaction ALTER COLUMN cardissue_id SET DEFAULT nextval('public.cardissue_transaction_cardissue_id_seq'::regclass);


--
-- Name: company company_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.company ALTER COLUMN company_id SET DEFAULT nextval('public.company_company_id_seq'::regclass);


--
-- Name: contact_us contact_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.contact_us ALTER COLUMN contact_id SET DEFAULT nextval('public.contact_us_contact_id_seq'::regclass);


--
-- Name: country country_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.country ALTER COLUMN country_id_pk SET DEFAULT nextval('public.country_country_id_pk_seq'::regclass);


--
-- Name: crypto_currancy crypto_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.crypto_currancy ALTER COLUMN crypto_id SET DEFAULT nextval('public.crypto_currancy_crypto_id_seq'::regclass);


--
-- Name: crypto_rates crypto_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.crypto_rates ALTER COLUMN crypto_id SET DEFAULT nextval('public.crypto_rates_crypto_id_seq'::regclass);


--
-- Name: cryptopair_rates pair_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.cryptopair_rates ALTER COLUMN pair_id SET DEFAULT nextval('public.cryptopair_rates_pair_id_seq'::regclass);


--
-- Name: customer_transaction_fees customer_tra_fee_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.customer_transaction_fees ALTER COLUMN customer_tra_fee_id SET DEFAULT nextval('public.customer_transaction_fees_customer_tra_fee_id_seq'::regclass);


--
-- Name: deliverypartner deliveryid; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.deliverypartner ALTER COLUMN deliveryid SET DEFAULT nextval('public.deliverypartner_deliveryid_seq'::regclass);


--
-- Name: deposit_address deposit_address_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.deposit_address ALTER COLUMN deposit_address_id SET DEFAULT nextval('public.deposit_address_deposit_address_id_seq'::regclass);


--
-- Name: document_type document_type_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.document_type ALTER COLUMN document_type_id SET DEFAULT nextval('public.document_type_document_type_id_seq'::regclass);


--
-- Name: email_formats email_format_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.email_formats ALTER COLUMN email_format_id_pk SET DEFAULT nextval('public.email_formats_email_format_id_pk_seq'::regclass);


--
-- Name: faq faq_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.faq ALTER COLUMN faq_id SET DEFAULT nextval('public.faq_faq_id_seq'::regclass);


--
-- Name: faq_category faq_cat_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.faq_category ALTER COLUMN faq_cat_id SET DEFAULT nextval('public.faq_category_faq_cat_id_seq'::regclass);


--
-- Name: fee_transaction_type fee_settings_type_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.fee_transaction_type ALTER COLUMN fee_settings_type_id SET DEFAULT nextval('public.fee_transaction_type_fee_settings_type_id_seq'::regclass);


--
-- Name: feedback feedback_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.feedback ALTER COLUMN feedback_id SET DEFAULT nextval('public.feedback_feedback_id_seq'::regclass);


--
-- Name: fees fees_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.fees ALTER COLUMN fees_id SET DEFAULT nextval('public.fees_fees_id_seq'::regclass);


--
-- Name: fees_group_settings fees_group_settings_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.fees_group_settings ALTER COLUMN fees_group_settings_id SET DEFAULT nextval('public.fees_group_settings_fees_group_settings_id_seq'::regclass);


--
-- Name: fees_multiplegroup fees_multiplegroup_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.fees_multiplegroup ALTER COLUMN fees_multiplegroup_id SET DEFAULT nextval('public.fees_multiplegroup_fees_multiplegroup_id_seq'::regclass);


--
-- Name: fees_range range_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.fees_range ALTER COLUMN range_id SET DEFAULT nextval('public.fees_range_range_id_seq'::regclass);


--
-- Name: fees_type_range_settings fees_type_range_settings_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.fees_type_range_settings ALTER COLUMN fees_type_range_settings_id SET DEFAULT nextval('public.fees_type_range_settings_fees_type_range_settings_id_seq'::regclass);


--
-- Name: fees_type_settings fees_type_settings_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.fees_type_settings ALTER COLUMN fees_type_settings_id SET DEFAULT nextval('public.fees_type_settings_fees_type_settings_id_seq'::regclass);


--
-- Name: fiat_currancy crypto_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.fiat_currancy ALTER COLUMN crypto_id SET DEFAULT nextval('public.fiat_currancy_crypto_id_seq'::regclass);


--
-- Name: inquiry inquiry_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.inquiry ALTER COLUMN inquiry_id SET DEFAULT nextval('public.inquiry_inquiry_id_seq'::regclass);


--
-- Name: language language_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.language ALTER COLUMN language_id_pk SET DEFAULT nextval('public.language_language_id_pk_seq'::regclass);


--
-- Name: limit_group_settings limit_group_settings_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.limit_group_settings ALTER COLUMN limit_group_settings_id SET DEFAULT nextval('public.limit_group_settings_limit_group_settings_id_seq'::regclass);


--
-- Name: limit_multiplegroup limit_multiplegroup_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.limit_multiplegroup ALTER COLUMN limit_multiplegroup_id SET DEFAULT nextval('public.limit_multiplegroup_limit_multiplegroup_id_seq'::regclass);


--
-- Name: limit_type_range_settings limit_type_range_settings_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.limit_type_range_settings ALTER COLUMN limit_type_range_settings_id SET DEFAULT nextval('public.limit_type_range_settings_limit_type_range_settings_id_seq'::regclass);


--
-- Name: limits limit_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.limits ALTER COLUMN limit_id SET DEFAULT nextval('public.limits_limit_id_seq'::regclass);


--
-- Name: login_logs login_log_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.login_logs ALTER COLUMN login_log_pk SET DEFAULT nextval('public.login_logs_login_log_pk_seq'::regclass);


--
-- Name: login_logs_admin login_log_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.login_logs_admin ALTER COLUMN login_log_pk SET DEFAULT nextval('public.login_logs_admin_login_log_pk_seq'::regclass);


--
-- Name: logosettings logo_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.logosettings ALTER COLUMN logo_id SET DEFAULT nextval('public.logosettings_logo_id_seq'::regclass);


--
-- Name: manager manager_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.manager ALTER COLUMN manager_id SET DEFAULT nextval('public.manager_manager_id_seq'::regclass);


--
-- Name: manager_address manager_address_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.manager_address ALTER COLUMN manager_address_id_pk SET DEFAULT nextval('public.manager_address_manager_address_id_pk_seq'::regclass);


--
-- Name: manager_earn manager_earn_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.manager_earn ALTER COLUMN manager_earn_id SET DEFAULT nextval('public.manager_earn_manager_earn_id_seq'::regclass);


--
-- Name: manager_feedback feedback_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.manager_feedback ALTER COLUMN feedback_id SET DEFAULT nextval('public.manager_feedback_feedback_id_seq'::regclass);


--
-- Name: manager_notification notification_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.manager_notification ALTER COLUMN notification_id SET DEFAULT nextval('public.manager_notification_notification_id_seq'::regclass);


--
-- Name: manager_withdraw mwithdraw_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.manager_withdraw ALTER COLUMN mwithdraw_id SET DEFAULT nextval('public.manager_withdraw_mwithdraw_id_seq'::regclass);


--
-- Name: manager_withdraw_request manager_withdraw_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.manager_withdraw_request ALTER COLUMN manager_withdraw_id SET DEFAULT nextval('public.manager_withdraw_request_manager_withdraw_id_seq'::regclass);


--
-- Name: managercrypto_reward manager_reward_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.managercrypto_reward ALTER COLUMN manager_reward_id SET DEFAULT nextval('public.managercrypto_reward_manager_reward_id_seq'::regclass);


--
-- Name: managerfiat_reward manager_fiatreward_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.managerfiat_reward ALTER COLUMN manager_fiatreward_id SET DEFAULT nextval('public.managerfiat_reward_manager_fiatreward_id_seq'::regclass);


--
-- Name: module_role module_role_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.module_role ALTER COLUMN module_role_id_pk SET DEFAULT nextval('public.module_role_module_role_id_pk_seq'::regclass);


--
-- Name: news news_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.news ALTER COLUMN news_id SET DEFAULT nextval('public.news_news_id_seq'::regclass);


--
-- Name: notification noti_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.notification ALTER COLUMN noti_id SET DEFAULT nextval('public.notification_noti_id_seq'::regclass);


--
-- Name: otherreq other_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.otherreq ALTER COLUMN other_id SET DEFAULT nextval('public.otherreq_other_id_seq'::regclass);


--
-- Name: pages page_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.pages ALTER COLUMN page_id_pk SET DEFAULT nextval('public.pages_page_id_pk_seq'::regclass);


--
-- Name: role role_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.role ALTER COLUMN role_id_pk SET DEFAULT nextval('public.role_role_id_pk_seq'::regclass);


--
-- Name: sem sem_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.sem ALTER COLUMN sem_id SET DEFAULT nextval('public.sem_sem_id_seq'::regclass);


--
-- Name: seo seo_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.seo ALTER COLUMN seo_id SET DEFAULT nextval('public.seo_seo_id_seq'::regclass);


--
-- Name: setting setting_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.setting ALTER COLUMN setting_id_pk SET DEFAULT nextval('public.setting_setting_id_pk_seq'::regclass);


--
-- Name: state id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.state ALTER COLUMN id SET DEFAULT nextval('public.state_id_seq'::regclass);


--
-- Name: taskmanager task_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.taskmanager ALTER COLUMN task_id SET DEFAULT nextval('public.taskmanager_task_id_seq'::regclass);


--
-- Name: themesettings theme_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.themesettings ALTER COLUMN theme_id SET DEFAULT nextval('public.themesettings_theme_id_seq'::regclass);


--
-- Name: timezone tid; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.timezone ALTER COLUMN tid SET DEFAULT nextval('public.timezone_tid_seq'::regclass);


--
-- Name: transaction_request transaction_request_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.transaction_request ALTER COLUMN transaction_request_id SET DEFAULT nextval('public.transaction_request_transaction_request_id_seq'::regclass);


--
-- Name: user user_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public."user" ALTER COLUMN user_id_pk SET DEFAULT nextval('public.user_user_id_pk_seq'::regclass);


--
-- Name: user_accounts account_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_accounts ALTER COLUMN account_id_pk SET DEFAULT nextval('public.user_accounts_account_id_pk_seq'::regclass);


--
-- Name: user_address user_address_id_pk; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_address ALTER COLUMN user_address_id_pk SET DEFAULT nextval('public.user_address_user_address_id_pk_seq'::regclass);


--
-- Name: user_cards card_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_cards ALTER COLUMN card_id SET DEFAULT nextval('public.user_cards_card_id_seq'::regclass);


--
-- Name: user_crypto_wallets crypto_wallet_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_crypto_wallets ALTER COLUMN crypto_wallet_id SET DEFAULT nextval('public.user_crypto_wallets_crypto_wallet_id_seq'::regclass);


--
-- Name: user_deposit_fund depositfund_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_deposit_fund ALTER COLUMN depositfund_id SET DEFAULT nextval('public.user_deposit_fund_depositfund_id_seq'::regclass);


--
-- Name: user_deposit_transaction deposit_tra_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_deposit_transaction ALTER COLUMN deposit_tra_id SET DEFAULT nextval('public.user_deposit_transaction_deposit_tra_id_seq'::regclass);


--
-- Name: user_document document_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_document ALTER COLUMN document_id SET DEFAULT nextval('public.user_document_document_id_seq'::regclass);


--
-- Name: user_emailnotification notification_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_emailnotification ALTER COLUMN notification_id SET DEFAULT nextval('public.user_emailnotification_notification_id_seq'::regclass);


--
-- Name: user_exchange_transaction exchange_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_exchange_transaction ALTER COLUMN exchange_id SET DEFAULT nextval('public.user_exchange_transaction_exchange_id_seq'::regclass);


--
-- Name: user_fiat_balancesheet balance_sheet_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_fiat_balancesheet ALTER COLUMN balance_sheet_id SET DEFAULT nextval('public.user_fiat_balancesheet_balance_sheet_id_seq'::regclass);


--
-- Name: user_fiat_depoist_transaction fiat_trans_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_fiat_depoist_transaction ALTER COLUMN fiat_trans_id SET DEFAULT nextval('public.user_fiat_depoist_transaction_fiat_trans_id_seq'::regclass);


--
-- Name: user_fiat_internal_transaction internal_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_fiat_internal_transaction ALTER COLUMN internal_id SET DEFAULT nextval('public.user_fiat_internal_transaction_internal_id_seq'::regclass);


--
-- Name: user_fiat_withdraw_transaction fiat_with_trans_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_fiat_withdraw_transaction ALTER COLUMN fiat_with_trans_id SET DEFAULT nextval('public.user_fiat_withdraw_transaction_fiat_with_trans_id_seq'::regclass);


--
-- Name: user_kyc kyc_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_kyc ALTER COLUMN kyc_id SET DEFAULT nextval('public.user_kyc_kyc_id_seq'::regclass);


--
-- Name: user_notification notification_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_notification ALTER COLUMN notification_id SET DEFAULT nextval('public.user_notification_notification_id_seq'::regclass);


--
-- Name: user_swap_transaction swap_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_swap_transaction ALTER COLUMN swap_id SET DEFAULT nextval('public.user_swap_transaction_swap_id_seq'::regclass);


--
-- Name: user_transfer transfer_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_transfer ALTER COLUMN transfer_id SET DEFAULT nextval('public.user_transfer_transfer_id_seq'::regclass);


--
-- Name: user_uploads upload_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_uploads ALTER COLUMN upload_id SET DEFAULT nextval('public.user_uploads_upload_id_seq'::regclass);


--
-- Name: user_withdraw_transaction withdraw_tra_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.user_withdraw_transaction ALTER COLUMN withdraw_tra_id SET DEFAULT nextval('public.user_withdraw_transaction_withdraw_tra_id_seq'::regclass);


--
-- Name: usergroups group_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.usergroups ALTER COLUMN group_id SET DEFAULT nextval('public.usergroups_group_id_seq'::regclass);


--
-- Name: wallet_addresses wallet_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.wallet_addresses ALTER COLUMN wallet_id SET DEFAULT nextval('public.wallet_addresses_wallet_id_seq'::regclass);


--
-- Name: webhook webhook_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.webhook ALTER COLUMN webhook_id SET DEFAULT nextval('public.webhook_webhook_id_seq'::regclass);


--
-- Name: withdraw_address withdraw_address_id; Type: DEFAULT; Schema: public; Owner: nbcbanq
--

ALTER TABLE ONLY public.withdraw_address ALTER COLUMN withdraw_address_id SET DEFAULT nextval('public.withdraw_address_withdraw_address_id_seq'::regclass);


--
-- Data for Name: admin; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.admin (admin_id_pk, company_id, first_name, last_name, email_id, temp_secret, image, admin_slug, contact_no, is_deleted, status, auth_status, google_auth_code, password, total_reward, created_date, created_ip, modified_date, modified_ip) FROM stdin;
1	1	chevy	Admin	chevy12@gmail.com	{"hex": "545e5e53216c63635268", "ascii": "T^^S!lccRh", "base32": "KRPF4UZBNRRWGUTI", "otpauth_url": "otpauth://totp/NBCBANQchevy12%40gmail.com?secret=KRPF4UZBNRRWGUTI"}	\N	Chevy	\N	No	Enable	Enabled	KRPF4UZBNRRWGUTI	$2b$12$KGN2IxblzDR/bZfAm48JlehCuXXzmeFxbARtmu/qk0gJBI6uirULi	2370.49	2022-12-24 09:53:00.372003	\N	2023-02-16 17:01:46.613	::ffff:31.4.159.149
\.


--
-- Data for Name: admin_earn; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.admin_earn (admin_earn_id, company_id, admin_id, transaction_id, customer_tra_fee_id, total_reward, fees_type, created_datetime, created_ip, crypto_type, crypto_id, coin_code) FROM stdin;
87	1	1	42	87	2.00	Percentage	2023-03-01 12:40:46.596	::ffff:49.34.163.6	Fiat	2	EUR
88	1	1	43	88	1.88	Percentage	2023-03-01 12:42:37.237	::ffff:49.34.163.6	Fiat	2	EUR
89	1	1	0	89	0.00	Percentage	2023-03-02 06:53:23.59	::ffff:49.36.90.138	Crypto	0	\N
90	1	1	30	90	17.08	Percentage	2023-03-02 10:09:12.519	::ffff:49.36.90.138	Crypto	0	\N
91	1	1	44	91	2.00	Percentage	2023-03-03 11:37:13.424	::ffff:49.34.241.27	Fiat	2	EUR
92	1	1	45	92	2.00	Percentage	2023-03-03 12:00:56.179	::ffff:49.34.241.27	Fiat	2	EUR
93	1	1	17	93	6.00	Percentage	2023-03-06 11:35:59.15	::ffff:157.32.1.92	Fiat	2	EUR
94	1	1	33	96	12.31	Percentage	2023-03-14 16:02:33.888	::ffff:151.38.145.55	Crypto	1	BTC
95	1	1	14	97	0.00	Percentage	2023-03-14 16:03:20.579	::ffff:151.38.145.55	Crypto	1	BTC
96	1	1	46	99	2.00	Percentage	2023-03-16 10:09:11.961	::ffff:49.34.148.127	Fiat	2	EUR
97	1	1	36	101	10.77	Percentage	2023-03-16 12:41:08.984	::ffff:49.36.82.82	Crypto	1	BTC
98	1	1	18	102	1.88	Percentage	2023-03-21 06:23:16.651	::ffff:49.36.80.252	Fiat	2	EUR
99	1	1	15	104	0.00	Percentage	2023-03-21 06:34:59.416	::ffff:49.36.80.252	Crypto	1	BTC
100	1	1	19	105	1.88	Percentage	2023-03-21 06:57:26.405	::ffff:49.36.80.252	Fiat	2	EUR
101	1	1	47	106	1.88	Percentage	2023-03-21 07:17:08.717	::ffff:49.36.80.252	Fiat	2	EUR
102	1	1	48	107	1.88	Percentage	2023-03-22 06:16:49.501	::ffff:219.91.190.140	Fiat	2	EUR
103	1	1	49	108	1.88	Percentage	2023-03-22 06:50:51.126	::ffff:219.91.190.140	Fiat	2	EUR
104	1	1	20	109	1.88	Percentage	2023-03-22 06:56:57.862	::ffff:219.91.190.140	Fiat	2	EUR
105	1	1	0	111	0.00	Percentage	2023-03-23 12:29:00.834	::ffff:49.34.41.230	Crypto	1	BTC
106	1	1	19	112	3.63	Percentage	2023-03-27 08:16:34.624	::ffff:123.201.68.135	Fiat	2	EUR
107	1	1	20	113	1.65	Percentage	2023-03-27 08:19:25.207	::ffff:123.201.68.135	Fiat	2	EUR
108	1	1	21	114	2.51	Percentage	2023-03-27 08:29:35.495	::ffff:123.201.68.135	Fiat	2	EUR
109	1	1	21	115	1.84	Percentage	2023-03-30 09:37:08.582	::ffff:195.10.99.99	Fiat	2	EUR
110	1	1	22	116	1.84	Percentage	2023-03-30 09:48:55.362	::ffff:195.10.99.99	Fiat	2	EUR
111	1	1	39	117	1.65	Percentage	2023-03-30 09:55:38.855	::ffff:195.10.99.99	Crypto	1	BTC
112	1	1	50	118	1.84	Percentage	2023-03-30 13:30:24.926	::ffff:5.90.205.48	Fiat	2	EUR
113	1	1	10	120	0.00	Percentage	2023-04-03 10:31:16.539	::ffff:157.32.15.176	Crypto	1	BTC
114	1	1	22	121	1.54	Percentage	2023-04-10 18:36:26.126	::ffff:49.34.170.235	Fiat	2	EUR
115	1	1	23	122	0.11	Percentage	2023-04-11 03:36:44.721	::ffff:49.34.179.163	Fiat	2	EUR
116	1	1	41	123	0.28	Percentage	2023-04-13 12:22:53.992	::ffff:103.176.10.40	Crypto	3	USDT
117	1	1	51	124	1.80	Percentage	2023-04-17 11:26:54.029	::ffff:49.34.173.228	Fiat	2	EUR
118	1	1	52	125	2.00	Percentage	2023-04-17 11:28:10.807	::ffff:49.34.173.228	Fiat	2	EUR
119	1	1	23	126	1.20	Percentage	2023-04-18 18:18:36.427	::ffff:152.58.38.131	Fiat	2	EUR
120	1	1	53	127	2.50	Percentage	2023-04-18 18:34:46.313	::ffff:152.58.38.131	Fiat	2	EUR
121	1	1	24	128	0.55	Percentage	2023-04-18 18:35:17.106	::ffff:152.58.38.131	Fiat	2	EUR
122	1	1	25	129	1.80	Percentage	2023-04-18 18:41:49.37	::ffff:152.58.38.131	Fiat	2	EUR
123	1	1	42	130	0.50	Percentage	2023-04-18 18:59:08.577	::ffff:152.58.38.131	Crypto	1	BTC
124	1	1	43	131	1.80	Percentage	2023-04-18 18:59:29.463	::ffff:152.58.38.131	Crypto	1	BTC
125	1	1	16	132	0.00	Percentage	2023-04-18 18:59:56.943	::ffff:152.58.38.131	Crypto	1	BTC
126	1	1	0	133	0.00	Percentage	2023-04-18 19:11:55.104	::ffff:152.58.38.131	Crypto	1	BTC
127	1	1	44	134	1.82	Percentage	2023-04-20 10:37:45.627	::ffff:88.12.14.229	Crypto	1	BTC
128	1	1	45	135	16.94	Percentage	2023-04-20 10:38:18.623	::ffff:88.12.14.229	Crypto	1	BTC
129	1	1	17	136	0.00	Percentage	2023-04-20 10:39:37.497	::ffff:88.12.14.229	Crypto	1	BTC
130	1	1	24	137	1.82	Percentage	2023-04-20 10:51:29.271	::ffff:88.12.14.229	Fiat	2	EUR
131	1	1	54	138	1.82	Percentage	2023-04-20 11:03:15.443	::ffff:88.12.14.229	Fiat	2	EUR
132	1	1	0	139	0.00	Percentage	2023-04-20 11:10:25.612	::ffff:88.12.14.229	Crypto	1	BTC
133	1	1	26	140	99.00	Percentage	2023-04-20 11:25:38.57	::ffff:88.12.14.229	Fiat	2	EUR
134	1	1	27	141	55.00	Percentage	2023-04-20 11:26:15.433	::ffff:88.12.14.229	Fiat	2	EUR
135	1	1	28	142	1.82	Percentage	2023-04-20 11:26:58.687	::ffff:88.12.14.229	Fiat	2	EUR
136	1	1	18	143	0.00	Percentage	2023-04-20 11:27:38.783	::ffff:88.12.14.229	Crypto	1	BTC
137	1	1	47	145	1.82	Percentage	2023-04-24 03:49:18.801	::ffff:223.185.85.71	Crypto	1	BTC
138	1	1	48	146	1.82	Percentage	2023-04-24 03:59:43.963	::ffff:223.185.85.71	Crypto	2	ETH
139	1	1	49	147	1.82	Percentage	2023-04-24 04:02:19.661	::ffff:223.185.85.71	Crypto	3	USDT
140	1	1	19	148	0.00	Percentage	2023-04-24 04:24:08.983	::ffff:223.196.170.96	Crypto	1	BTC
141	1	1	25	150	1.32	Percentage	2023-04-24 05:49:13.314	::ffff:223.185.85.71	Fiat	2	EUR
142	1	1	55	151	1.82	Percentage	2023-04-24 10:59:12.286	::ffff:223.196.171.248	Fiat	2	EUR
143	1	1	20	152	0.01	Percentage	2023-04-24 11:44:51.428	::ffff:223.196.172.230	Crypto	2	ETH
144	1	1	56	153	1.82	Percentage	2023-04-24 11:48:28.663	::ffff:223.196.173.219	Fiat	2	EUR
145	1	1	29	154	1.27	Percentage	2023-04-25 11:23:06.187	::ffff:106.217.234.137	Fiat	2	EUR
146	1	1	30	155	1.82	Percentage	2023-04-25 11:26:56.709	::ffff:106.217.234.137	Fiat	2	EUR
147	1	1	26	157	1.44	Percentage	2023-04-26 10:18:06.909	::ffff:106.195.64.221	Fiat	2	EUR
148	1	1	27	158	1.20	Percentage	2023-04-26 10:23:37.416	::ffff:106.195.64.221	Fiat	2	EUR
149	1	1	57	159	1.82	Percentage	2023-04-26 10:25:24.131	::ffff:106.195.64.221	Fiat	2	EUR
150	1	1	28	160	2.00	Percentage	2023-04-26 10:29:07.226	::ffff:223.196.172.222	Fiat	2	EUR
151	1	1	58	161	2.00	Percentage	2023-04-26 10:30:07.472	::ffff:223.196.172.222	Fiat	2	EUR
152	1	1	29	162	1.20	Percentage	2023-04-26 10:35:21.315	::ffff:223.196.172.245	Fiat	2	EUR
153	1	1	0	163	0.00	Percentage	2023-04-26 10:42:18.486	::ffff:223.196.173.155	Crypto	1	BTC
154	1	1	0	164	0.01	Percentage	2023-04-26 10:43:51	::ffff:223.196.174.147	Crypto	2	ETH
155	1	1	0	165	13.25	Percentage	2023-04-26 10:50:50.683	::ffff:223.196.172.212	Crypto	3	USDT
156	1	1	31	166	0.66	Percentage	2023-04-26 11:29:02.665	::ffff:223.196.169.162	Fiat	2	EUR
157	1	1	32	167	5.50	Percentage	2023-04-26 11:31:08.909	::ffff:223.196.172.245	Fiat	2	EUR
158	1	1	33	168	5.50	Percentage	2023-04-26 11:33:02.036	::ffff:223.196.174.147	Fiat	2	EUR
159	1	1	34	169	21.60	Percentage	2023-04-26 11:34:49.153	::ffff:223.196.174.147	Fiat	2	EUR
160	1	1	55	173	1.82	Percentage	2023-04-26 12:14:07.947	::ffff:223.196.172.212	Crypto	1	BTC
161	1	1	56	174	1.82	Percentage	2023-04-26 12:14:46.408	::ffff:223.196.172.212	Crypto	2	ETH
162	1	1	57	175	1.82	Percentage	2023-04-26 12:16:19.158	::ffff:223.196.174.147	Crypto	3	USDT
163	1	1	21	176	0.00	Percentage	2023-04-26 12:17:43.892	::ffff:223.196.173.155	Crypto	1	BTC
164	1	1	0	177	0.00	Percentage	2023-04-27 09:42:18.664	::ffff:223.196.173.155	Crypto	1	BTC
165	1	1	0	178	0.01	Percentage	2023-04-27 09:43:39.712	::ffff:223.196.172.245	Crypto	2	ETH
166	1	1	0	179	13.24	Percentage	2023-04-27 09:44:58.982	::ffff:223.196.172.245	Crypto	3	USDT
167	1	1	35	180	0.06	Percentage	2023-04-27 10:22:38.208	::ffff:223.196.169.160	Fiat	2	EUR
168	1	1	36	181	1.82	Percentage	2023-04-27 10:43:48.601	::ffff:223.196.172.216	Fiat	2	EUR
169	1	1	0	182	0.00	Percentage	2023-04-27 12:11:44.568	::ffff:106.195.79.166	Crypto	1	BTC
170	1	1	30	183	1.20	Percentage	2023-04-27 12:15:44.195	::ffff:106.195.79.166	Fiat	2	EUR
171	1	1	37	184	0.66	Percentage	2023-04-27 12:22:11.615	::ffff:106.195.79.166	Fiat	2	EUR
172	1	1	0	185	0.00	Percentage	2023-04-27 12:24:16.607	::ffff:106.195.79.166	Crypto	1	BTC
173	1	1	59	186	2.00	Percentage	2023-04-27 12:34:54.466	::ffff:106.195.79.166	Fiat	2	EUR
174	1	1	0	187	0.00	Percentage	2023-04-27 12:47:23.498	::ffff:106.195.79.166	Crypto	1	BTC
175	1	1	0	188	0.00	Percentage	2023-04-28 04:26:51.377	::ffff:106.195.64.11	Crypto	1	BTC
176	1	1	0	189	0.00	Percentage	2023-04-28 04:37:07.429	::ffff:106.195.64.11	Crypto	1	BTC
177	1	1	60	190	1.82	Percentage	2023-04-28 06:27:43.314	::ffff:106.195.64.11	Fiat	2	EUR
178	1	1	0	191	0.00	Percentage	2023-04-28 09:26:16.177	::ffff:106.195.77.176	Crypto	1	BTC
179	1	1	22	192	0.00	Percentage	2023-04-28 09:33:28.653	::ffff:106.195.77.176	Crypto	1	BTC
180	1	1	38	194	0.66	Percentage	2023-05-04 11:55:59.776	::ffff:223.196.174.73	Fiat	2	EUR
181	1	1	61	195	1.82	Percentage	2023-05-04 12:22:37.342	::ffff:223.196.171.252	Fiat	2	EUR
182	1	1	0	197	0.00	Percentage	2023-05-04 12:27:13.918	::ffff:223.196.171.252	Crypto	1	BTC
183	1	1	23	198	0.00	Percentage	2023-05-04 12:29:12.367	::ffff:223.196.170.96	Crypto	1	BTC
184	1	1	31	199	1.20	Percentage	2023-05-05 05:42:52.209	::ffff:223.196.174.143	Fiat	2	EUR
185	1	1	32	200	1.92	Percentage	2023-05-05 05:44:41.002	::ffff:106.195.64.191	Fiat	2	EUR
186	1	1	0	201	0.00	Percentage	2023-05-05 05:54:42.458	::ffff:106.195.64.191	Crypto	1	BTC
187	1	1	61	203	1.82	Percentage	2023-05-05 11:27:48.432	::ffff:223.196.170.89	Crypto	1	BTC
188	1	1	62	204	1.82	Percentage	2023-05-05 11:31:40.806	::ffff:223.196.174.74	Crypto	1	BTC
189	1	1	24	205	0.00	Percentage	2023-05-05 11:42:43.022	::ffff:223.196.174.74	Crypto	1	BTC
190	1	1	25	206	0.00	Percentage	2023-05-05 11:49:36.469	::ffff:223.196.172.149	Crypto	1	BTC
191	1	1	26	209	0.00	Percentage	2023-05-05 12:59:19.277	::ffff:106.195.74.61	Crypto	2	ETH
192	1	1	66	211	1.82	Percentage	2023-05-05 13:02:53.953	::ffff:106.195.74.61	Crypto	3	USDT
193	1	1	67	212	1.82	Percentage	2023-05-05 13:03:56.724	::ffff:106.195.74.61	Crypto	3	USDT
194	1	1	62	214	1.82	Percentage	2023-05-06 06:09:05.234	::ffff:223.196.171.239	Fiat	2	EUR
195	1	1	27	215	0.00	Percentage	2023-05-06 06:11:52.95	::ffff:223.196.174.143	Crypto	1	BTC
196	1	1	0	216	0.01	Percentage	2023-05-06 06:14:11.399	::ffff:223.196.172.207	Crypto	2	ETH
197	1	1	39	217	100.10	Percentage	2023-05-06 06:42:03.646	::ffff:223.196.172.233	Fiat	2	EUR
198	1	1	63	219	12.10	Percentage	2023-05-08 05:22:11.734	::ffff:223.196.170.79	Fiat	2	EUR
199	1	1	0	220	0.03	Percentage	2023-05-09 10:56:45.684	::1	Crypto	3	USDT
200	1	1	0	221	0.04	Percentage	2023-05-09 11:47:07.828	::ffff:223.196.171.246	Crypto	3	USDT
201	1	1	0	236	0.00	Percentage	2023-05-11 10:00:29.465	::ffff:223.196.169.174	Crypto	1	BTC
202	1	1	74	237	1.95	Percentage	2023-05-11 10:05:17.777	::ffff:103.176.11.167	Crypto	3	USDT
203	1	1	0	238	0.00	Percentage	2023-05-12 03:39:38.669	::ffff:223.196.169.158	Crypto	1	BTC
204	1	1	0	239	0.00	Percentage	2023-05-12 03:40:18.297	::ffff:223.196.171.251	Crypto	2	ETH
205	1	1	0	240	0.06	Percentage	2023-05-12 03:40:51.075	::ffff:223.196.171.251	Crypto	3	USDT
206	1	1	34	241	1.20	Percentage	2023-05-12 03:43:12.125	::ffff:223.196.171.251	Fiat	2	EUR
207	1	1	77	244	1.94	Percentage	2023-05-12 03:46:46.143	::ffff:106.195.71.214	Crypto	3	USDT
208	1	1	78	245	89.04	Percentage	2023-05-12 03:51:06.78	::ffff:106.195.71.214	Crypto	1	BTC
209	1	1	79	246	146.27	Percentage	2023-05-12 03:52:06.718	::ffff:106.195.71.214	Crypto	2	ETH
210	1	1	80	247	19.09	Percentage	2023-05-12 03:52:53.621	::ffff:106.195.71.214	Crypto	3	USDT
211	1	1	81	248	31.07	Percentage	2023-05-12 04:00:37.598	::ffff:106.195.71.214	Crypto	1	BTC
212	1	1	82	249	26.63	Percentage	2023-05-12 04:14:59.238	::ffff:223.196.172.233	Crypto	1	BTC
213	1	1	35	251	1.20	Percentage	2023-05-12 04:39:25.062	::ffff:223.196.174.74	Fiat	2	EUR
214	1	1	41	252	0.40	Percentage	2023-05-15 09:09:12.455	::ffff:223.196.170.91	Fiat	2	EUR
215	1	1	42	253	0.24	Percentage	2023-05-15 09:49:56.902	::ffff:223.196.172.213	Fiat	1	USD
216	1	1	70	256	41.20	Percentage	2023-06-09 09:25:27.204	::ffff:31.4.149.80	Fiat	1	USD
217	1	1	71	257	0.04	Percentage	2023-06-14 16:14:20.285	::ffff:5.90.203.88	Fiat	1	USD
218	1	1	72	259	2.00	Percentage	2023-06-26 13:12:17.747	::ffff:5.90.215.60	Fiat	1	USD
219	1	1	73	260	2.00	Percentage	2023-06-28 12:15:57.768	::ffff:37.159.73.101	Fiat	1	USD
220	1	1	74	261	2.00	Percentage	2023-06-28 13:30:48.14	::ffff:37.159.73.101	Fiat	1	USD
221	1	1	75	262	0.06	Percentage	2023-06-28 13:34:25.025	::ffff:95.74.44.16	Fiat	1	USD
222	1	1	29	264	0.00	Percentage	2023-07-07 14:02:09.219	::ffff:195.57.146.129	Crypto	1	BTC
223	1	1	91	269	181.50	Percentage	2023-07-20 04:50:39.98	::ffff:106.194.69.129	Crypto	1	BTC
\.


--
-- Data for Name: admin_links; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.admin_links (link_id, company_id, linkurl, created_datetime, created_ip) FROM stdin;
4	1	https://nbcbanq.app/estore?Broker=	2023-03-21 05:00:14.606	::ffff:49.34.39.202
5	1	https://capvano.com/refer	2023-04-02 15:31:56.916	::ffff:185.228.121.158
\.


--
-- Data for Name: admincrypto_reward; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.admincrypto_reward (admin_reward_id, company_id, admin_id_fk, user_id_fk, crypto_id_fk, coin_code, reward, created_datetime, created_ip) FROM stdin;
1	1	1	30	1	BTC	17.08	2023-03-02 06:53:23.593	::ffff:49.36.90.138
2	1	1	44	1	BTC	12.31	2023-03-14 16:02:33.892	::ffff:151.38.145.55
3	1	1	31	1	BTC	10.77	2023-03-16 12:41:08.988	::ffff:49.36.82.82
5	1	1	58	1	BTC	1.65	2023-03-30 09:55:38.863	::ffff:195.10.99.99
4	1	1	35	1	BTC	152.68	2023-03-23 12:29:00.838	::ffff:49.34.41.230
14	1	1	64	1	BTC	181.50	2023-07-20 04:50:39.985	::ffff:106.194.69.129
7	1	1	43	1	BTC	18.76	2023-04-20 10:37:45.639	::ffff:88.12.14.229
9	1	1	76	1	BTC	3.64	2023-05-05 11:27:48.439	::ffff:223.196.170.89
10	1	1	77	2	ETH	0.00	2023-05-05 12:59:19.282	::ffff:106.195.74.61
11	1	1	77	3	USDT	3.64	2023-05-05 13:02:53.959	::ffff:106.195.74.61
12	1	1	78	1	BTC	0.00	2023-05-06 06:11:52.954	::ffff:223.196.174.143
13	1	1	78	2	ETH	0.01	2023-05-06 06:14:11.405	::ffff:223.196.172.207
8	1	1	35	2	ETH	149.94	2023-04-24 03:59:43.968	::ffff:223.185.85.71
6	1	1	35	3	USDT	53.52	2023-04-13 12:22:54.003	::ffff:103.176.10.40
\.


--
-- Data for Name: adminfiat_reward; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.adminfiat_reward (admin_fiatreward_id, company_id, admin_id_fk, user_id_fk, fiat_id_fk, coin_code, reward, created_datetime, created_ip) FROM stdin;
7	1	1	35	1	USD	43.20	2023-05-15 09:49:56.905	::ffff:223.196.172.213
8	1	1	41	1	USD	43.20	2023-06-09 09:25:27.208	::ffff:31.4.149.80
2	1	1	31	2	EUR	45.20	2023-03-21 06:23:16.655	::ffff:49.36.80.252
9	1	1	99	1	USD	0.06	2023-06-28 13:34:25.028	::ffff:95.74.44.16
3	1	1	58	2	EUR	68.07	2023-03-30 09:37:08.588	::ffff:195.10.99.99
1	1	1	35	2	EUR	67.45	2023-03-01 12:40:46.599	::ffff:49.34.163.6
4	1	1	60	2	EUR	69.37	2023-03-30 13:30:24.931	::ffff:5.90.205.48
6	1	1	78	2	EUR	1.82	2023-05-06 06:09:05.241	::ffff:223.196.171.239
5	1	1	43	2	EUR	101.92	2023-04-20 10:51:29.28	::ffff:88.12.14.229
\.


--
-- Data for Name: apikey; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.apikey (api_id, company_id, api_key, secret_key, expire_date, manager_list, broker_list, customer_list, add_manager, add_broker, add_customer, is_deleted, created_datetime, created_ip, modified_datetime, modified_ip) FROM stdin;
\.


--
-- Data for Name: authotp; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.authotp (authotp_id, company_id, user_id, auth_title, auth_type, auth_status, created_datetime, created_ip) FROM stdin;
3	1	0	Crypto Exchange	Fiat Deposit	Authentication not required	2023-01-06 11:08:14.166647	\N
2	1	0	Internal Transfers	Internal Transfer	Google Authentication	2023-01-06 11:08:14.164958	\N
5	1	0	Crypto Transfer	Cypto Transfer	Google Authentication	2023-01-06 11:08:14.169518	\N
6	1	0	Crypto Buy	Buy	Google Authentication	2023-01-06 11:08:14.17135	\N
7	1	0	Crypto Sell	Sell	Google Authentication	2023-01-06 11:08:14.17287	\N
8	1	0	Crypto Swap	Swap	Google Authentication	2023-01-06 11:08:14.174157	\N
10	1	0	Account Card to Account Transfer	Accounttopup	SMS OTP Authentication	2023-02-01 18:21:25.538572	\N
9	1	0	Account Card Topup	Cardtopup	SMS OTP Authentication	2023-02-01 18:21:25.391594	\N
1	1	0	Outgoing wire transfers	Withdrawal	Google Authentication	2023-01-06 11:08:14.15618	\N
4	1	0	Crypto Withdrawal	Crypto Withdrawal	SMS OTP Authentication	2023-01-06 11:08:14.168116	\N
\.


--
-- Data for Name: autologout; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.autologout (autologout_id, company_id, autologouttime, attempts, persecond, message, padding, aftermessage, usertype, autologout, diffips, unblock) FROM stdin;
1	1	9000000	3	10	Your session is about to expired.	300000	You have been logged out due to inactivity.	User	Yes	No	136
2	1	9000000	3	10	Your session is about to expired.	300000	You have been logged out due to inactivity.	Broker	Yes	No	3
3	1	9000000	3	10	Your session is about to expired.	300000	You have been logged out due to inactivity.	Manager	Yes	No	140
4	1	9000000	3	10	Your session is about to expired.	300000	You have been logged out due to inactivity.	Admin	Yes	No	3
\.


--
-- Data for Name: banks; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.banks (bank_id, company_id, fiat_currancy_fk, account_number, routing_number, swift_code, bank_name, address, created_datetime, created_ip, modified_datetime, modified_ip) FROM stdin;
1	1	1	944847379384312	641003051367411	NB00614	d8kbb Bank	Carrer d'Albert, Ferrer i Soler, Vilanova i la Geltru - 08800, Barcelona, Spain	2023-02-23 12:03:48.75346	\N	2023-02-23 12:03:48.75346	\N
2	1	2	561368667608304	916364104036240	NB00988	mn0vv Bank	Carrer d'Albert, Ferrer i Soler, Vilanova i la Geltru - 08800, Barcelona, Spain	2023-02-23 12:03:48.896459	\N	2023-02-23 12:03:48.896459	\N
\.


--
-- Data for Name: blockadmin_ip; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.blockadmin_ip (adminipid, company_id, ipaddress, browser, os, country, created_datetime, created_ip) FROM stdin;
\.


--
-- Data for Name: blockedip; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.blockedip (ipid, company_id, ipaddress, created_datetime, created_ip, user_id_fk, counter, browser, os, country) FROM stdin;
25	1	152.58.38.37	2023-04-05 12:23:01.515	152.58.38.37	35	1	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/111.0	Linux	Netherlands
26	1	49.34.179.163	2023-04-11 09:58:01.691	49.34.179.163	35	1	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/111.0	Linux	Netherlands
9	1	157.32.1.92	2023-03-06 05:56:32.918	157.32.1.92	32	2	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/110.0	Linux	Netherlands
10	1	157.32.1.92	2023-03-06 05:57:02.034	157.32.1.92	35	2	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/110.0	Linux	Netherlands
11	1	103.240.204.8	2023-03-14 06:02:50.944	103.240.204.8	35	1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36	Windows 10	Netherlands
12	1	152.58.36.77	2023-03-14 13:59:30.256	152.58.36.77	35	1	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/110.0	Linux	Netherlands
13	1	151.38.145.55	2023-03-14 14:00:30.687	151.38.145.55	36	2	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/110.0.0.0 Safari/537.36	Windows 10	Netherlands
27	1	66.74.204.235	2023-04-23 04:01:31.393	66.74.204.235	69	1	Mozilla/5.0 (iPhone; CPU iPhone OS 16_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148	iOS	Netherlands
14	1	164.68.142.104	2023-03-16 21:15:33.598	164.68.142.104	44	3	Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.3 Safari/605.1.15	Mac OS	Netherlands
15	1	152.58.39.97	2023-03-17 11:35:00.261	152.58.39.97	35	1	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/111.0	Linux	Netherlands
16	1	209.198.137.142	2023-03-22 20:43:30.493	209.198.137.142	44	2	Mozilla/5.0 (iPhone; CPU iPhone OS 16_3_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.3 Mobile/15E148 Safari/604.1	iOS	Netherlands
17	1	123.201.65.29	2023-03-24 05:12:01.118	123.201.65.29	35	1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands
18	1	152.58.38.10	2023-03-27 04:26:00.662	152.58.38.10	35	2	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/111.0	Linux	Netherlands
28	1	106.195.64.11	2023-04-28 04:24:33.107	106.195.64.11	35	1	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0	Windows 10	Netherlands
19	1	42.105.162.209	2023-03-29 19:08:07.081	42.105.162.209	35	3	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands
20	1	90.161.226.107	2023-03-30 16:11:48.602	90.161.226.107	60	1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands
21	1	103.247.54.245	2023-04-03 04:07:49.121	103.247.54.245	36	3	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands
29	1	106.195.64.11	2023-04-28 06:53:39.955	106.195.64.11	32	2	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0	Windows 10	Netherlands
22	1	157.32.15.176	2023-04-03 10:26:24.703	157.32.15.176	36	3	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/111.0	Linux	Netherlands
23	1	157.32.23.113	2023-04-04 11:08:36.393	157.32.23.113	35	1	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/111.0	Linux	Netherlands
24	1	103.247.54.241	2023-04-05 06:02:53.948	103.247.54.241	35	3	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands
30	1	103.249.234.5	2023-05-03 07:08:56.266	103.249.234.5	35	2	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36	Windows 10	Netherlands
31	1	223.196.169.158	2023-05-11 08:33:00.152	223.196.169.158	35	1	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0	Windows 10	Netherlands
32	1	152.58.35.127	2023-05-11 08:42:30.648	152.58.35.127	35	1	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/113.0	Linux	Netherlands
33	1	46.8.175.43	2023-05-12 16:13:07.656	46.8.175.43	41	1	Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148	iOS	Netherlands
34	1	155.133.11.38	2023-05-13 13:49:03.21	155.133.11.38	35	1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/113.0.0.0 Safari/537.36	Windows 10	Netherlands
35	1	223.196.172.234	2023-05-15 08:45:30.179	223.196.172.234	35	1	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/113.0	Windows 10	Netherlands
36	1	151.68.89.79	2023-06-01 13:09:06.489	151.68.89.79	44	1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36	Windows 10	Netherlands
39	1	136.226.233.28	2023-06-27 09:44:48.941	136.226.233.28	34	1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36	Windows 10	Netherlands
37	1	151.68.89.79	2023-06-01 13:10:37.65	151.68.89.79	35	3	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36	Windows 10	Netherlands
38	1	178.139.172.154	2023-06-07 11:41:30.391	178.139.172.154	41	1	Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.4 Safari/605.1.15	Mac OS	Netherlands
40	1	82.48.153.26	2023-06-29 09:16:01.951	82.48.153.26	99	1	Mozilla/5.0 (iPhone; CPU iPhone OS 16_5_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148	iOS	Netherlands
41	1	5.90.200.187	2023-07-07 14:37:01.085	5.90.200.187	41	1	Mozilla/5.0 (iPhone; CPU iPhone OS 16_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148	iOS	Netherlands
\.


--
-- Data for Name: blockedipbroker; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.blockedipbroker (ipid, company_id, user_id_fk, counter, ipaddress, browser, os, country, created_datetime, created_ip) FROM stdin;
1	1	11	2	49.36.80.80	Chrome	Windows 10	Netherlands	2023-03-15 11:15:19.293	49.36.80.80
2	1	11	1	123.201.65.29	Chrome	Windows 10	Netherlands	2023-03-24 11:46:34.657	123.201.65.29
3	1	12	3	103.247.54.245	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands	2023-03-31 03:11:05.463	103.247.54.245
4	1	11	3	103.247.54.245	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands	2023-03-31 04:24:09.634	103.247.54.245
5	1	11	1	106.195.64.143	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0	Windows 10	Netherlands	2023-04-29 03:34:51.833	106.195.64.143
6	1	11	1	103.247.54.249	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36	Windows 10	Netherlands	2023-05-03 07:17:40.489	103.247.54.249
7	1	11	1	223.196.169.161	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36	Windows 10	Netherlands	2023-05-05 09:23:07.648	223.196.169.161
8	1	17	1	223.196.172.212	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0	Windows 10	Netherlands	2023-05-10 04:58:10.002	223.196.172.212
9	1	11	1	223.196.171.242	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/113.0	Windows 10	Netherlands	2023-05-15 08:50:30.377	223.196.171.242
\.


--
-- Data for Name: blockedipmanager; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.blockedipmanager (ipid, company_id, user_id_fk, counter, ipaddress, browser, os, country, created_datetime, created_ip) FROM stdin;
1	1	8	1	49.34.215.224	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/110.0	Linux	Netherlands	2023-02-23 10:08:37.966	49.34.215.224
3	1	10	1	49.34.215.224	Mozilla/5.0 (X11; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/110.0	Linux	Netherlands	2023-02-23 12:48:00.124	49.34.215.224
4	1	8	2	151.38.145.55	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands	2023-03-14 14:56:31.928	151.38.145.55
5	1	8	1	164.68.142.104	Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.3 Safari/605.1.15	Mac OS	Netherlands	2023-03-16 22:17:08.134	164.68.142.104
6	1	8	2	123.201.68.34	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands	2023-03-23 06:36:26.096	123.201.68.34
7	1	8	1	103.247.54.231	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands	2023-03-27 10:51:58.491	103.247.54.231
8	1	8	1	103.247.54.245	Mozilla/5.0 (Linux; Android 12; RMX2117) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Mobile Safari/537.36	Android OS	Netherlands	2023-03-31 11:05:06.796	103.247.54.245
9	1	8	1	103.250.137.76	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands	2023-04-03 05:12:07.28	103.250.137.76
10	1	10	1	103.247.54.245	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36	Windows 10	Netherlands	2023-04-03 05:12:23.268	103.247.54.245
11	1	8	1	223.196.172.214	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0	Windows 10	Netherlands	2023-05-03 09:09:23.279	223.196.172.214
12	1	8	1	223.196.173.223	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/112.0	Windows 10	Netherlands	2023-05-04 08:46:28.246	223.196.173.223
13	1	8	1	223.196.169.172	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/113.0	Windows 10	Netherlands	2023-05-15 04:25:41.677	223.196.169.172
\.


--
-- Data for Name: broker; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.broker (broker_id, company_id, country_id, manager_id, user_id, lang_id, first_name, last_name, email_id, total_reward, phone_number, password, status, auth_status, google_auth_code, temp_secret, is_deleted, profile_photo, email_ref_code, timezone, country_code, ref_code, admin_approve_status, created_datetime, created_ip, modified_date, modified_ip, sessionip) FROM stdin;
14	1	101	1	38	1	Ashok	Doctor	doctientcare@gmail.com	0.00	3022003785	$2b$12$vQacTuH6nW5q7hF/4CQuoO6XaLFkam7lWtylJ/O987XWhEbIzWgNO	Enable	Disabled	G4QSUWSDO4RTGRDG	{"hex": "37212a5a437723334466", "ascii": "7!*ZCw#3Df", "base32": "G4QSUWSDO4RTGRDG", "otpauth_url": "otpauth://totp/NBCBANQ%20(doctientcare%40gmail.com)?secret=G4QSUWSDO4RTGRDG"}	No	\N	\N	\N	1	ASH29949DOC	Approved	2023-02-24 09:50:04.832	::ffff:49.36.83.222	2023-03-21 07:53:52.616	::ffff:49.36.80.252	\N
13	1	101	1	37	1	Ashok	Rathod	mxicoders@gmail.com	0.00	+13022003785	$2b$12$Xn4L2dvIkgcQWyXiV1AIO.HP79UpbfkIzNtqhPZ1cTro2GDl/xiUS	Enable	Disabled	MJJCKYKKHBEGERJE	{"hex": "625225614a3848624524", "ascii": "bR%aJ8HbE$", "base32": "MJJCKYKKHBEGERJE", "otpauth_url": "otpauth://totp/NBCBANQ%20(mxicoders%40gmail.com)?secret=MJJCKYKKHBEGERJE"}	No	\N	\N	\N	1	ASH48051RAT	Approved	2023-02-24 09:31:57.39	::ffff:49.36.83.222	2023-03-15 10:17:46.532	::ffff:49.36.80.80	\N
12	1	205	8	33	1	Oretta	Giuliani	orettanbcbroker@yopmail.com	0.00	10393461	$2b$12$2Fda4pZ74D1VcAs9QiW6.ObYXGGAdPZuQMMkDh4te4TVpqMDN.eta	Enable	Enabled	G4YVOWSGJ54XSQRY	{"hex": "6b4e4d783a434d373f35", "ascii": "kNMx:CM7?5", "base32": "NNHE26B2INGTOPZV", "otpauth_url": "otpauth://totp/NBCBANQ%20(orettanbcbroker%40yopmail.com)?secret=NNHE26B2INGTOPZV"}	No	\N	\N	\N	34	ORE11410GIU	Approved	2023-02-23 12:28:17.544	::ffff:49.34.215.224	2023-03-25 14:54:27.617	::ffff:151.57.71.252	103.247.54.245
18	1	1	0	81	1	Givil	Andrew	givil49986@andorem.com	0.00	98484848484	$2b$12$sXEfWQfpKXUABRYeJfWXF.igzguZVyEsP.jJFQA5la9QVoM0Ihd.2	Enable	Enabled	KFLE6STPMMVGYTS2	{"hex": "51564f4a6f632a6c4e5a", "ascii": "QVOJoc*lNZ", "base32": "KFLE6STPMMVGYTS2", "otpauth_url": "otpauth://totp/NBCBANQ%20(givil49986%40andorem.com)?secret=KFLE6STPMMVGYTS2"}	No	\N	\N	\N	1	GIV87953AND	Pending	2023-05-10 06:40:12.729	::ffff:223.196.174.143	2023-05-10 06:40:12.729893	\N	223.196.172.150
19	1	38	0	82	1	Fomary	Glow	fomary@finews.biz	0.00	988484848	$2b$12$TYWY6VSEDi4CToXQ9BexFOg4y55SjCGs4ZqV.yefXD0Lfgvup7sSm	Enable	Disabled	HRCFEYZSMVYFILCM	{"hex": "3c445263326570542c4c", "ascii": "<DRc2epT,L", "base32": "HRCFEYZSMVYFILCM", "otpauth_url": "otpauth://totp/NBCBANQ%20(fomary%40finews.biz)?secret=HRCFEYZSMVYFILCM"}	No	\N	\N	\N	34	FOM56681GLO	Pending	2023-05-10 07:03:21.073	::ffff:223.196.172.150	2023-05-10 07:03:21.073836	\N	\N
16	1	34	10	35	1	Yagoo	Zamora	yagozamora@yopmail.com	0.00	938932183	$2b$12$6PVJl5gp7Ic6EfdCjlmlFeWmitrBapN/S3sCn/WtjqqzGLEwzzi0a	Enable	Disabled	OJVVGRDBHZRDGV32	{"hex": "5b6b30515b3c55695426", "ascii": "[k0Q[<UiT&", "base32": "LNVTAUK3HRKWSVBG", "otpauth_url": "otpauth://totp/NBCBANQ%20(yagozamora%40yopmail.com)?secret=LNVTAUK3HRKWSVBG"}	No	\N	\N	\N	34	YAG43897ZAM	Pending	2023-05-10 04:04:43.637	::ffff:223.196.174.143	2023-05-10 04:04:43.638108	\N	\N
20	1	205	8	83	1	Nyjelefo	Afia	nyjelefo@afia.pro	0.00	1222222	$2b$12$NDt.JakxP3p02Yd.ZT4RweeBW7HYHnIsumB24zYz1skfa82zr09Ne	Enable	Disabled	MFZSMSKAFBKEKZKJ	{"hex": "61732649402854456549", "ascii": "as&I@(TEeI", "base32": "MFZSMSKAFBKEKZKJ", "otpauth_url": "otpauth://totp/NBCBANQ%20(nyjelefo%40afia.pro)?secret=MFZSMSKAFBKEKZKJ"}	No	\N	\N	\N	34	NYJ98854AFI	Approved	2023-05-10 07:16:19.009	::ffff:223.196.170.80	2023-05-10 09:30:43.673	::ffff:223.196.172.244	\N
17	1	91	0	79	1	Nnn	NNN	sininis605@aicogz.com	0.00	11111111	$2b$12$acxBjVCs.m7q5PBV/zSEiux/pX1wQ3UAgSQm64H.ArCzCtLy0AD.e	Enable	Enabled	N5IXSZRVN5RE66BZ	{"hex": "6f517966356f624f7839", "ascii": "oQyf5obOx9", "base32": "N5IXSZRVN5RE66BZ", "otpauth_url": "otpauth://totp/NBCBANQ%20(sininis605%40aicogz.com)?secret=N5IXSZRVN5RE66BZ"}	No	\N	\N	\N	91	NNN19361NNN	Pending	2023-05-10 04:09:50.407	::ffff:223.196.170.80	2023-05-10 04:09:50.408583	\N	223.196.172.150
11	1	205	8	32	1	Javier	Arreola	javiernbcbroker@yopmail.com	0.00	937678612	$2b$12$PRLsOmwUe4ySXkQZDajtk.q9UYnD5icRS7uDdUAZJgmqHA4QQjGru	Enable	Enabled	KRKEMPRBFR3DGVBQ	{"hex": "7536383a77613f363a56", "ascii": "u68:wa?6:V", "base32": "OU3DQOTXME7TMOSW", "otpauth_url": "otpauth://totp/NBCBANQ%20(javiernbcbroker%40yopmail.com)?secret=OU3DQOTXME7TMOSW"}	No	\N	\N	49	34	JAV22424ARR	Approved	2023-02-23 12:16:00.041	::ffff:49.34.215.224	2023-03-16 11:14:19.873	::ffff:49.36.82.82	223.196.170.91
\.


--
-- Data for Name: broker_address; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.broker_address (broker_address_id_pk, company_id, broker_id, country_id, state_id, address_line1, address_line2, city, zipcode, is_default, created_datetime, created_ip, modified_datetime, modified_ip) FROM stdin;
3	1	11	101	2	na	na	na	rrrere	No	2023-04-29 07:59:40.645	::ffff:223.196.172.247	2023-04-29 07:59:40.645902	\N
\.


--
-- Data for Name: broker_contact; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.broker_contact (contact_id, company_id, item_id, broker_id_fk, name, email, phone, address, city, state, zip, country, "companyName", fulljson, created_datetime, created_ip) FROM stdin;
\.


--
-- Data for Name: broker_contact_order; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.broker_contact_order (contact_order_id, company_id, contact_id_fk, item_id, broker_id_fk, "memberId", token, "invoiceNo", "customerName", "customerEmail", "billingAddress", "shippingAddress", "shippingRequired", weight, "weightUnit", "subTotal", total, "discountCode", "discountType", "transactionId", "shippingAmount", "shippingName", paid, "paymentMethod", status, "discountAmount", taxes, items, currency, fulljson, created_datetime, created_ip) FROM stdin;
\.


--
-- Data for Name: broker_earn; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.broker_earn (broker_earn_id, company_id, broker_id, transaction_id, customer_tra_fee_id, total_reward, fees, fees_percentage, created_datetime, created_ip, crypto_type, crypto_id, coin_code) FROM stdin;
45	1	11	42	87	2.00	0.40	20.00	2023-03-01 12:40:46.588	::ffff:49.34.163.6	Fiat	2	EUR
46	1	11	43	88	1.88	0.38	20.00	2023-03-01 12:42:37.23	::ffff:49.34.163.6	Fiat	2	EUR
47	1	11	44	91	2.00	0.40	20.00	2023-03-03 11:37:13.415	::ffff:49.34.241.27	Fiat	2	EUR
48	1	11	45	92	2.00	0.40	20.00	2023-03-03 12:00:56.169	::ffff:49.34.241.27	Fiat	2	EUR
49	1	11	17	93	6.00	1.20	20.00	2023-03-06 11:35:59.14	::ffff:157.32.1.92	Fiat	2	EUR
50	1	11	33	96	12.31	2.46	20.00	2023-03-14 16:02:33.879	::ffff:151.38.145.55	Crypto	1	BTC
51	1	11	14	97	0.00	0.00	20.00	2023-03-14 16:03:20.569	::ffff:151.38.145.55	Crypto	1	BTC
52	1	11	46	99	2.00	0.40	20.00	2023-03-16 10:09:11.952	::ffff:49.34.148.127	Fiat	2	EUR
53	1	11	48	107	1.88	0.38	20.00	2023-03-22 06:16:49.489	::ffff:219.91.190.140	Fiat	2	EUR
54	1	11	49	108	1.88	0.38	20.00	2023-03-22 06:50:51.116	::ffff:219.91.190.140	Fiat	2	EUR
55	1	11	20	109	1.88	0.38	20.00	2023-03-22 06:56:57.854	::ffff:219.91.190.140	Fiat	2	EUR
56	1	11	0	111	0.00	0.00	20.00	2023-03-23 12:29:00.826	::ffff:49.34.41.230	Crypto	1	BTC
57	1	11	19	112	3.63	0.73	20.00	2023-03-27 08:16:34.611	::ffff:123.201.68.135	Fiat	2	EUR
58	1	11	20	113	1.65	0.33	20.00	2023-03-27 08:19:25.196	::ffff:123.201.68.135	Fiat	2	EUR
59	1	11	21	114	2.51	0.50	20.00	2023-03-27 08:29:35.486	::ffff:123.201.68.135	Fiat	2	EUR
60	1	11	10	120	0.00	0.00	20.00	2023-04-03 10:31:16.496	::ffff:157.32.15.176	Crypto	1	BTC
61	1	11	22	121	1.54	0.31	20.00	2023-04-10 18:36:26.101	::ffff:49.34.170.235	Fiat	2	EUR
62	1	11	23	122	0.11	0.02	20.00	2023-04-11 03:36:44.704	::ffff:49.34.179.163	Fiat	2	EUR
63	1	11	41	123	0.28	0.06	20.00	2023-04-13 12:22:53.975	::ffff:103.176.10.40	Crypto	3	USDT
64	1	11	51	124	1.80	0.36	20.00	2023-04-17 11:26:53.997	::ffff:49.34.173.228	Fiat	2	EUR
65	1	11	52	125	2.00	0.40	20.00	2023-04-17 11:28:10.79	::ffff:49.34.173.228	Fiat	2	EUR
66	1	11	23	126	1.20	0.24	20.00	2023-04-18 18:18:36.412	::ffff:152.58.38.131	Fiat	2	EUR
67	1	11	53	127	2.50	0.50	20.00	2023-04-18 18:34:46.287	::ffff:152.58.38.131	Fiat	2	EUR
68	1	11	24	128	0.55	0.11	20.00	2023-04-18 18:35:17.078	::ffff:152.58.38.131	Fiat	2	EUR
69	1	11	25	129	1.80	0.36	20.00	2023-04-18 18:41:49.355	::ffff:152.58.38.131	Fiat	2	EUR
70	1	11	42	130	0.50	0.10	20.00	2023-04-18 18:59:08.55	::ffff:152.58.38.131	Crypto	1	BTC
71	1	11	43	131	1.80	0.36	20.00	2023-04-18 18:59:29.446	::ffff:152.58.38.131	Crypto	1	BTC
72	1	11	16	132	0.00	0.00	20.00	2023-04-18 18:59:56.929	::ffff:152.58.38.131	Crypto	1	BTC
73	1	11	0	133	0.00	0.00	20.00	2023-04-18 19:11:55.093	::ffff:152.58.38.131	Crypto	1	BTC
74	1	11	44	134	1.82	0.36	20.00	2023-04-20 10:37:45.604	::ffff:88.12.14.229	Crypto	1	BTC
75	1	11	45	135	16.94	3.39	20.00	2023-04-20 10:38:18.598	::ffff:88.12.14.229	Crypto	1	BTC
76	1	11	17	136	0.00	0.00	20.00	2023-04-20 10:39:37.475	::ffff:88.12.14.229	Crypto	1	BTC
77	1	11	24	137	1.82	0.36	20.00	2023-04-20 10:51:29.256	::ffff:88.12.14.229	Fiat	2	EUR
78	1	11	54	138	1.82	0.36	20.00	2023-04-20 11:03:15.426	::ffff:88.12.14.229	Fiat	2	EUR
79	1	11	0	139	0.00	0.00	20.00	2023-04-20 11:10:25.589	::ffff:88.12.14.229	Crypto	1	BTC
80	1	11	26	140	99.00	19.80	20.00	2023-04-20 11:25:38.558	::ffff:88.12.14.229	Fiat	2	EUR
81	1	11	27	141	55.00	11.00	20.00	2023-04-20 11:26:15.416	::ffff:88.12.14.229	Fiat	2	EUR
82	1	11	28	142	1.82	0.36	20.00	2023-04-20 11:26:58.671	::ffff:88.12.14.229	Fiat	2	EUR
83	1	11	18	143	0.00	0.00	20.00	2023-04-20 11:27:38.77	::ffff:88.12.14.229	Crypto	1	BTC
84	1	11	47	145	1.82	0.36	20.00	2023-04-24 03:49:18.79	::ffff:223.185.85.71	Crypto	1	BTC
85	1	11	48	146	1.82	0.36	20.00	2023-04-24 03:59:43.953	::ffff:223.185.85.71	Crypto	2	ETH
86	1	11	49	147	1.82	0.36	20.00	2023-04-24 04:02:19.648	::ffff:223.185.85.71	Crypto	3	USDT
87	1	11	19	148	0.00	0.00	20.00	2023-04-24 04:24:08.97	::ffff:223.196.170.96	Crypto	1	BTC
88	1	11	25	150	1.32	0.26	20.00	2023-04-24 05:49:13.302	::ffff:223.185.85.71	Fiat	2	EUR
89	1	11	55	151	1.82	0.36	20.00	2023-04-24 10:59:12.274	::ffff:223.196.171.248	Fiat	2	EUR
90	1	11	20	152	0.01	0.00	20.00	2023-04-24 11:44:51.417	::ffff:223.196.172.230	Crypto	2	ETH
91	1	11	56	153	1.82	0.36	20.00	2023-04-24 11:48:28.652	::ffff:223.196.173.219	Fiat	2	EUR
92	1	11	29	154	1.27	0.25	20.00	2023-04-25 11:23:06.173	::ffff:106.217.234.137	Fiat	2	EUR
93	1	11	30	155	1.82	0.36	20.00	2023-04-25 11:26:56.699	::ffff:106.217.234.137	Fiat	2	EUR
94	1	11	26	157	1.44	0.29	20.00	2023-04-26 10:18:06.891	::ffff:106.195.64.221	Fiat	2	EUR
95	1	11	27	158	1.20	0.24	20.00	2023-04-26 10:23:37.404	::ffff:106.195.64.221	Fiat	2	EUR
96	1	11	57	159	1.82	0.36	20.00	2023-04-26 10:25:24.122	::ffff:106.195.64.221	Fiat	2	EUR
97	1	11	28	160	2.00	0.40	20.00	2023-04-26 10:29:07.213	::ffff:223.196.172.222	Fiat	2	EUR
98	1	11	58	161	2.00	0.40	20.00	2023-04-26 10:30:07.461	::ffff:223.196.172.222	Fiat	2	EUR
99	1	11	29	162	1.20	0.24	20.00	2023-04-26 10:35:21.305	::ffff:223.196.172.245	Fiat	2	EUR
100	1	11	0	163	0.00	0.00	20.00	2023-04-26 10:42:18.464	::ffff:223.196.173.155	Crypto	1	BTC
101	1	11	0	164	0.01	0.00	20.00	2023-04-26 10:43:50.99	::ffff:223.196.174.147	Crypto	2	ETH
102	1	11	0	165	13.25	2.65	20.00	2023-04-26 10:50:50.67	::ffff:223.196.172.212	Crypto	3	USDT
103	1	11	31	166	0.66	0.13	20.00	2023-04-26 11:29:02.653	::ffff:223.196.169.162	Fiat	2	EUR
104	1	11	32	167	5.50	1.10	20.00	2023-04-26 11:31:08.889	::ffff:223.196.172.245	Fiat	2	EUR
105	1	11	33	168	5.50	1.10	20.00	2023-04-26 11:33:02.016	::ffff:223.196.174.147	Fiat	2	EUR
106	1	11	34	169	21.60	4.32	20.00	2023-04-26 11:34:49.14	::ffff:223.196.174.147	Fiat	2	EUR
107	1	11	55	173	1.82	0.36	20.00	2023-04-26 12:14:07.934	::ffff:223.196.172.212	Crypto	1	BTC
108	1	11	56	174	1.82	0.36	20.00	2023-04-26 12:14:46.387	::ffff:223.196.172.212	Crypto	2	ETH
109	1	11	57	175	1.82	0.36	20.00	2023-04-26 12:16:19.143	::ffff:223.196.174.147	Crypto	3	USDT
110	1	11	21	176	0.00	0.00	20.00	2023-04-26 12:17:43.879	::ffff:223.196.173.155	Crypto	1	BTC
111	1	11	0	177	0.00	0.00	20.00	2023-04-27 09:42:18.648	::ffff:223.196.173.155	Crypto	1	BTC
112	1	11	0	178	0.01	0.00	20.00	2023-04-27 09:43:39.703	::ffff:223.196.172.245	Crypto	2	ETH
113	1	11	0	179	13.24	2.65	20.00	2023-04-27 09:44:58.973	::ffff:223.196.172.245	Crypto	3	USDT
114	1	11	35	180	0.06	0.01	20.00	2023-04-27 10:22:38.186	::ffff:223.196.169.160	Fiat	2	EUR
115	1	11	36	181	1.82	0.36	20.00	2023-04-27 10:43:48.587	::ffff:223.196.172.216	Fiat	2	EUR
116	1	11	0	182	0.00	0.00	20.00	2023-04-27 12:11:44.556	::ffff:106.195.79.166	Crypto	1	BTC
117	1	11	30	183	1.20	0.24	20.00	2023-04-27 12:15:44.18	::ffff:106.195.79.166	Fiat	2	EUR
118	1	11	37	184	0.66	0.13	20.00	2023-04-27 12:22:11.601	::ffff:106.195.79.166	Fiat	2	EUR
119	1	11	0	185	0.00	0.00	20.00	2023-04-27 12:24:16.595	::ffff:106.195.79.166	Crypto	1	BTC
120	1	11	59	186	2.00	0.40	20.00	2023-04-27 12:34:54.454	::ffff:106.195.79.166	Fiat	2	EUR
121	1	11	0	187	0.00	0.00	20.00	2023-04-27 12:47:23.487	::ffff:106.195.79.166	Crypto	1	BTC
122	1	11	0	188	0.00	0.00	20.00	2023-04-28 04:26:51.363	::ffff:106.195.64.11	Crypto	1	BTC
123	1	11	0	189	0.00	0.00	20.00	2023-04-28 04:37:07.416	::ffff:106.195.64.11	Crypto	1	BTC
124	1	11	60	190	1.82	0.36	20.00	2023-04-28 06:27:43.299	::ffff:106.195.64.11	Fiat	2	EUR
125	1	11	0	191	0.00	0.00	20.00	2023-04-28 09:26:16.152	::ffff:106.195.77.176	Crypto	1	BTC
126	1	11	22	192	0.00	0.00	20.00	2023-04-28 09:33:28.633	::ffff:106.195.77.176	Crypto	1	BTC
127	1	11	38	194	0.66	0.13	20.00	2023-05-04 11:55:59.763	::ffff:223.196.174.73	Fiat	2	EUR
128	1	11	61	195	1.82	0.36	20.00	2023-05-04 12:22:37.322	::ffff:223.196.171.252	Fiat	2	EUR
129	1	11	0	197	0.00	0.00	20.00	2023-05-04 12:27:13.891	::ffff:223.196.171.252	Crypto	1	BTC
130	1	11	23	198	0.00	0.00	20.00	2023-05-04 12:29:12.354	::ffff:223.196.170.96	Crypto	1	BTC
131	1	11	31	199	1.20	0.24	20.00	2023-05-05 05:42:52.197	::ffff:223.196.174.143	Fiat	2	EUR
132	1	11	32	200	1.92	0.38	20.00	2023-05-05 05:44:40.989	::ffff:106.195.64.191	Fiat	2	EUR
133	1	11	0	201	0.00	0.00	20.00	2023-05-05 05:54:42.448	::ffff:106.195.64.191	Crypto	1	BTC
134	1	11	63	219	12.10	2.42	20.00	2023-05-08 05:22:11.72	::ffff:223.196.170.79	Fiat	2	EUR
135	1	11	0	220	0.03	0.01	20.00	2023-05-09 10:56:43.827	::1	Crypto	3	USDT
136	1	11	0	221	0.04	0.01	20.00	2023-05-09 11:47:07.811	::ffff:223.196.171.246	Crypto	3	USDT
137	1	11	0	236	0.00	0.00	20.00	2023-05-11 10:00:29.431	::ffff:223.196.169.174	Crypto	1	BTC
138	1	11	74	237	1.95	0.39	20.00	2023-05-11 10:05:17.761	::ffff:103.176.11.167	Crypto	3	USDT
139	1	11	0	238	0.00	0.00	20.00	2023-05-12 03:39:38.657	::ffff:223.196.169.158	Crypto	1	BTC
140	1	11	0	239	0.00	0.00	20.00	2023-05-12 03:40:18.286	::ffff:223.196.171.251	Crypto	2	ETH
141	1	11	0	240	0.06	0.01	20.00	2023-05-12 03:40:51.063	::ffff:223.196.171.251	Crypto	3	USDT
142	1	11	34	241	1.20	0.24	20.00	2023-05-12 03:43:12.111	::ffff:223.196.171.251	Fiat	2	EUR
143	1	11	77	244	1.94	0.39	20.00	2023-05-12 03:46:46.132	::ffff:106.195.71.214	Crypto	3	USDT
144	1	11	78	245	89.04	17.81	20.00	2023-05-12 03:51:06.766	::ffff:106.195.71.214	Crypto	1	BTC
145	1	11	79	246	146.27	29.25	20.00	2023-05-12 03:52:06.706	::ffff:106.195.71.214	Crypto	2	ETH
146	1	11	80	247	19.09	3.82	20.00	2023-05-12 03:52:53.61	::ffff:106.195.71.214	Crypto	3	USDT
147	1	11	81	248	31.07	6.21	20.00	2023-05-12 04:00:37.584	::ffff:106.195.71.214	Crypto	1	BTC
148	1	11	82	249	26.63	5.33	20.00	2023-05-12 04:14:59.222	::ffff:223.196.172.233	Crypto	1	BTC
149	1	11	35	251	1.20	0.24	20.00	2023-05-12 04:39:25.049	::ffff:223.196.174.74	Fiat	2	EUR
150	1	11	41	252	0.40	0.08	20.00	2023-05-15 09:09:12.444	::ffff:223.196.170.91	Fiat	2	EUR
151	1	11	42	253	0.24	0.05	20.00	2023-05-15 09:49:56.894	::ffff:223.196.172.213	Fiat	1	USD
152	1	11	70	256	41.20	8.24	20.00	2023-06-09 09:25:27.194	::ffff:31.4.149.80	Fiat	1	USD
153	1	11	71	257	0.04	0.01	20.00	2023-06-14 16:14:20.273	::ffff:5.90.203.88	Fiat	1	USD
154	1	11	72	259	2.00	0.40	20.00	2023-06-26 13:12:17.737	::ffff:5.90.215.60	Fiat	1	USD
155	1	11	73	260	2.00	0.40	20.00	2023-06-28 12:15:57.759	::ffff:37.159.73.101	Fiat	1	USD
156	1	11	74	261	2.00	0.40	20.00	2023-06-28 13:30:48.129	::ffff:37.159.73.101	Fiat	1	USD
157	1	11	29	264	0.00	0.00	20.00	2023-07-07 14:02:09.204	::ffff:195.57.146.129	Crypto	1	BTC
\.


--
-- Data for Name: broker_feedback; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.broker_feedback (feedback_id, company_id, feedback_broker_id_fk, rating, comment, created_datetime, created_ip) FROM stdin;
\.


--
-- Data for Name: broker_notification; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.broker_notification (notification_id, company_id, broker_id, notification_title, notification_type, notification_desc, notification_status, created_datetime, created_ip) FROM stdin;
7	1	11	Transaction	Transaction	Transaction	Enable	2023-02-23 12:19:52.403738	::ffff:49.34.215.224
8	1	11	Login	Login	Login	Enable	2023-02-23 12:19:52.403971	::ffff:49.34.215.224
9	1	12	Transaction	Transaction	Transaction	Enable	2023-02-23 12:31:04.896402	::ffff:49.34.215.224
10	1	12	Login	Login	Login	Enable	2023-02-23 12:31:04.900823	::ffff:49.34.215.224
\.


--
-- Data for Name: broker_withdraw_request; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.broker_withdraw_request (broker_withdraw_id, company_id, broker_id, user_id, account_id, withdraw_type, withdraw_amount, broker_withdraw_status, created_datetime, created_ip, currancy_type, broker_reward_id) FROM stdin;
5	1	11	35	58	Manual	0.20	Completed	2023-03-27 08:35:09.777	::ffff:123.201.68.135	fiat	1
4	1	11	35	58	Manual	2.78	Completed	2023-03-14 16:12:18.94	::ffff:151.38.145.55	fiat	1
6	1	11	43	74	Manual	1.00	Pending	2023-04-28 11:03:44.042	::ffff:223.196.169.169	fiat	2
7	1	11	43	74	Manual	12.00	Pending	2023-05-04 05:34:34.145	::ffff:223.196.174.73	fiat	2
8	1	11	35	58	Manual	22.00	Pending	2023-05-04 12:56:51.584	::ffff:223.196.173.223	fiat	1
9	1	11	43	74	Manual	20.00	Pending	2023-05-04 12:57:38.364	::ffff:223.196.171.252	fiat	2
10	1	11	43	106	Manual	2.00	Completed	2023-05-05 03:50:40.477	::ffff:106.195.66.191	crypto	4
\.


--
-- Data for Name: brokercrypto_reward; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.brokercrypto_reward (broker_reward_id, company_id, admin_id_fk, user_id_fk, crypto_id_fk, coin_code, reward, created_datetime, created_ip) FROM stdin;
1	1	11	44	1	BTC	2.46	2023-03-14 16:02:33.884	::ffff:151.38.145.55
4	1	11	43	1	BTC	1.75	2023-04-20 10:37:45.613	::ffff:88.12.14.229
5	1	11	35	2	ETH	29.97	2023-04-24 03:59:43.959	::ffff:223.185.85.71
3	1	11	35	3	USDT	10.71	2023-04-13 12:22:53.985	::ffff:103.176.10.40
2	1	11	35	1	BTC	30.53	2023-03-23 12:29:00.83	::ffff:49.34.41.230
\.


--
-- Data for Name: brokerfiat_reward; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.brokerfiat_reward (broker_fiatreward_id, company_id, admin_id_fk, user_id_fk, fiat_id_fk, coin_code, reward, created_datetime, created_ip) FROM stdin;
3	1	11	35	1	USD	8.64	2023-05-15 09:49:56.898	::ffff:223.196.172.213
4	1	11	41	1	USD	8.64	2023-06-09 09:25:27.2	::ffff:31.4.149.80
2	1	11	43	2	EUR	9.04	2023-04-20 10:51:29.265	::ffff:88.12.14.229
1	1	11	35	2	EUR	40.03	2023-03-01 12:40:46.593	::ffff:49.34.163.6
\.


--
-- Data for Name: card_information; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.card_information (cardinfo_id, company_id, card_type_id, card_name, card_desc, joining_fees_usd, annual_fees_usd, joining_fees_eur, annual_fees_eur, cardinfo_status, created_datetime, created_ip, modified_datetime, modified_ip) FROM stdin;
1	1	1	NBC Physical Card	<li><i className="fa fa-check-circle"></i> One complimentary railway lounge visit per quarter</li>\r\n<br><li><i className="fa fa-check-circle"></i> 25% discount upto $100 on movie tickets at BookMyShow and Inox</li>	10.00	10.00	15.00	15.00	Enable	2022-12-24 11:48:59.166798	\N	2022-12-24 11:48:59.166798	\N
2	1	2	NBC Virtual Card	<li><i className="fa fa-check-circle"></i> One complimentary railway lounge visit per quarter</li><br><li><i className="fa fa-check-circle"></i> 25% discount upto $100 on movie tickets at BookMyShow and Inox</li>	10.00	10.00	15.00	15.00	Enable	2022-12-24 11:48:59.327457	\N	2022-12-24 11:48:59.327457	\N
3	1	1	NBCBANQ Gold Card	<p>Test Added by Ashok</p>	10.00	50.00	0.00	0.00	Enable	2023-02-15 12:09:37.953	::ffff:49.36.81.35	2023-02-15 12:09:37.953	::ffff:49.36.81.35
4	1	2	NBC Virtual Card	<p>----</p>	10.00	30.00	0.00	0.00	Enable	2023-03-29 19:29:17.5	::ffff:42.105.162.209	2023-03-29 19:30:22.593	::ffff:42.105.162.209
5	1	2	Test	<p>Testing</p>	10.00	12.00	0.00	0.00	Enable	2023-04-26 05:20:53.677	::ffff:223.196.172.212	2023-04-26 05:20:53.677	::ffff:223.196.172.212
\.


--
-- Data for Name: card_limit; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.card_limit (cardlimit_id, company_id, card_id_fk, purchase, withdraw, internet, contactless, limit_type, created_datetime, created_ip) FROM stdin;
1	1	4	0.00	0.00	0.00	0.00	Daily	2022-12-28 07:44:02.923	\N
2	1	4	0.00	0.00	0.00	0.00	Weekly	2022-12-28 07:44:02.926	\N
3	1	4	0.00	0.00	0.00	0.00	Monthly	2022-12-28 07:44:02.928	\N
4	1	4	0.00	0.00	0.00	0.00	Transaction	2022-12-28 07:44:02.931	\N
5	1	6	0.00	0.00	0.00	0.00	Daily	2022-12-28 09:43:12.479	\N
6	1	6	0.00	0.00	0.00	0.00	Weekly	2022-12-28 09:43:12.482	\N
7	1	6	0.00	0.00	0.00	0.00	Monthly	2022-12-28 09:43:12.487	\N
8	1	6	0.00	0.00	0.00	0.00	Transaction	2022-12-28 09:43:12.489	\N
9	1	8	0.00	0.00	0.00	0.00	Daily	2023-01-11 12:51:32.54	\N
10	1	8	0.00	0.00	0.00	0.00	Weekly	2023-01-11 12:51:32.543	\N
11	1	8	0.00	0.00	0.00	0.00	Monthly	2023-01-11 12:51:32.544	\N
12	1	8	0.00	0.00	0.00	0.00	Transaction	2023-01-11 12:51:32.546	\N
13	1	9	0.00	0.00	0.00	0.00	Daily	2023-01-11 12:52:57.946	\N
14	1	9	0.00	0.00	0.00	0.00	Weekly	2023-01-11 12:52:57.948	\N
15	1	9	0.00	0.00	0.00	0.00	Monthly	2023-01-11 12:52:57.949	\N
16	1	9	0.00	0.00	0.00	0.00	Transaction	2023-01-11 12:52:57.951	\N
17	1	13	0.00	0.00	0.00	0.00	Daily	2023-01-12 12:44:24.15	\N
18	1	13	0.00	0.00	0.00	0.00	Weekly	2023-01-12 12:44:24.153	\N
19	1	13	0.00	0.00	0.00	0.00	Monthly	2023-01-12 12:44:24.155	\N
20	1	13	0.00	0.00	0.00	0.00	Transaction	2023-01-12 12:44:24.156	\N
21	1	14	0.00	0.00	0.00	0.00	Daily	2023-01-17 09:40:49.885	\N
22	1	14	0.00	0.00	0.00	0.00	Weekly	2023-01-17 09:40:49.888	\N
23	1	14	0.00	0.00	0.00	0.00	Monthly	2023-01-17 09:40:49.889	\N
24	1	14	0.00	0.00	0.00	0.00	Transaction	2023-01-17 09:40:49.891	\N
25	1	18	0.00	0.00	0.00	0.00	Daily	2023-02-16 11:54:09.555	\N
26	1	18	0.00	0.00	0.00	0.00	Weekly	2023-02-16 11:54:09.557	\N
27	1	18	0.00	0.00	0.00	0.00	Monthly	2023-02-16 11:54:09.559	\N
28	1	18	0.00	0.00	0.00	0.00	Transaction	2023-02-16 11:54:09.561	\N
29	1	19	0.00	0.00	0.00	0.00	Daily	2023-03-04 07:33:33.463	\N
31	1	19	0.00	0.00	0.00	0.00	Monthly	2023-03-04 07:33:33.469	\N
32	1	19	0.00	0.00	0.00	0.00	Transaction	2023-03-04 07:33:33.471	\N
34	1	20	0.00	0.00	0.00	0.00	Weekly	2023-03-04 07:45:02.099	\N
35	1	20	0.00	0.00	0.00	0.00	Monthly	2023-03-04 07:45:02.101	\N
36	1	20	0.00	0.00	0.00	0.00	Transaction	2023-03-04 07:45:02.103	\N
37	1	21	0.00	0.00	0.00	0.00	Daily	2023-03-16 12:43:39.142	\N
38	1	21	0.00	0.00	0.00	0.00	Weekly	2023-03-16 12:43:39.144	\N
39	1	21	0.00	0.00	0.00	0.00	Monthly	2023-03-16 12:43:39.146	\N
40	1	21	0.00	0.00	0.00	0.00	Transaction	2023-03-16 12:43:39.148	\N
41	1	22	0.00	0.00	0.00	0.00	Daily	2023-03-20 09:56:22.36	\N
42	1	22	0.00	0.00	0.00	0.00	Weekly	2023-03-20 09:56:22.362	\N
43	1	22	0.00	0.00	0.00	0.00	Monthly	2023-03-20 09:56:22.364	\N
44	1	22	0.00	0.00	0.00	0.00	Transaction	2023-03-20 09:56:22.366	\N
45	1	25	0.00	0.00	0.00	0.00	Daily	2023-04-01 11:03:25.518	\N
46	1	25	0.00	0.00	0.00	0.00	Weekly	2023-04-01 11:03:25.522	\N
47	1	25	0.00	0.00	0.00	0.00	Monthly	2023-04-01 11:03:25.524	\N
48	1	25	100.00	100.00	100.00	1000.00	Transaction	2023-04-01 11:03:25.527	\N
33	1	20	0.07	0.02	0.01	0.02	Daily	2023-03-04 07:45:02.095	\N
49	1	26	0.00	0.00	0.00	0.00	Daily	2023-04-20 11:13:57.806	\N
50	1	26	0.00	0.00	0.00	0.00	Weekly	2023-04-20 11:13:57.811	\N
51	1	26	0.00	0.00	0.00	0.00	Monthly	2023-04-20 11:13:57.814	\N
52	1	26	0.00	0.00	0.00	0.00	Transaction	2023-04-20 11:13:57.817	\N
30	1	19	0.20	0.40	0.60	0.40	Weekly	2023-03-04 07:33:33.466	\N
53	1	29	0.00	0.00	0.00	0.00	Daily	2023-04-26 04:27:52.049	\N
54	1	29	0.00	0.00	0.00	0.00	Weekly	2023-04-26 04:27:52.053	\N
55	1	29	0.00	0.00	0.00	0.00	Monthly	2023-04-26 04:27:52.056	\N
56	1	29	0.00	0.00	0.00	0.00	Transaction	2023-04-26 04:27:52.059	\N
57	1	32	0.00	0.00	0.00	0.00	Daily	2023-04-26 11:25:22.492	\N
58	1	32	0.00	0.00	0.00	0.00	Weekly	2023-04-26 11:25:22.496	\N
59	1	32	0.00	0.00	0.00	0.00	Monthly	2023-04-26 11:25:22.499	\N
60	1	32	0.00	0.00	0.00	0.00	Transaction	2023-04-26 11:25:22.502	\N
61	1	33	0.00	0.00	0.00	0.00	Daily	2023-04-27 05:07:13.785	\N
62	1	33	0.00	0.00	0.00	0.00	Weekly	2023-04-27 05:07:13.789	\N
63	1	33	0.00	0.00	0.00	0.00	Monthly	2023-04-27 05:07:13.791	\N
64	1	33	0.00	0.00	0.00	0.00	Transaction	2023-04-27 05:07:13.794	\N
65	1	34	0.00	0.00	0.00	0.00	Daily	2023-04-27 05:08:06.475	\N
66	1	34	0.00	0.00	0.00	0.00	Weekly	2023-04-27 05:08:06.478	\N
67	1	34	0.00	0.00	0.00	0.00	Monthly	2023-04-27 05:08:06.481	\N
68	1	34	0.00	0.00	0.00	0.00	Transaction	2023-04-27 05:08:06.484	\N
69	1	35	0.00	0.00	0.00	0.00	Daily	2023-04-28 12:16:30.158	\N
70	1	35	0.00	0.00	0.00	0.00	Weekly	2023-04-28 12:16:30.163	\N
71	1	35	0.00	0.00	0.00	0.00	Monthly	2023-04-28 12:16:30.17	\N
72	1	35	0.00	0.00	0.00	0.00	Transaction	2023-04-28 12:16:30.174	\N
73	1	36	0.00	0.00	0.00	0.00	Daily	2023-04-28 12:18:19.194	\N
74	1	36	0.00	0.00	0.00	0.00	Weekly	2023-04-28 12:18:19.198	\N
75	1	36	0.00	0.00	0.00	0.00	Monthly	2023-04-28 12:18:19.201	\N
76	1	36	0.00	0.00	0.00	0.00	Transaction	2023-04-28 12:18:19.206	\N
77	1	37	0.00	0.00	0.00	0.00	Daily	2023-05-05 10:45:41.603	\N
78	1	37	0.00	0.00	0.00	0.00	Weekly	2023-05-05 10:45:41.607	\N
79	1	37	0.00	0.00	0.00	0.00	Monthly	2023-05-05 10:45:41.611	\N
80	1	37	0.00	0.00	0.00	0.00	Transaction	2023-05-05 10:45:41.615	\N
81	1	38	0.00	0.00	0.00	0.00	Daily	2023-05-06 06:26:19.917	\N
82	1	38	0.00	0.00	0.00	0.00	Weekly	2023-05-06 06:26:19.921	\N
83	1	38	0.00	0.00	0.00	0.00	Monthly	2023-05-06 06:26:19.924	\N
84	1	38	0.00	0.00	0.00	0.00	Transaction	2023-05-06 06:26:19.927	\N
85	1	39	0.00	0.00	0.00	0.00	Daily	2023-05-09 12:25:31.574	\N
86	1	39	0.00	0.00	0.00	0.00	Weekly	2023-05-09 12:25:31.589	\N
87	1	39	0.00	0.00	0.00	0.00	Monthly	2023-05-09 12:25:31.595	\N
88	1	39	0.00	0.00	0.00	0.00	Transaction	2023-05-09 12:25:31.604	\N
89	1	40	0.00	0.00	0.00	0.00	Daily	2023-05-09 12:40:14.499	\N
90	1	40	0.00	0.00	0.00	0.00	Weekly	2023-05-09 12:40:14.503	\N
91	1	40	0.00	0.00	0.00	0.00	Monthly	2023-05-09 12:40:14.507	\N
92	1	40	0.00	0.00	0.00	0.00	Transaction	2023-05-09 12:40:14.51	\N
93	1	41	0.00	0.00	0.00	0.00	Daily	2023-05-10 04:41:12.186	\N
94	1	41	0.00	0.00	0.00	0.00	Weekly	2023-05-10 04:41:12.19	\N
95	1	41	0.00	0.00	0.00	0.00	Monthly	2023-05-10 04:41:12.193	\N
96	1	41	0.00	0.00	0.00	0.00	Transaction	2023-05-10 04:41:12.195	\N
97	1	42	0.00	0.00	0.00	0.00	Daily	2023-05-10 08:37:20.579	\N
98	1	42	0.00	0.00	0.00	0.00	Weekly	2023-05-10 08:37:20.584	\N
99	1	42	0.00	0.00	0.00	0.00	Monthly	2023-05-10 08:37:20.588	\N
100	1	42	0.00	0.00	0.00	0.00	Transaction	2023-05-10 08:37:20.591	\N
101	1	43	0.00	0.00	0.00	0.00	Daily	2023-05-10 09:34:06.855	\N
102	1	43	0.00	0.00	0.00	0.00	Weekly	2023-05-10 09:34:06.859	\N
103	1	43	0.00	0.00	0.00	0.00	Monthly	2023-05-10 09:34:06.863	\N
104	1	43	0.00	0.00	0.00	0.00	Transaction	2023-05-10 09:34:06.867	\N
105	1	44	0.00	0.00	0.00	0.00	Daily	2023-05-15 09:05:33.618	\N
106	1	44	0.00	0.00	0.00	0.00	Weekly	2023-05-15 09:05:33.623	\N
107	1	44	0.00	0.00	0.00	0.00	Monthly	2023-05-15 09:05:33.626	\N
108	1	44	0.00	0.00	0.00	0.00	Transaction	2023-05-15 09:05:33.63	\N
109	1	45	0.00	0.00	0.00	0.00	Daily	2023-05-15 09:07:51.857	\N
110	1	45	0.00	0.00	0.00	0.00	Weekly	2023-05-15 09:07:51.86	\N
111	1	45	0.00	0.00	0.00	0.00	Monthly	2023-05-15 09:07:51.862	\N
112	1	45	0.00	0.00	0.00	0.00	Transaction	2023-05-15 09:07:51.864	\N
113	1	47	0.00	0.00	0.00	0.00	Daily	2023-08-10 06:49:15.849	\N
114	1	47	0.00	0.00	0.00	0.00	Weekly	2023-08-10 06:49:15.854	\N
115	1	47	0.00	0.00	0.00	0.00	Monthly	2023-08-10 06:49:15.856	\N
116	1	47	0.00	0.00	0.00	0.00	Transaction	2023-08-10 06:49:15.859	\N
\.


--
-- Data for Name: card_transaction; Type: TABLE DATA; Schema: public; Owner: nbcbanq
--

COPY public.card_transaction (cardtra_id, company_id, card_id_fk, user_id_fk, acc_id_fk, amount, fees, cardtra_type, issue_status, message, created_datetime, created_ip, hash, broker_reward, manager_reward, admin_reward, final_final, tenpercnt, custtrafeesper, custtrafeestype, manager_fees_per, broker_fees_per, admin_fees_per, fee_flag) FROM stdin;
19	1	19	35	57	62.37	0.00	Credit	Completed	thank you	2023-03-27 08:16:34.595	\N	19-1679904994	0	0	0	0	0	0	0	0	0	0	0
20	1	20	35	57	28.35	0.00	Credit	Completed	jbjddc	2023-03-27 08:19:25.187	\N	20-1679905165	0	0	0	0	0	0	0	0	0	0	0
21	1	19	35	57	43.16	0.00	Credit	Completed	Thank you	2023-03-27 08:29:35.474	\N	21-1679905775	0	0	0	0	0	0	0	0	0	0	0
22	1	20	35	57	26.46	0.00	Credit	Completed	test	2023-04-10 18:36:26.078	\N	22-1681151786	0	0	0	0	0	0	0	0	0	0	0
23	1	20	35	57	1.89	0.00	Credit	Completed	test	2023-04-11 03:36:44.68	\N	23-1681184204	0	0	0	0	0	0	0	0	0	0	0
24	1	20	35	57	9.45	0.00	Credit	Completed	toptup	2023-04-18 18:35:17.017	\N	24-1681842917	0	0	0	0	0	0	0	0	0	0	0
25	1	20	35	57	10.00	0.00	Debit	Completed	internal transfer	2023-04-18 18:41:49.336	\N	25-1681843309	0	0	0	0	0	0	0	0	0	0	0
26	1	27	43	73	1701.00	0.00	Credit	Completed	True	2023-04-20 11:25:38.541	\N	26-1681989938	19.8000	9.9000	99.0000	1701.0000	99.0000	0	Percentage	10	20	0	true
27	1	27	43	73	945.00	0.00	Credit	Completed	100	2023-04-20 11:26:15.394	\N	27-1681989975	11.0000	5.5000	55.0000	945.0000	55.0000	0	Percentage	10	20	0	true
28	1	27	43	73	1000.00	0.00	Debit	Completed	ok	2023-04-20 11:26:58.64	\N	28-1681990018	0.3640	0.1820	1.8200	998.1800	1.8200	0	Percentage	10	20	0	true
29	1	20	35	57	21.74	0.00	Credit	Completed	test	2023-04-25 11:23:06.147	\N	29-1682421786	0.2530	0.1265	1.2650	21.7350	1.2650	0	Percentage	10	20	0	true
30	1	20	35	57	12.00	0.00	Debit	Completed	tset	2023-04-25 11:26:56.677	\N	30-1682422016	0.3640	0.1820	1.8200	10.1800	1.8200	0	Percentage	10	20	0	true
31	1	19	35	57	11.34	0.00	Credit	Completed	gg	2023-04-26 11:29:02.624	\N	31-1682508542	0.1320	0.0660	0.6600	11.3400	0.6600	0	Percentage	10	20	0	true
32	1	29	35	57	94.50	0.00	Credit	Completed	test	2023-04-26 11:31:08.871	\N	32-1682508668	1.1000	0.5500	5.5000	94.5000	5.5000	0	Percentage	10	20	0	true
33	1	29	35	57	94.50	0.00	Credit	Completed	aa	2023-04-26 11:33:01.973	\N	33-1682508782	1.1000	0.5500	5.5000	94.5000	5.5000	0	Percentage	10	20	0	true
34	1	29	35	57	180.00	0.00	Debit	Completed	tt	2023-04-26 11:34:49.123	\N	34-1682508889	4.3200	2.1600	21.6000	158.4000	21.6000	0	Percentage	10	20	0	true
35	1	20	35	58	0.95	0.00	Credit	Completed	e	2023-04-27 10:22:38.163	\N	35-1682590958	0.0110	0.0055	0.0550	0.9450	0.0550	0	Percentage	10	20	0	true
36	1	20	35	57	6.82	0.00	Debit	Completed	t	2023-04-27 10:43:48.568	\N	36-1682592228	0.3640	0.1820	1.8200	5.0000	1.8200	0	Percentage	10	20	0	true
37	1	22	35	58	11.34	0.00	Credit	Completed	ty	2023-04-27 12:22:11.583	\N	37-1682598131	0.1320	0.0660	0.6600	11.3400	0.6600	0	Percentage	10	20	0	true
38	1	20	35	57	11.34	0.00	Credit	Completed	12	2023-05-04 11:55:59.734	\N	38-1683201359	0.1320	0.0660	0.6600	11.3400	0.6600	0	Percentage	10	20	0	true
39	1	38	78	115	1719.90	0.00	Credit	Completed	a	2023-05-06 06:42:03.62	\N	39-1683355323	20.0200	10.0100	100.1000	1719.9000	100.1000	0	Percentage	10	20	0	true
40	1	41	81	119	10.00	0.00	Credit	Completed	First	2023-05-10 04:59:51.635	\N	40-1683694791	0.0000	0.0000	0.0000	10.0000	0.0000	0	Percentage	0	0	0	false
41	1	31	35	57	19.60	0.00	Credit	Completed	test	2023-05-15 09:09:12.426	\N	41-1684141752	0.0800	0.0400	0.4000	19.6000	0.4000	0	Percentage	10	20	0	true
42	1	19	35	57	11.76	0.00	Credit	Completed	ba	2023-05-15 09:49:56.879	\N	42-1684144196	0.0480	0.0240	0.2400	11.7600	0.2400	0	Percentage	10	20	0	true
43	1	41	81	119	500.00	0.00	Credit	Completed	na	2023-05-15 10:17:19.476	\N	43-1684145839	0.0000	0.0000	0.0000	500.0000	0.0000	0	Percentage	0	0	0	false
\.


--
