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