BOHO INVENTORY SYSTEM DOCUMENTATION

Using SQL Editor:

1. Access SQL Editor:
   • Click "SQL Editor" in left sidebar
   • Create "New Query" or select saved query
   • Use split view to see results alongside query
2. Common SQL Operations:
   • View Table Data: SELECT * FROM table_name;
   • Filter Records: SELECT * FROM table_name WHERE condition;
   • Update Records: UPDATE table_name SET column = value WHERE condition;
   • Delete Records: DELETE FROM table_name WHERE condition;
3. Save Queries:
   • Click "Save" button after writing query
   • Name your query for future reference
   • Access saved queries from left sidebar

Advanced Table Management:

1. Table Structure:
   • Add/Remove Columns:
     • Use Table Editor: Click "Edit Table"
     • Or SQL: ALTER TABLE table_name ADD COLUMN column_name data_type;
   • Modify Columns:
     • Change data types
     • Add constraints (unique, not null, etc.)
     • Set default values
2. Bulk Operations:
   • Import Data:
     • Click "Insert" > "Import Data"
     • Support CSV, JSON formats
     • Map columns automatically or manually
   • Export Data:
     • Select rows to export
     • Choose format (CSV, JSON)
     • Download or copy to clipboard
3. Table Relationships:
   • Create Foreign Keys:
     • Link tables through relationships
     • Set referential actions (CASCADE, SET NULL)
   • View Relationships:
     • Use "Database" > "Relationships" view
     • Visual diagram of table connections

Initial Setup

1. Configure Authentication Provider:
   • Navigate to Authentication > Providers
   • Enable Email/Password authentication
   • Configure password requirements:
     • Minimum length: 8 characters
     • Require special characters
     • Require numbers
   • Set up email templates for:
     • Welcome emails
     • Password reset
     • Email confirmation

User Management

1. Access User List:
   • Go to Authentication > Users
   • View all registered users
   • Filter by status (active/inactive)
   • Search by email or metadata
2. User Operations:
   • Create New User (Multiple Methods):
     • Method 1 - Authentication UI:
       • Go to Authentication > Users
       • Click "New User"
       • Enter email and password
       • Optional: Check "Auto-confirm user"
       • Click "Create User"
     • Method 2 - Direct Table Edit:
       • Go to Table Editor > auth.users
       • Click "Insert Row"
       • Fill required fields:
         • email: user's email
         • encrypted_password: use bcrypt hash
         • role: 'admin', 'viewer', or 'guest'
         • email_confirmed_at: current timestamp (for auto-confirm)
       • ⚠️ Warning: This method bypasses email verification
     • Method 3 - SQL Insert:
       • Go to SQL Editor
       • Use this template: INSERT INTO auth.users (email, encrypted_password, role, email_confirmed_at)
VALUES (
'user@example.com',
crypt('password', gen_salt('bf')),
'admin',
now()
);
       • Modify values as needed
       • Execute query to create user
   • Important Notes:
     • Direct table editing bypasses email verification
     • Use with caution in production environment
     • Always set proper role permissions
     • Document any manual user creations
   • Modify existing user:
     • Reset password
     • Change role
     • Disable/Enable account
     • Delete account (with caution)
3. Monitor Activity:
   • View login history
   • Track failed login attempts
   • Monitor active sessions
   • Review security logs

Role-Based Access Control (RBAC)

1. Role Configuration:
   • Admin Role:
     • Full system access
     • Manage users and roles
     • Modify database structure
   • Viewer Role:
     • Read-only access
     • View inventory and orders
     • No modification rights
   • Guest Role:
     • Limited access
     • View basic information only
     • No sensitive data access
2. Row Level Security (RLS):
   • Basic Policy Example: CREATE POLICY "Viewers can read inventory" ON inventory
FOR SELECT TO authenticated
USING (auth.role() = 'viewer');
   • Advanced Policies:
     • Restrict sensitive data access
     • Limit modification capabilities
     • Control data visibility by role

• Regularly review user access and permissions
• Monitor and log authentication attempts
• Implement strong password policies
• Keep authentication settings up to date
• Document all role changes and policy updates