conplan
Tables (4)
calender
- Key — varchar(100) — Primary key — NOT NULL
- userId — varchar(100) — Foreign key → user.userId — NOT NULL
- date — DATETIME
- context — text
category
- Key — varchar(100) — Primary key — NOT NULL
- userId — varchar(100) — Foreign key → user.userId — NOT NULL
- category — text
earn
- Key — int — Primary key — NOT NULL
- userId — varchar(100) — Foreign key → user.userId — NOT NULL
- date — DATETIME
- amount (amout) — int
user
- userId — varchar(100) — Primary key — NOT NULL
- password — varchar(100)
- email — varchar(100)