AeilFinance
Tables (6)
Person
- PerID — varchar — Primary key — NOT NULL
- BirthYear — int
- Field2 (Name) — varchar
- Field (Gender) — int
- Field (Title) — int — 1. 교역자, 2. 장로, 3. 권사, 4. 시무집사 5. 서리집사, 6.평신도
Untitled (OfferCat)
- Key (IcID) — varchar — Primary key — NOT NULL
- Field (FisrtCat) — int — 1 - 일반헌금, 2-목적헌금, 3-절기헌금, 4-특별헌금, 5-후원금, 6-기타 (수입이자, 기타수입, 반환금)
- Field (SubCat) — int — 일반헌금 (1.십일조, 2.감사헌금, 3.주일헌금, 4, 수요헌금, 5.구역헌금, 6.교회학교) 목적헌금 (1.선교헌금, 2.장학헌금) 절기헌금 (1.새해첫예물, 2.부활절헌금, 3.설립기념일, 4.맥추감사절, 5…
- Field (Name) — varchar
- Field (UseFlag) — boolean
Untitled (Income)
- Key (ID) — varchar — Primary key — NOT NULL
- Field (PerExID) — varchar
- Field (Date) — Date
- Field (Year) — int
- Field (Month) — int
- Field (Day) — int
- 몇번째 주 (OrdOfMonth) — int — 몇번째 주 여부
- Field (Amount) — int
- Field (Online) — boolean
Untitled (ExpendCat)
- Key (OcID) — varchar — Primary key — NOT NULL
- Field (FirstCat) — int — 1 -예배비, 2-교제비, 3-교육비, 4-봉사비, 5-교구비, 6-선교비, 7-사례비, 8-운영비, 9-관리비, 10-기타비
- Field (SubCat) — int
- Field (Name) — varchar
- Field (UseFlag) — boolean
Untitled (Expense)
- Key (ID) — varchar — Primary key — NOT NULL
- Field (Date) — Date
- Field (Year) — int
- Field (Month) — int
- Field (Day) — int
- Field (OrdOfMonth) — int
- Field (Amount) — int
Untitled (HusWife)
- Key (HwID) — varchar — Primary key — NOT NULL
- PerID (Husband) — varchar — Foreign key → Person.PerID — NOT NULL
- PerID (Wife) — varchar — Foreign key → Person.PerID — NOT NULL
- Field (Name) — varchar