erd
Tables (4)
tb_org_user (사용자)
- user_id (Key) — 사용자ID — Primary key — NOT NULL
- Field
tb_wbs (Untitled)
- wbs_id (Key) — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
tb_wbs_budget (wbs)
- wbs_id (Key) — wbs아이디 — Primary key — NOT NULL
- account_code (Key2) — Primary key — NOT NULL
- account_name (Field1) — wbs 명
- rst_amt (Field2) — 처리완료금액
- non_bdget (Field3) — 저장금액
- base_amt (Field4) — 편성예산
- rmt_amt (Field5) — 잔여금액
tb_wbs_user (wbs-사용자 매핑)
- wbs_id (Key) — wbs아이디 — Primary key — NOT NULL
- user_id (Key2) — 사용자ID — Primary key — NOT NULL
- reg_date (Field) — 기준일자
- delete_yn (Field2) — 삭제여부
- wbs_name (Field3) — wbs이름
- user_id (Key3) — 사용자ID — Foreign key → tb_org_user.user_id — NOT NULL
- wbs_id (Key4) — wbs아이디 — Foreign key → tb_wbs_budget.wbs_id — NOT NULL
- Key2 (Key22) — Foreign key → tb_wbs_budget.account_code — NOT NULL