# Database Schema (MVP)

Every tenant-owned table carries tenant_id. Money is stored as integers in paisa.

## tenants

- id
- name
- phone
- email
- plan
- project_limit
- is_active

## users

- id
- tenant_id
- name
- phone
- email
- password
- role

## projects

- id
- tenant_id
- name
- location
- status
- budget
- start_date

## project_user

- project_id
- user_id

## inventory_items

- id
- tenant_id
- name
- unit

## inventory_transactions

- id
- project_id
- inventory_item_id
- type
- quantity
- transaction_date
- notes
- created_by

## cash_receipts

- id
- project_id
- amount
- source
- received_date
- notes
- created_by

## expenses

- id
- project_id
- vendor_name
- category
- amount
- expense_date
- payment_method
- notes
- created_by