cashbook-5

Tables (4)

Category (Untitled4)

  • id (Key) — INT — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • color (Field2)

Ledger (Untitled)

  • id (Key) — INT — Primary key — NOT NULL
  • date (Field) — DATE
  • content (Field2) — VARCHAR
  • amount (Field7) — DECIMAL
  • createAt (Field5) — DATE
  • updateAt (Field6) — DATE
  • categoryId (Key4) — INT — Foreign key → Category.id — NOT NULL
  • paymentTypeId (Key2) — INT — Foreign key → PaymentType.id — NOT NULL
  • userId (Key3) — VARCHAR — Foreign key → User.id — NOT NULL

PaymentType (Untitled3)

  • id (Key2) — INT — Primary key — NOT NULL
  • userId (Key) — VARCHAR — Foreign key → User.id — NOT NULL
  • name (Field6) — VARCHAR
  • bgColor (Field3) — VARCHAR
  • fontColor (Field5) — VARCHAR
  • createAt (Field) — DATE
  • updateAt (Field2) — DATE
  • image (Field4) — VARCHAR

User (Untitled2)

  • id (Key) — INT — Primary key — NOT NULL
  • githubUsername (Field) — VARCHAR
  • avatarURL (Field2) — VARCHAR