dsadsa
Tables (7)
SequelizeMeta
- name — VARCHAR(255) — Primary key — NOT NULL
achievements
- id — INT — Primary key — NOT NULL
- scrooge — INT
- leastspend — INT
- userId — INT — Foreign key → users.id — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `userId`
categories
- id — INT — Primary key — NOT NULL
- categoryname — VARCHAR(255)
- budget — INT
- emoji — VARCHAR(255)
- userId — INT — Foreign key → users.id — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `userId`
levels
- id — INT — Primary key — NOT NULL
- level — INT
- theme — TINYINT(1)
- dataexplore — TINYINT(1)
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
money
- id — INT — Primary key — NOT NULL
- cost — INT
- memo — VARCHAR(255)
- date — VARCHAR(255)
- categoryId — INT — Foreign key → categories.id — NOT NULL
- userId — INT — Foreign key → users.id — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `categoryId`
- INDEX — `userId`
user_levels
- id — INT — Primary key — NOT NULL
- userId — INT — Foreign key → users.id — NOT NULL
- levelId — INT — Foreign key → levels.id — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL
- INDEX — `userId`
- INDEX — `levelId`
users
- id — INT — Primary key — NOT NULL
- username — VARCHAR(255)
- email — VARCHAR(255)
- password — VARCHAR(255)
- photo — VARCHAR(255)
- darkmode — TINYINT(1)
- redirect — VARCHAR(255)
- experience — INT
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME — NOT NULL