예산
테이블 (8)
budget
- budget_seq — BIGINT — 기본 키 — NOT NULL
- budget_request_group_seq — BIGINT — 외래 키 → budget_request_group.budget_request_group_seq — NOT NULL
- budget_belonging_department_code — VARCHAR(10) — NOT NULL
- assignment_code_seq — BIGINT — NOT NULL
- budget_account_code — VARCHAR(10) — NOT NULL
- budget_cost_item_code — VARCHAR(1000) — NOT NULL
- budget_cost_result_reason — VARCHAR(1000) — NOT NULL
- budget_cost_type — VARCHAR(10) — NOT NULL
- budget_asset_category_code — VARCHAR(10) — NOT NULL
- budget_control_cycle_code — VARCHAR(10) — NOT NULL
- budget_fa_code_seq — VARCHAR(10) — NOT NULL
budget_admin
- budget_admin_seq — BIGINT — 기본 키 — NOT NULL
- budget_seq — BIGINT — 외래 키 → budget.budget_seq — NOT NULL
- budget_control_cycle_code — VARCHAR(10) — NOT NULL
- amortization_yn — BIT(1) — NOT NULL
budget_amount
- budget_amount_seq — BIGINT — 기본 키 — NOT NULL
- budget_seq — BIGINT — 외래 키 → budget.budget_seq — NOT NULL
- budget_amount_month — VARCHAR(10) — NOT NULL
- budget_amount_value — BIGINT — NOT NULL
- budget_amount_code — VARCHAR(10) — NOT NULL
budget_confirm_history
- budget_confirm_history_seq — BIGINT — 기본 키 — NOT NULL
- budget_main_seq — BIGINT — 외래 키 → budget_main.budget_main_seq — NOT NULL
- create_date — DATETIME — NOT NULL
- create_user — BIGINT — NOT NULL
budget_main
- budget_main_seq — BIGINT — 기본 키 — NOT NULL
- budget_year — SMALLINT — NOT NULL
- budget_type_code — VARCHAR(10) — NOT NULL
- budget_status_code — VARCHAR(10) — NOT NULL
- create_user — BIGINT — NOT NULL
- create_date — DATETIME — NOT NULL
- update_user — BIGINT — NOT NULL
- update_date — DATETIME — NOT NULL
- budget_temp_save_yn — BIT
- delete_yn — BIT
budget_request_group
- budget_request_group_seq — BIGINT — 기본 키 — NOT NULL
- budget_main_seq — BIGINT — 외래 키 → budget_main.budget_main_seq — NOT NULL
- budget_request_group_order — SMALLINT — NOT NULL
summary_
- Key — VARCHAR(255) — NOT NULL
- Key2 — VARCHAR(255) — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
summary_main
- Key — VARCHAR(255) — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field13 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field9 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field5 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field7 — VARCHAR(255)
- Field8 — VARCHAR(255)
- Field10 — VARCHAR(255)
- Field11 — VARCHAR(255)
- Field12 — VARCHAR(255)