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