가계부

테이블 (7)

Check (Untitled4)

  • Mno[PK][FK] (Key2) — 외래 키 → Member.Mno[PK] — NOT NULL
  • GoalAmount (Field)
  • Deadline (Field2)
  • Dday (Field3)
  • MonthLimitCash (Field4)
  • MonthLimitCard (Field5)

Expenditure (d)

  • EEventNo (PK) — 기본 키 — NOT NULL — PK
  • Eno (FK) — 외래 키 → ExpenditureCategory.Eno — NOT NULL
  • Mno (FK2) — 외래 키 → Member.Mno[PK] — NOT NULL
  • ExDate (Field)
  • ExMemo (Field2)
  • ExCash (Field3)
  • ExCard (Field4)

ExpenditureCategory (CopyOfUntitled3)

  • Eno (Key) — 기본 키 — NOT NULL
  • Emain (Field)
  • Esub (Field2)

Income (Untitled2)

  • IEventNo[PK] (PK) — 기본 키 — NOT NULL — PK
  • Ino (Key) — 외래 키 → IncomeCategory.Ino — NOT NULL
  • Mno (FK2) — 외래 키 → Member.Mno[PK] — NOT NULL
  • InDate (Field)
  • InMemo (Field2)
  • InCash (Field3)
  • InCard (Field4)

IncomeCategory (Untitled3)

  • Ino (PK) — 기본 키 — NOT NULL
  • Imain (Field)
  • Isub (Field2)

Member (Untitled)

  • Mno[PK] (Key) — 기본 키 — NOT NULL
  • FirstName (Field)
  • Lastname (Field2)
  • Age (Field3)
  • Email (Field4)
  • CurrentCash (Field5)
  • CurrentCard (Field6)

Member_ExpCategory (Untitled5)

  • EEventNo (PK, FK) — 기본 키 — NOT NULL — PK
  • Eno (FK) — 외래 키 → Expenditure.Eno — NOT NULL
  • Mno (FK2) — 외래 키 → Member.Mno[PK] — NOT NULL
  • ExCash (Field)
  • ExCard (Field2)