account book

Tables (6)

bill (Untitled)

  • index (Key) — int — Primary key — NOT NULL
  • price (Field) — long
  • type (Field2) — int
  • detail (Field3) — varchar
  • io (Field4) — int
  • category (Field5) — int
  • input_date (Field6) — date
  • update_date (Field7) — date
  • Field8

cash (Untitled5)

    category (Untitled4)

      io (Untitled3)

      • key (지출) — int
      • key (수입) — int

      total (Untitled6)

        type (Untitled2)

        • index (card) — int — NOT NULL
        • index (Key) — int — Foreign key → bill.index — NOT NULL