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