BIZ001
Tables (8)
dbo.TB_CODE
- GROUP_CD — varchar(20) — Primary key — NOT NULL
- SUB_CD — varchar(20) — Primary key — NOT NULL
- CD_NM — varchar(255)
- SORT_SEQ — int
- VALUE_01 — nvarchar(255)
- VALUE_02 — nvarchar(255)
- VALUE_03 — nvarchar(255)
- VALUE_04 — nvarchar(255)
- VALUE_05 — nvarchar(255)
- REMARK — varchar(255)
- SYSTEM_YN — char(1)
- USE_YN — char(10)
- ISRT_USER — varchar(20)
- UPDT_USER — varchar(20)
- ISRT_DTTM — datetime
- UPDT_DTTM — datetime
- PLANT_ID — varchar(20) — Foreign key → dbo.TB_PART_SPEC.PLANT_ID — NOT NULL
- SPEC_ID — varchar(20) — Foreign key → dbo.TB_PART_SPEC.SPEC_ID — NOT NULL
dbo.TB_CUST
- PLANT_ID — varchar(20) — Primary key — NOT NULL
- CUST_ID — varchar(20) — Primary key — NOT NULL
- CORPO_NO — varchar(255)
- CUST_NAME — varchar(255)
- CUST_SHT_NAME — varchar(255)
- CEO_NAME — varchar(255)
- TEL — varchar(255)
- FAX — varchar(255)
- POST — varchar(255)
- ADDR — varchar(255)
- IS_LOCATION — int
- WORK_STATUS — char(1)
- CURRENT_STATUS — varchar(255)
- CREDIT_STATUS — varchar(255)
- BUSINESS_INFO — varchar(255)
- ITEM_INFO — varchar(255)
- HOMEPAGE — varchar(255)
- CUST_EMP — varchar(255)
- CUST_EMP_TEL — varchar(255)
- CUST_EMP_FAX — varchar(255)
- CUST_EMP_HP — varchar(255)
- CUST_EMP_EMAIL — varchar(255)
- BILL_LIMIT_ID — varchar(20)
- CUST_TYPE_ID — varchar(20)
- CREDIT_LIMIT — money
- COST_RATE_TYPE_ID — varchar(20)
- REMAIN_PRICE — bigint
- BANK_NO — varchar(50)
- TAX_GUBUN — char(1)
- FOUND_DATE — varchar(10)
- BASE_YEAR — char(4)
- COMPANY_TYPE — varchar(20)
- CUST_CAPITAL — money
- CUST_SALES_PRICE — money
- CUST_ASSETS_PRICE — money
- CUST_SALES_BENEFIT — money
- CUST_SALES_REMARK — varchar(255)
- BIZ_MONTH_COUNT — varchar(50)
- BIZ_SALES_DATE_TYPE — varchar(20)
- BIZ_PART_NAME — varchar(50)
- BIZ_ITEM_NAME — varchar(50)
- BIZ_BUYER — varchar(50)
- BIZ_ITEM_CUST — varchar(50)
- BIZ_PLANT — varchar(255)
- BIZ_TAX_TYPE — char(1)
- BIZ_PAY_TYPE — varchar(50)
- BIZ_MOLD_LOC — char(1)
- BIZ_REMARK — varchar(255)
- VALID — int
- USE_YN — char(1)
- REMARK — varchar(255)
- ISRT_DTTM — datetime
- UPDT_DTTM — datetime
- ISRT_USER — varchar(20)
- UPDT_USER — varchar(20)
- PLANT_ID (PLANT_ID2) — varchar(20) — Foreign key → dbo.TB_PART_SPEC.PLANT_ID — NOT NULL
- SPEC_ID — varchar(20) — Foreign key → dbo.TB_PART_SPEC.SPEC_ID — NOT NULL
dbo.TB_ITEM
- PLANT_ID — varchar(20) — Primary key — NOT NULL
- ITEM_ID — varchar(20) — Primary key — NOT NULL
- ITEM_NAME — varchar(50)
- ITEM_SPEC — varchar(255)
- ITEM_GROUP_01 — varchar(20)
- ITEM_GROUP_02 — varchar(20)
- ITEM_GROUP_03 — varchar(20)
- ITEM_WEIGHT — numeric(10,2)
- ITEM_UNIT — varchar(20)
- PROC_ID — varchar(20)
- STOCK_TYPE — char(1)
- USE_YN — char(1)
- REMARK — varchar(255)
- ISRT_USER — varchar(20)
- UPDT_USER — varchar(20)
- ISRT_DTTM — datetime
- UPDT_DTTM — datetime
- PLANT_ID (PLANT_ID2) — varchar(20) — Foreign key → dbo.TB_PART_SPEC.PLANT_ID — NOT NULL
- SPEC_ID — varchar(20) — Foreign key → dbo.TB_PART_SPEC.SPEC_ID — NOT NULL
dbo.TB_PART_ORDER
- PLANT_ID — varchar(20) — Primary key — NOT NULL
- ORDER_ID — varchar(20) — Primary key — NOT NULL
- ORDER_CUST_ID — varchar(20) — NOT NULL
- PART_NAME — varchar(255) — NOT NULL
- SPEC_ID — varchar(20) — NOT NULL
- DELV_CUST_ID — varchar(20)
- PART_TYPE — char(1)
- SALE_TYPE — varchar(20)
- ORDER_DATE — varchar(10)
- ORDER_RCP_DATE — varchar(10)
- ORDER_QTY — int
- UNIT_PRICE — money
- TOTAL_PRICE — money
- EXPECT_BENEFIT — money
- DELV_DATE — varchar(10)
- DELV_LOC — varchar(255)
- BOARD_COUNT — int
- LOSS_PRINT_COUNT — int
- LPP_LOSS_COUNT — int
- LOSS_REMARK — varchar(255)
- PROD_YN — char(1)
- END_YN — char(1)
- REWORK_YN — bit
- ORDER_EMP_ID — varchar(20)
- PALLET_DESC — varchar(255)
- REMARK — varchar(255)
- ISRT_USER — varchar(20)
- UPDT_USER — varchar(20)
- ISRT_DTTM — datetime
- UPDT_DTTM — datetime
- ROW_STAMP — bigint — NOT NULL
- PLANT_ID (PLANT_ID2) — varchar(20) — Foreign key → dbo.TB_PART_SPEC.PLANT_ID — NOT NULL
- SPEC_ID (SPEC_ID2) — varchar(20) — Foreign key → dbo.TB_PART_SPEC.SPEC_ID — NOT NULL
dbo.TB_PART_SPEC
- PLANT_ID — varchar(20) — Primary key — NOT NULL
- SPEC_ID — varchar(20) — Primary key — NOT NULL
- SPEC_NAME — varchar(255) — NOT NULL
- SPEC_GROUP_ID — varchar(20)
- CUST_ID — varchar(20)
- ORDER_TYPE — char(1)
- CUST_PART_ID — varchar(30)
- CUST_EMP_ID — varchar(20)
- SPEC_COLOR — varchar(20)
- SPEC_HOSU — numeric(10,2)
- SPEC_WIDTH — numeric(10,3)
- SPEC_DEPTH — numeric(10,3)
- SPEC_HEIGHT — numeric(10,3)
- PLATE_HANGER_COUNT — int
- COLOR_REMARK — varchar(255)
- REMARK — varchar(500)
- ISRT_USER — varchar(20)
- UPDT_USER — varchar(20)
- ISRT_DTTM — datetime
- UPDT_DTTM — datetime
dbo.TB_PART_SPEC_DETAIL
- PLANT_ID — varchar(20) — Primary key — NOT NULL
- SPEC_ID — varchar(20) — Primary key — NOT NULL
- PROC_ID — varchar(20) — Primary key — NOT NULL
- PROC_SEQ — int — NOT NULL
- PROD_UNIT — varchar(20)
- PROD_METHOD — varchar(20)
- ITEM_ID — varchar(20)
- PROD_WIDTH — numeric(10,2)
- PROD_LENGTH — numeric(10,2)
- USE_QTY — int
- OUT_YN — bit
- DEGREASING_YN — bit
- REMARK — varchar(255)
- ISRT_USER — varchar(20)
- UPDT_USER — varchar(20)
- ISRT_DTTM — datetime
- UPDT_DTTM — datetime
- PLANT_ID (PLANT_ID2) — varchar(20) — Foreign key → dbo.TB_PART_SPEC.PLANT_ID — NOT NULL
- SPEC_ID (SPEC_ID2) — varchar(20) — Foreign key → dbo.TB_PART_SPEC.SPEC_ID — NOT NULL
dbo.TB_PART_SPEC_IMAGE
- PLANT_ID — varchar(20) — Primary key — NOT NULL
- SPEC_ID — varchar(20) — Primary key — NOT NULL
- ISRT_USER — varchar(20)
- UPDT_USER — varchar(20)
- ISRT_DTTM — datetime
- UPDT_DTTM — datetime
- SPEC_IMAGE — varchar(20)
- PLANT_ID (PLANT_ID2) — varchar(20) — Foreign key → dbo.TB_PART_SPEC.PLANT_ID — NOT NULL
- SPEC_ID (SPEC_ID2) — varchar(20) — Foreign key → dbo.TB_PART_SPEC.SPEC_ID — NOT NULL
dbo.TB_PROC
- PLANT_ID — varchar(20) — Primary key — NOT NULL
- PROC_ID — varchar(20) — Primary key — NOT NULL
- PROC_NAME — nchar(10)
- PROC_SEQ — int
- PROD_OUT_YN — char(1)
- PROD_METHOD_CD — varchar(255)
- REMARK — varchar(255)
- ISRT_USER — varchar(20)
- UPDT_USER — varchar(20)
- ISRT_DTTM — datetime
- UPDT_DTTM — datetime
- PLANT_ID (PLANT_ID2) — varchar(20) — Foreign key → dbo.TB_PART_SPEC_DETAIL.PLANT_ID — NOT NULL
- SPEC_ID — varchar(20) — Foreign key → dbo.TB_PART_SPEC_DETAIL.SPEC_ID — NOT NULL
- PROC_ID (PROC_ID2) — varchar(20) — Foreign key → dbo.TB_PART_SPEC_DETAIL.PROC_ID — NOT NULL