KITT_MSSQL

KITT그룹웨어 기존 MSSQL 구조

테이블 (4)

ITD_COMPANY

  • OLD_NAME — nvarchar(255)
  • NEW_NAME — nvarchar(255)

TB_BIZ_PLAN_COST_INFO

  • BPCI_IDX — int — 기본 키 — NOT NULL
  • COST_TYPE — char(1)
  • DATE_VAL — varchar(10)
  • COMPANY_NAME — varchar(100)
  • ITEM_NAME — varchar(150)
  • DETAIL_CONTENT — varchar(150)
  • QUANTITY — int
  • UNIT_PRICE — int
  • PRICE — int
  • NOTE — varchar(150)
  • BP_IDX — int
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =

TB_BIZ_PLAN_COST_INFO_BAK

  • BPCI_IDX — int — NOT NULL
  • COST_TYPE — char(1)
  • DATE_VAL — varchar(10)
  • COMPANY_NAME — varchar(100)
  • ITEM_NAME — varchar(150)
  • DETAIL_CONTENT — varchar(150)
  • QUANTITY — int
  • UNIT_PRICE — int
  • PRICE — int
  • NOTE — varchar(150)
  • BP_IDX — int

TB_BIZ_PLAN_INFO

  • BP_IDX — int — 기본 키 — NOT NULL
  • MOTION_DATE — varchar(10)
  • MOTION_PART — char(4)
  • MOTION_USER — varchar(20)
  • COMPANY_NAME — varchar(100)
  • COMPANY_TYPE — char(18)
  • PLAN_NAME — varchar(150)
  • SETTLE_TERM — varchar(100)
  • MEMO — varchar(max)
  • SP_IDX — int
  • FINISH_YN — char(1)
  • ALLOW_YN — char(1)
  • DEADLINE_YN — char(1)
  • MANAGE_YN — char(1)
  • RESELLER_NAME — varchar(100) — Reseller 상호
  • END_USER_NAME — varchar(100) — EndUser 상호
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =
  • OPTIMIZE_FOR_SEQUENTIAL_KEY — =