우테캠 가계부

테이블 (3)

Payment (Untitled2)

  • id (Key) — int — 기본 키 — NOT NULL
  • user_id (Key2) — int — 외래 키 → User.id — NOT NULL
  • name (Field) — varchar

TransactionHisotry (Untitled)

  • id — int — 기본 키 — NOT NULL
  • payment_id (Key2) — int — 외래 키 → Payment.id — NOT NULL
  • user_id (Key22) — int — 외래 키 → Payment.user_id — NOT NULL
  • payment_type (Field) — varchar
  • payment_date (Field2) — datetime
  • category (Field3) — varchar
  • charge (Field5) — int
  • description (Field6) — varchar
  • softDelete (Field7) — bool

User (Untitled3)

  • id (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchar