boost_accountbook

Tables (5)

Untitled (category)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(20) — NOT NULL
  • Field (type) — enum('Income', 'expense')

Untitled (pay_type)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(20) — NOT NULL

Untitled (user_pay_type)

  • Key (user_id) — int — Foreign key → un.Key — NOT NULL
  • Key (pay_type_id) — int — Foreign key → Untitled.Key — NOT NULL

house-hold (account)

  • Key (id) — int — Primary key — NOT NULL
  • Field (type) — enum('Income', 'expense') — NOT NULL
  • Field (date) — datetime — NOT NULL
  • Field (amount) — int — NOT NULL
  • Field (content) — varchar(100) — NOT NULL
  • Key (user_id) — int — Foreign key → un.Key — NOT NULL
  • Key (category_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (pay_type_id) — int — Foreign key → Untitled.Key — NOT NULL

un (user)

  • Key (id) — int — Primary key — NOT NULL
  • Field (user_id) — varchar(20) — NOT NULL
  • Field (password) — varchar(200) — NOT NULL
  • Field (name) — varchar(20) — NOT NULL