JG ICCU

Tables (4)

tbData1 (Untitled)

  • Barcode1 (Key2) — varchar(50) — Foreign key → tbMain.Barcode1 — NOT NULL
  • Barcode2 (Key22) — varchar(50) — Foreign key → tbMain.Barcode2 — NOT NULL
  • WorkDate (Field1) — varchar(8)
  • WorTime (Field2) — varchar(6)
  • Model (Field3) — varchar(10)
  • D1 (Field6) — varchar(10)
  • R1 (Field7) — varchar(2)
  • D2 (Field8) — varchar(10)
  • R2 (Field9) — varchar(2)

tbData2 (CopyOfUntitled)

  • Barcode1 (Key2) — varchar(50) — Foreign key → tbMain.Barcode1 — NOT NULL
  • Barcode2 (Key22) — varchar(50) — Foreign key → tbMain.Barcode2 — NOT NULL
  • WorkDate (Field1) — varchar(8)
  • WorTime (Field2) — varchar(6)
  • Model (Field3) — varchar(10)
  • R1 (Field7) — varchar(2)

tbData3 (CopyOfCopyOfUntitled)

  • Barcode1 (Key2) — varchar(50) — Foreign key → tbMain.Barcode1 — NOT NULL
  • Barcode2 (Key22) — varchar(50) — Foreign key → tbMain.Barcode2 — NOT NULL
  • WorkDate (Field1) — varchar(8)
  • WorTime (Field2) — varchar(6)
  • Model (Field3) — varchar(10)
  • R1 (Field7) — varchar(2)

tbMain (CopyOfCopyOfCopyOfUntitled)

  • Barcode1 (Key) — varchar(50) — Primary key — NOT NULL
  • Barcode2 (Key2) — varchar(50) — Primary key — NOT NULL
  • WorkDate (Field1) — varchar(8)
  • WorTime (Field2) — varchar(6)
  • Model (Field3) — varchar(10)
  • D1 (Field6) — varchar(10)
  • R1 (Field7) — varchar(2)
  • D2 (Field8) — varchar(10)
  • R2 (Field9) — varchar(2)
  • D3 (Field4) — varchar(10)
  • R3 (Field5) — varchar(2)
  • D4 (Field10)
  • R4 (Field11) — varchar(2)