SINYANG_DEV
Tables (12)
SY_PM_MA_I/O (Untitled2)
- SEQ (PK) — INT — Primary key — NOT NULL
- INCOME_DATE (Field) — NVARCHAR(255)
- OUT_DATE (Field2) — NVARCHAR(255)
- I/O_QUANTITY (Field3) — INT
- FK_SY_PM_MA_MASTER (PK2) — INT — Foreign key → T_KA_MA_MASTER.SEQ — NOT NULL
T_KA_COMMON_CODE (Untitled3)
- SEQ (PK) — INT — Primary key — NOT NULL
- CODE_STR (Field) — NVARCHAR(1800)
- CODE_GB (Field2) — NVARCHAR(255)
- CODE_DEP (Field3) — NVARCHAR(255)
- CODE_DEP_TITLE (Field4) — NVARCHAR(255)
T_KA_COMPANY_CODE_2 (Untitled4)
- SEQ (PK) — INT — Primary key — NOT NULL
- COMPANY_NM (Field) — NVARCHAR(300)
- COMPANY_TEL (Field5) — NVARCHAR(300)
- COMPANY_ETC (Field6) — NVARCHAR(3000)
- COMPANY_NUM (Field7) — NVARCHAR(300)
- COMPANY_ADD (Field8) — NVARCHAR(300)
- COMPANY_WEB (Field4) — NVARCHAR(300)
- COMPANY_GB_CC (Field2) — NVARCHAR(300)
- DEL_GB_CC (Field3) — INT
T_KA_EQ_MASTER (Untitled12)
- SEQ (PK) — INT — Primary key — NOT NULL
- EQ_NAME (Field) — NVARCHAR(300)
- EQ_NUM (Field2) — INT
- DEL_GB_CC (Field3) — INT
T_KA_MA_MASTER (Untitled)
- SEQ (PK) — INT — Primary key — NOT NULL
- MA_CODE (Field2) — NVARCHAR(255)
- MA_STANDARD (Field4) — NVARCHAR(255)
- MA_QTY (Field3) — INT
- MATERIAL_CLASS_CS (Field5) — INT
- DEL_CC (Field6) — INT
T_KA_PRODUCT_COMBINATION (Untitled7)
- SEQ (PK) — INT — Primary key — NOT NULL
- FK_SY_KA_PRODUCT_MASTER_SEQ (FK) — INT — Foreign key → T_KA_PRODUCT_MASTER.SEQ — NOT NULL
- FK_SY_KA_MA_MASTER_SEQ (FK2) — INT — Foreign key → T_KA_MA_MASTER.SEQ — NOT NULL
- MIXING_RATIO (Field3) — INT
- DEL_GB_CC (Field2) — INT
- UPDATE_GB_CC (Field) — INT
T_KA_PRODUCT_MASTER (Untitled5)
- SEQ (PK) — INT — Primary key — NOT NULL
- MODEL_CODE (Field) — NVARCHAR(255)
- PRODUCT_QTY (Field2) — INT
- PRODUCTION_TIME (Field3) — NVARCHAR(255)
- DEL_GB_CC (Field4) — INT — NOT NULL
T_KA_WORKER (Untitled8)
- SEQ (PK) — INT — Primary key — NOT NULL
- WORKER_NM (Field) — NVARCHAR(300)
- WORKER_TEL (Field2) — NVARCHAR(300)
- WORKER_POSITION (Field3) — NVARCHAR(300)
- ETC_CONTENT (Field4) — NVARCHAR(2000)
- DEL_GB_CC (Field5) — INT
T_KG_MOLD_HISTORY (Untitled9)
- SEQ (PK) — INT — Primary key — NOT NULL
- Field
T_KG_MOLD_MASTER (Untitled6)
- SEQ (PK) — INT — Primary key — NOT NULL
- MOLD_CODE (Field) — NVARCHAR(255)
- MOLD_INFO (Field2) — NVARCHAR(255)
- FK_T_KA_PRODUCT_MASTER_SEQ (FK) — INT — Foreign key → T_KA_PRODUCT_MASTER.SEQ — NOT NULL
T_SB_ORDER (Untitled10)
- SEQ (PK) — INT — Primary key — NOT NULL
- MODEL_NM (Field8) — NVARCHAR(30)
- COLOR_STANDARD (Field) — NVARCHAR(20)
- ORDER_QTY (Field2) — INT
- ORDER_PRICE (Field3) — INT
- ORDER_DATE (Field4) — NVARCHAR(30)
- DELIVERY_DATE (Field5) — NVARCHAR(30)
- ORDER_CONTENT (Field6) — NVARCHAR(2000)
- DEL_GB_CC (Field7) — INT
- FK_T_KA_PRODUCT_MASTER_SEQ (FK) — INT — Foreign key → T_KA_PRODUCT_MASTER.SEQ — NOT NULL
- FK_T_KA_MA_MASTER_SEQ (FK2) — INT — Foreign key → T_KA_MA_MASTER.SEQ — NOT NULL
- FK_T_KA_COMPANY_CODE_2_SEQ (FK3) — INT — Foreign key → T_KA_COMPANY_CODE_2.SEQ — NOT NULL
T_SB_PLAN (Untitled11)
- SEQ (PK) — INT — Primary key — NOT NULL
- START_TIME (Field) — NVARCHAR(300)
- END_TIME (Field2) — NVARCJAR(300)
- FK_T_KA_PRODUCT_MASTER_SEQ (FK) — INT — Foreign key → T_KA_PRODUCT_MASTER.SEQ — NOT NULL
- FK_T_KA_EQ_MASTER_SEQ (FK2) — INT — Foreign key → T_KA_EQ_MASTER.SEQ — NOT NULL