efeef

Tables (5)

Budget (Untitled3)

  • PK — INT — Primary key — NOT NULL
  • FK — INT — Foreign key → User.PK — NOT NULL
  • Field (goal_price) — INT
  • Field (alarm_percent) — DOUBLE

Category (Untitled4)

  • PK — INT — Primary key — NOT NULL
  • FK — INT(NULLABLE) — Primary key — NOT NULL
  • Field (name) — String
  • Field (iconpath) — String
  • Field (is_default) — boolean
  • Field (TYPE) — ENUM(INCOME/EXPENSE)

Statistics (Untitled5)

  • PK — INT — Primary key — NOT NULL
  • Field

Transaction (Untitled2)

  • PK — INT — Primary key — NOT NULL
  • fk (FK) — INT — Foreign key → Category.PK — NOT NULL
  • Key — Foreign key → Category.FK — NOT NULL
  • fk — INT — Foreign key → User.PK — NOT NULL
  • Field (price) — INT
  • Field (memo) — String
  • Field (createdAt) — Date
  • Field (modifiedAt) — Date
  • Field (is_mark) — boolean
  • Field (is_fixed) — boolean

User (Untitled)

  • PK — INT — Primary key — NOT NULL
  • Field (email) — String
  • Field (password) — Stinrg
  • Field (nickname) — String
  • Field (birth) — Date
  • Field (imagepath) — String