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