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 — =