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