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)