AeilAccbook
Tables (7)
tblCom (Committee Table)
- colInd — string — Primary key — NOT NULL
- colName — string
- colResv — string
tblElement (Elements Table)
- colInd — string — Primary key — NOT NULL
- colFlag — int — 0 - Income 1 - Expenditure else - Comment
- colCat — string
- colCatName — string
- colSubcat — string
- colSubName — string
- colRes — string
- colRes2 — string
- colRes3 — string
tblExpend (Expenditure Table)
- colInd — string — Primary key — NOT NULL
- colElm — string — Foreign key → tblElement.colInd — NOT NULL
- colCom — string — Foreign key → tblCom.colInd — NOT NULL
- colDT — datetime
- colCont — string
- colValue — long
- colCmh — string — 위원장
- colReq — string — 청구자
- colAprv — string — 승인자
- colWay — int — 0 - 직접수령 1 - 대리수령 2 - 은행송금 3 - 카드 4 - 자동이체 5 - 미지급 6 - 기타
- colRemark — string — 청구방법에대한 비고 설명작성
- colResv01 — string
- colResv02 — string
- colResv03 — string
tblOfferings (Offerings Table)
- colInd — string — Primary key — NOT NULL
- colElm — string — Foreign key → tblElement.colInd — NOT NULL
- colDT — datetime
- colName — string
- colName2 — string
- colName3 — string
- colValue — long
- colResv — string
tblRemainder (Yearly Remainders Table)
- colRmInd — DT_long_msec — Primary key — NOT NULL
- colYear — int
- colRmd — long
- colResv — string
tblYearlyBudget (Yearly Budget Table)
- colInd — string — Primary key — NOT NULL
- colElm (colInd2) — string — Foreign key → tblElement.colInd — NOT NULL
- colYear — int
- colAmount — int
- colResv01 — string
- colResv02 — string
viewIncome (Income View)
- colInd — string — Primary key — NOT NULL
- colDT — datetime
- colCont — string
- colValue — long
- colRemark — string
- colElm — string