Database schema

Simple Money uses a PostgreSQL database hosted on Supabase. All tables have row-level security (RLS) enabled. The schema is defined in supabase/schema.sql and can be applied directly in the Supabase SQL Editor.

Tables

profiles

Extends Supabase’s built-in auth.users table with application-specific user data. Each row is created at sign-up and tied to the authenticated user’s UUID.

Show columns

uuid

required

Primary key. References auth.users(id). Deleted cascades from auth.

username

text

required

Unique display name chosen at registration.

phone

text

User’s phone number. Defaults to an empty string.

role

text

Access level. One of user or admin. Defaults to user.

level_id

integer

Foreign key to levels.id. null until the user purchases a VIP tier.

wallet_balance

decimal(12,2)

Spendable balance available for withdrawal. Defaults to 0.

profit

decimal(12,2)

Commission earned in the current daily session. Defaults to 0.

total_profit

decimal(12,2)

Cumulative lifetime commission earned. Defaults to 0.

frozen_amount

decimal(12,2)

Balance temporarily locked during a pending withdrawal. Defaults to 0.

referral_earned

decimal(12,2)

Total earnings credited from referrals. Defaults to 0.

referral_code

text

required

Unique code this user can share with others. Auto-generated at sign-up.

referred_by

text

Referral code used during sign-up. null if none was provided.

avatar_url

text

URL to the user’s profile photo. null by default.

completed_count

integer

Number of tasks completed in the current set. Resets with last_reset_at.

current_set

integer

Which set the user is currently on within a day (1-indexed).

last_reset_at

timestamptz

Timestamp of the last daily counter reset.

wallet_address

text

User’s bound crypto wallet address for withdrawals. Optional.

security_pin

text

Hashed security PIN for sensitive operations. Optional.

language

text

Preferred UI language code (e.g., en, zh). Defaults to en.

currency

text

Preferred display currency code (e.g., USD). Defaults to USD.

notifications_enabled

boolean

Whether the user has enabled in-app notifications. Defaults to true.

wallet_network

text

Preferred crypto network for withdrawals (e.g., TRC20, BEP20, ERC20). Optional.

created_at

timestamptz

Row creation timestamp. Defaults to now().

levels

Static configuration table for each VIP tier. Rows are seeded at setup time and managed by admins. Users reference a level via profiles.level_id.

Show columns

serial

required

Auto-incrementing primary key.

name

text

required

Display name for the tier (e.g., Level 1 Collector).

price

decimal(10,2)

required

Cost in USD to unlock this tier. Defaults to 0.

commission_rate

decimal(5,4)

required

Commission fraction applied per task (e.g., 0.0045 = 0.45%). Defaults to 0.0045.

tasks_per_set

integer

required

Number of tasks in a single set for this tier. Defaults to 40.

sets_per_day

integer

Maximum sets a user at this level may complete per day.

description

text

Human-readable summary shown on the Levels page. Defaults to an empty string.

badge_color

text

Hex color code used to render the tier badge in the UI. Defaults to #06b6d4.

task_items

The pool of available tasks displayed on the Start page. Tasks can be filtered by level and toggled active or inactive by admins.

Show columns

serial

required

Auto-incrementing primary key.

title

text

required

Display name of the task (e.g., a product or brand name).

image_url

text

required

URL of the product image shown in the task grid.

description

text

Short description rendered below the task image. Defaults to an empty string.

user_tasks

Execution records linking a user to a specific task. Each row represents one task assignment within a set.

Show columns

serial

required

Auto-incrementing primary key.

user_id

uuid

required

Foreign key to profiles.id. Deleted cascades from profiles.

task_item_id

integer

required

Foreign key to task_items.id. Deleted cascades from task_items.

status

text

Execution state. One of pending, completed, or cancelled. Defaults to pending.

earned_amount

decimal(10,2)

Commission credited to the user upon completion. Defaults to 0.

cost_amount

decimal(10,2)

Amount deducted from the user’s balance for bundle tasks. Optional.

is_bundle

boolean

Whether this task is a special bundle (higher cost, higher reward). Optional.

