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