가계부
테이블 (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)