KB3
Tables (5)
categories
- id — VARCHAR(10) — Primary key — NOT NULL
- type — VARCHAR(10) — NOT NULL
- name — VARCHAR(50) — NOT NULL
goals
- id — VARCHAR(10) — Primary key — NOT NULL
- userId — VARCHAR(10) — Foreign key → users.id — NOT NULL
- itemName — VARCHAR(100) — NOT NULL
- targetAmount — INT — NOT NULL
- achieved — BOOLEAN — NOT NULL
groups
- id — VARCHAR(10) — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- memberIds — VARCHAR(255) — NOT NULL
- targetAmount — INT — NOT NULL
transactions
- id — VARCHAR(10) — Primary key — NOT NULL
- userId — VARCHAR(10) — Foreign key → users.id — NOT NULL
- categoryId — VARCHAR(10) — Foreign key → categories.id — NOT NULL
- date — DATE — NOT NULL
- type — VARCHAR(10) — NOT NULL
- amount — INT — NOT NULL
- memo — VARCHAR(255)
- isDutchPay — BOOLEAN — NOT NULL
- dutchPayHeadcount — INT
users
- id — VARCHAR(10) — Primary key — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- profileImg — VARCHAR(10)
- expenseLimit — INT — NOT NULL