week4-5

Tables (3)

CashBook (CopyOfUntitled)

  • Key — Primary key — NOT NULL
  • id (Field2) — int
  • category (Field3)
  • category_type (Field4)
  • memo (Field5)
  • payment (Field) — string
  • price (Field6) — int
  • date (Field7) — date
  • user_id (Field8) — string

Payment (CopyOfUntitled2)

  • Key — Primary key — NOT NULL
  • id (Field) — int
  • user_id (Field2) — string
  • name (Field3) — string

User (Untitled)

  • Key — Primary key — NOT NULL
  • id (Field3) — int
  • user_id (Field) — string