F-tree
Tables (3)
Branch (unit of budget)
- Branch (b_id) — NOT NULL — Primary key — NOT NULL
- Who's user? (u_id) — NOT NULL — Foreign key → User.Who's user? — NOT NULL
- Parent branch (parent_id) — NOT NULL
- If the branch can be modified (is_activate) — NOT NULL
- When the branch was created (create_date) — NOT NULL
Transaction (How much cashflow evoked.)
- Transaction (transaction_id) — NOT NULL — Primary key — NOT NULL
- Branch (b_id) — NOT NULL — Foreign key → Branch.Branch — NOT NULL
- Who's user? (u_id) — NOT NULL — Foreign key → Branch.Who's user? — NOT NULL
- How much (cashflow) — NOT NULL
- Date when it was evoked (trancation_date) — NOT NULL
- Date when it was created (create_date) — NOT NULL
- Date when it was deleted (delete_date) — -
- photo which has info about transaction (photo_path) — NOT NULL
User
- Who's user? (u_id) — NOT NULL — Primary key — NOT NULL
- Password (passwd) — NOT NULL
- e-mail (email) — NOT NULL
- finance-tree name (tree_name) — NOT NULL