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