budget

Tables (13)

account (예산 항목)

  • account_id (PK) — NOTNULL — Primary key — NOT NULL
  • account_name (항목명(인건비 복리후생비)) — NOTNULL
  • description (설명 ( 급여 ,상여, 4대보험)) — NOTNULL

approval_step (결재 단계 테이블)

  • step_id (PK) — NOTNULL — Primary key — NOT NULL
  • request_id (예산신청id) — NOTNULL — Foreign key → budget_request.request_id — NOT NULL
  • approver_id (결재자id(user_id)) — NOTNULL — Foreign key → user.user_id — NOT NULL
  • set_order (결재순서) — NOTNULL
  • approved_at (승인일)
  • setp_status (상태(대기,승인,반려)) — NOTNULL
  • comment (코멘트)

asset (자산)

  • asset_id (PK) — NOTNULL — Primary key — NOT NULL
  • asset_code (자산코드) — NOTNULL
  • asset_name (자산명) — NOTNULL
  • purchase_date (취득일) — NOTNULL
  • purchase_amount (취득가) — NOTNULL
  • status (상태) — NOTNULL
  • vendor_id (거래처id) — NOTNULL — Foreign key → vendor.vendor_id — NOT NULL
  • custodian_user_id (user_id 현담당자) — NOTNULL — Foreign key → user.user_id — NOT NULL
  • category_id (자산분류id) — NOTNULL — Foreign key → asset_category.category_id — NOT NULL

asset_assignment (자산 배령 이력)

  • assign_id (PK) — NOTNULL — Primary key — NOT NULL
  • start_date (배정시작일) — NOTNULL
  • end_date (배정 종료일)
  • note (메모)
  • asset_id (자산id) — NOTNULL — Foreign key → asset.asset_id — NOT NULL
  • dept_id (부서id) — NOTNULL — Foreign key → dept.dept_id — NOT NULL — 부서ID (PK)
  • user_id (담당자id) — NOTNULL — Foreign key → user.user_id — NOT NULL

asset_category (자산 분류)

  • category_id (PK) — NOTNULL — Primary key — NOT NULL
  • category_name (분류명) — NOTNULL

budget (예산)

  • budget_id (PK) — NOTNULL — Primary key — NOT NULL
  • fiscal_year (회계연도(yyyy)) — NOTNULL
  • period (기간('y','Q1','2025-03' 등) — NOTNULL
  • amount_plan (예상 예산) — NOTNULL
  • carryover_rate (이월율) — NOTNULL
  • notes (메모)
  • dept_id (부서id) — NOTNULL — Foreign key → dept.dept_id — NOT NULL — 부서ID (PK)
  • account_id (항목id) — NOTNULL — Foreign key → account.account_id — NOT NULL

budget_policy (예산 정책 테이블)

  • policy_id (PK) — NOTNULL — Primary key — NOT NULL — 항목명
  • policy_name (정책명) — NOTNULL — NOT NULL — 유형(opex/capex)
  • policy_desc (정책설명) — NOTNULL — 예산ID (PK)
  • account_type (계정유형(OPEX,CAPEX)) — NOTNULL
  • limit_mount (건별 예산 한도) — NOTNULL

budget_request (예산 집행 신청)

  • request_id (PK) — NOTNULL — Primary key — NOT NULL
  • request_date (신청일) — NOTNULL
  • amount (신청금액) — NOTNULL
  • description (사용 목정) — NOTNULL
  • evidence_no (증빙번호(세금 계산서 영수증번호 등)) — NOTNULL
  • status (상태(대기,승인,반려,정산완료)) — NOTNULL
  • user_id (신청자id) — NOTNULL — Foreign key → user.user_id — NOT NULL
  • dept_id (부서id) — NOTNULL — Foreign key → dept.dept_id — NOT NULL — 부서ID (PK)
  • policy_id (정책id) — NOTNULL — Foreign key → budget_policy.policy_id — NOT NULL — 항목명

commitment (집행 예약(미결의))

  • commit_id (PK) — NOTNULL — Primary key — NOT NULL
  • budget_id (예산id) — NOTNULL — Foreign key → budget.budget_id — NOT NULL
  • req_dt (요청일) — NOTNULL
  • amount_commit (예약금액(계약/발주액)) — NOTNULL
  • status (상태 (REQUESTED / APPROVED / REJECTED / CLOSED)) — NOTNULL
  • vendor_id (거래처id) — NOTNULL — Foreign key → vendor.vendor_id — NOT NULL

dept (부서)

  • dept_id (PK) — NOTNULL — Primary key — NOT NULL — 부서ID (PK)
  • menager_id (매니저id(user_id) 연결) — NOTNULL — Foreign key → user.user_id — NOT NULL
  • dept_name (부서명) — NOTNULL — NOT NULL — 부서명

payment (정산)

  • payment_id (PK) — NOTNULL — Primary key — NOT NULL
  • request_id (신청id) — NOTNULL — Foreign key → budget_request.request_id — NOT NULL
  • paid_amount (실제 지출금액) — NOTNULL
  • paid_date (지출일) — NOTNULL
  • payment_method (걀제방법(카드/계좌/현금)) — NOTNULL
  • remark (비고)
  • doc_no (wmdqldqjsgh) — NOTNULL
  • vendor_id (거래처id) — NOTNULL — Foreign key → vendor.vendor_id — NOT NULL
  • account_id (예산 항목id) — NOTNULL — Foreign key → account.account_id — NOT NULL

user (유저)

  • user_id (PK) — NOTNULL — Primary key — NOT NULL
  • dept_id (부서id) — NOTNULL — Foreign key → dept.dept_id — NOT NULL — 부서ID (PK)
  • user_name (사용자명) — NOTNULL
  • role (역할) — NOTNULL
  • email (이메일) — NOTNULL
  • phone (연락처) — NOTNULL

vendor (거래처)

  • vendor_id (PK) — NOTNULL — Primary key — NOT NULL
  • vendor_name (거래처명) — NOTNULL
  • contact_name (담당자명) — NOTNULL
  • contact_phone (담당자 번호) — NOTNULL
  • status (성태) — NOTNULL