completed_at

timestamptz

Timestamp when the task was marked completed. null while pending.

created_at

timestamptz

Row creation timestamp. Defaults to now().

referral_codes

Registry of all referral codes in the system. Each user gets one code on sign-up; the registry allows validation at registration time.

Show columns

serial

required

Auto-incrementing primary key.

code

text

required

Unique referral code string.

owner_id

uuid

required

Foreign key to profiles.id. Deleted cascades from profiles.

uses_count

integer

Number of times this code has been used at sign-up. Defaults to 0.

is_active

boolean

Whether the code is currently redeemable. Defaults to true.

created_at

timestamptz

Row creation timestamp. Defaults to now().

transactions

Financial ledger recording every balance movement. All deposits, withdrawals, commission credits, and freeze/unfreeze events are written here.

Show columns

serial

required

Auto-incrementing primary key.

user_id

uuid

required

Foreign key to profiles.id. Deleted cascades from profiles.

type

text

required

Movement type. One of deposit, withdrawal, commission, freeze, or unfreeze.

amount

decimal(12,2)

required

Absolute value of the movement in USD.

description

text

Human-readable note (e.g., Task commission, Withdrawal request). Defaults to an empty string.

status

text

Processing state. One of pending, approved, or rejected. Used for deposit and withdrawal rows.

created_at

timestamptz

Row creation timestamp. Defaults to now().

Row-level security policies

RLS is enabled on every table. Policies follow two patterns: users can only access their own rows, and users with role = 'admin' can access all rows.

profiles

Policy	Operation	Rule
Users can view own profile	`SELECT`	`auth.uid() = id`
Users can update own profile	`UPDATE`	`auth.uid() = id`
Enable insert for authenticated users	`INSERT`	`auth.uid() = id`
Admins can view all profiles	`SELECT`	Caller has `role = 'admin'`
Admins can update all profiles	`UPDATE`	Caller has `role = 'admin'`
Admins can delete profiles	`DELETE`	Caller has `role = 'admin'`

levels

Policy	Operation	Rule
Anyone can view levels	`SELECT`	Always true (public read)
Admins can manage levels	`ALL`	Caller has `role = 'admin'`

task_items

Policy	Operation	Rule
Anyone can view active tasks	`SELECT`	Always true (public read)
Admins can manage task items	`ALL`	Caller has `role = 'admin'`

user_tasks

Policy	Operation	Rule
Users can view own tasks	`SELECT`	`auth.uid() = user_id`
Users can insert own tasks	`INSERT`	`auth.uid() = user_id`
Users can update own tasks	`UPDATE`	`auth.uid() = user_id`
Admins can manage all user tasks	`ALL`	Caller has `role = 'admin'`

referral_codes

Policy	Operation	Rule
Anyone can view active referral codes	`SELECT`	`is_active = true` (public read for validation)
Users can manage own referral codes	`ALL`	`auth.uid() = owner_id`
Admins can manage all referral codes	`ALL`	Caller has `role = 'admin'`

transactions

Policy	Operation	Rule
Users can view own transactions	`SELECT`	`auth.uid() = user_id`
Admins can manage all transactions	`ALL`	Caller has `role = 'admin'`

The transactions table intentionally omits a user INSERT policy. All transaction rows are created server-side (via API routes using the service role key) to prevent users from writing arbitrary ledger entries.

Get Started

Core Features

Admin Guide

Technical Reference

Tables

profiles

levels

task_items

user_tasks

referral_codes

transactions

Row-level security policies

profiles

levels

task_items

user_tasks

referral_codes

transactions

Build docs developers (and LLMs) love

Get Started

Core Features

Admin Guide

Technical Reference

​Tables

​profiles

​levels

​task_items

​user_tasks

​referral_codes

​transactions

​Row-level security policies

​profiles

​levels

​task_items

​user_tasks

​referral_codes

​transactions

Build docs developers (and LLMs) love

Tables

profiles

levels

task_items

user_tasks

referral_codes

transactions

Row-level security policies

profiles

levels

task_items

user_tasks

referral_codes

transactions