RBB Database Schema - Reserve Bank of Buddhistan | WordPress Structure
RBB Banks RBB Licenses RBB Officers RBB Branches RBB Ministry RBB Projects RBB Emergency BRL Currency BRL Wallets BRL Transactions BRL Cards BRL Exchange BRL Blockchain BRL Offers

RBB Banks Database (Prefix: wp_rbb_)

wp_rbb_banks

Master list of all licensed banks in Buddhistan

CREATE TABLE wp_rbb_banks (
  id BIGINT(20) UNSIGNED AUTO_INCREMENT,
  bank_code VARCHAR(20) NOT NULL,
  bank_name VARCHAR(255) NOT NULL,
  category ENUM('public', 'private', 'cooperative', 'foreign', 'digital'),
  license_id BIGINT(20) UNSIGNED,
  head_office VARCHAR(255),
  established_date DATE,
  total_branches INT(11) DEFAULT 0,
  capital_amount DECIMAL(20,2),
  status ENUM('active', 'suspended', 'closed') DEFAULT 'active',
  created_at DATETIME,
  updated_at DATETIME,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bank_code` (`bank_code`)
);
  • id BIGINT PRIMARY KEY
  • bank_code VARCHAR(20) UNIQUE
  • bank_name VARCHAR(255)
  • category ENUM
  • license_id BIGINT FOREIGN KEY
  • capital_amount DECIMAL(20,2)
RBB Core Table View Sample Data

wp_rbb_licenses

Banking licenses issued by RBB

CREATE TABLE wp_rbb_licenses (
  id BIGINT(20) UNSIGNED AUTO_INCREMENT,
  license_number VARCHAR(50) NOT NULL,
  license_type ENUM('BL-01', 'MF-02', 'NB-03', 'FB-04', 'PG-05', 'DC-06', 'SB-07', 'IF-08'),
  entity_name VARCHAR(255),
  issue_date DATE,
  expiry_date DATE,
  license_fee DECIMAL(15,2),
  status ENUM('active', 'expired', 'suspended', 'revoked'),
  approved_by BIGINT(20) UNSIGNED,
  created_at DATETIME,
  PRIMARY KEY (`id`),
  UNIQUE KEY `license_number` (`license_number`)
);
RBB Core Table View Sample

wp_rbb_officers

RBB Officers with Class A/B/C/D classification

CREATE TABLE wp_rbb_officers (
  id BIGINT(20) UNSIGNED AUTO_INCREMENT,
  officer_id VARCHAR(20) NOT NULL,
  first_name VARCHAR(100),
  last_name VARCHAR(100),
  officer_class ENUM('A', 'B', 'C', 'D'),
  officer_grade VARCHAR(5), -- A1, A2, A3, B1, etc.
  designation VARCHAR(255),
  department_id BIGINT(20) UNSIGNED,
  branch_id BIGINT(20) UNSIGNED,
  pay_scale VARCHAR(50),
  joining_date DATE,
  status ENUM('active', 'retired', 'suspended'),
  PRIMARY KEY (`id`),
  UNIQUE KEY `officer_id` (`officer_id`)
);
HR Table View Sample

wp_rbb_branches

RBB Branch network across 5 levels

CREATE TABLE wp_rbb_branches (
  id BIGINT(20) UNSIGNED AUTO_INCREMENT,
  branch_code VARCHAR(20),
  branch_name VARCHAR(255),
  branch_level ENUM('local', 'district', 'state', 'national', 'international'),
  parent_branch_id BIGINT(20) UNSIGNED,
  address TEXT,
  city VARCHAR(100),
  state VARCHAR(100),
  phone VARCHAR(20),
  email VARCHAR(100),
  manager_id BIGINT(20) UNSIGNED,
  status ENUM('active', 'inactive'),
  PRIMARY KEY (`id`)
);
Network Table View Sample

RBB Licenses Database

Brainlo Currency Database (Prefix: wp_brl_)

wp_brl_currency

Brainlo currency denominations and circulation

CREATE TABLE wp_brl_currency (
  id BIGINT(20) UNSIGNED AUTO_INCREMENT,
  currency_type ENUM('note', 'coin', 'digital'),
  denomination DECIMAL(10,2),
  series VARCHAR(50),
  issue_date DATE,
  quantity_minted BIGINT(20),
  quantity_circulation BIGINT(20),
  total_value DECIMAL(20,2),
  security_features TEXT,
  status ENUM('active', 'demonetized', 'commemorative'),
  created_at DATETIME,
  PRIMARY KEY (`id`)
);
BRL Core Table View Sample

wp_brl_wallets

Digital Brainlo wallets for citizens

CREATE TABLE wp_brl_wallets (
  id BIGINT(20) UNSIGNED AUTO_INCREMENT,
  wallet_address VARCHAR(255) NOT NULL,
  user_id BIGINT(20) UNSIGNED,
  wallet_type ENUM('individual', 'business', 'government', 'temple'),
  balance DECIMAL(20,2) DEFAULT 0.00,
  kyc_status ENUM('verified', 'pending', 'rejected'),
  daily_limit DECIMAL(15,2),
  monthly_limit DECIMAL(15,2),
  created_at DATETIME,
  last_transaction_at DATETIME,
  PRIMARY KEY (`id`),
  UNIQUE KEY `wallet_address` (`wallet_address`)
);
Digital Wallet View Sample

wp_brl_transactions

All Brainlo currency transactions

CREATE TABLE wp_brl_transactions (
  id BIGINT(20) UNSIGNED AUTO_INCREMENT,
  transaction_id VARCHAR(100) NOT NULL,
  from_wallet VARCHAR(255),
  to_wallet VARCHAR(255),
  amount DECIMAL(20,2),
  transaction_type ENUM('send', 'receive', 'withdraw', 'deposit', 'exchange'),
  status ENUM('pending', 'completed', 'failed', 'reversed'),
  blockchain_hash VARCHAR(255),
  reference VARCHAR(255),
  created_at DATETIME,
  completed_at DATETIME,
  PRIMARY KEY (`id`),
  UNIQUE KEY `transaction_id` (`transaction_id`),
  KEY `from_wallet` (`from_wallet`),
  KEY `to_wallet` (`to_wallet`)
);
Transactions View Sample

wp_brl_cards

Brainlo physical and virtual cards

CREATE TABLE wp_brl_cards (
  id BIGINT(20) UNSIGNED AUTO_INCREMENT,
  card_number VARCHAR(50) NOT NULL,
  card_type ENUM('gold', 'silver', 'bronze', 'corporate'),
  wallet_id BIGINT(20) UNSIGNED,
  card_limit DECIMAL(15,2),
  expiry_date DATE,
  cvv VARCHAR(10),
  status ENUM('active', 'blocked', 'expired'),
  issued_at DATETIME,
  PRIMARY KEY (`id`),
  UNIQUE KEY `card_number` (`card_number`)
);
Cards View Sample

wp_brl_exchange_rates

Live and historical exchange rates

CREATE TABLE wp_brl_exchange_rates (
  id BIGINT(20) UNSIGNED AUTO_INCREMENT,
  currency_code VARCHAR(10),
  currency_name VARCHAR(100),
  rate_to_brl DECIMAL(15,6),
  change_percent DECIMAL(8,2),
  change_direction ENUM('up', 'down', 'stable'),
  last_updated DATETIME,
  created_at DATETIME,
  PRIMARY KEY (`id`),
  KEY `currency_code` (`currency_code`)
);
Exchange View Sample

wp_brl_blockchain

Blockchain ledger for Digital Brainlo

CREATE TABLE wp_brl_blockchain (
  id BIGINT(20) UNSIGNED AUTO_INCREMENT,
  block_number BIGINT(20),
  block_hash VARCHAR(255),
  previous_hash VARCHAR(255),
  transaction_id VARCHAR(100),
  merkle_root VARCHAR(255),
  timestamp DATETIME,
  validator_node VARCHAR(255),
  PRIMARY KEY (`id`),
  UNIQUE KEY `block_hash` (`block_hash`)
);
Blockchain View Sample
Database Relationship Diagram
wp_rbb_banks
id (PK)
bank_code
license_id (FK)
wp_rbb_licenses
id (PK)
license_number
entity_name
wp_brl_wallets
id (PK)
wallet_address
balance
wp_brl_transactions
id (PK)
from_wallet (FK)
to_wallet (FK)
Scroll to Top