CJC_CLOUD_ERD

Tables (38)

TB_AS (Untitled26)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • AsNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • OrderNo (Field) — NVARCHAR(20)
  • CustomerCd (Field2) — INT
  • CustomerPhone (Field3) — NVARCHAR(20)
  • ItemCd (Field4) — NVARCHAR(40)
  • AsType (Field5) — NVARCHAR(20)
  • AsRecvDt (Field6) — DATETIME
  • AsCompDt (Field7) — DATETIME
  • AsUserId (Field8) — INT
  • AsManagerId (Field9) — INT
  • ProcStatus (Field10) — NVARCHAR(10)
  • UptUserId (Field11) — NVARCHAR(100)
  • UptDate (Field12) — NVARCHAR(100)
  • Field13 — NVARCHAR(200)
  • RegUserId (Field14) — INT
  • RegDate (Field15) — DATETIME
  • UptUserId (Field16) — INT
  • UptDate (Field17) — DATETIME

TB_BOM (Untitled20)

  • CompCd (Key) — NVARCHAR — Primary key — NOT NULL
  • BizUnit (Key2) — NVARCHAR — Primary key — NOT NULL
  • FactBizUnit (Key3) — NVARCHAR — Primary key — NOT NULL
  • ItemCd (Key4) — NVARCHAR — Primary key — NOT NULL
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_WorkOrder.BizUnit — NOT NULL
  • WorkOrderNo (Key32) — NVARCHAR(20) — Foreign key → TB_WorkOrder.WorkOrderNo — NOT NULL
  • CompCd (Key42) — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • BizUnit (Key222) — CHAR(4) — Foreign key → TB_WorkOrder.BizUnit — NOT NULL
  • OrderNo (Key322) — NVARCHAR(20) — Foreign key → TB_WorkOrder.OrderNo — NOT NULL
  • CompCd (Key52) — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • BizUnit (Key23) — CHAR(4) — Foreign key → TB_WorkOrder.BizUnit — NOT NULL
  • WorkPlanNo (Key33) — NVARCHAR(20) — Foreign key → TB_WorkOrder.WorkPlanNo — NOT NULL
  • CompCd — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • UserCd (usercd) — INT — Foreign key → TB_WorkOrder.UserCd — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_WorkOrder.BizUnit — NOT NULL
  • GroupCd (groupcd2) — INT — Foreign key → TB_WorkOrder.GroupCd — NOT NULL
  • CompCd (CompCd22) — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • BizUnit (bizunit22) — CHAR(4) — Foreign key → TB_WorkOrder.BizUnit — NOT NULL
  • CompCd (CompCd3) — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_WorkOrder.BizUnit — NOT NULL
  • CompCd (CompCd4) — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • BizUnit (bizunit3) — CHAR(4) — Foreign key → TB_WorkOrder.BizUnit — NOT NULL
  • GroupCd (groupcd) — INT — Foreign key → TB_WorkOrder.GroupCd — NOT NULL
  • CompCd (CompCd23) — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • BizUnit (bizunit23) — CHAR(4) — Foreign key → TB_WorkOrder.BizUnit — NOT NULL
  • CompCd (Key422) — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • BizUnit (Key2222) — CHAR(13) — Foreign key → TB_WorkOrder.BizUnit — NOT NULL
  • ItemCd (Key4222) — NVARCHAR(40) — Foreign key → TB_WorkOrder.ItemCd — NOT NULL
  • CompCd (Key522) — CHAR(13) — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • ItemCd (Key232) — NVARCHAR(40) — Foreign key → TB_WorkOrder.ItemCd — NOT NULL
  • CompCd (Key6) — NVARCHAR — Foreign key → TB_WorkOrder.CompCd — NOT NULL
  • BizUnit (Key3222) — NVARCHAR — Foreign key → TB_WorkOrder.BizUnit — NOT NULL
  • FactBizUnit (Key43) — NVARCHAR — Foreign key → TB_WorkOrder.FactBizUnit — NOT NULL
  • ItemCd (Key24) — NVARCHAR — Foreign key → TB_WorkOrder.ItemCd — NOT NULL
  • CompCd (Key7) — CHAR(13) — Foreign key → TB_Item.CompCd — NOT NULL
  • BizUnit (Key25) — CHAR(13) — Foreign key → TB_Item.BizUnit — NOT NULL
  • ItemCd (Key44) — NVARCHAR(40) — Foreign key → TB_Item.ItemCd — NOT NULL
  • CompCd (Key8) — CHAR(13) — Foreign key → TB_WorkPerform.CompCd — NOT NULL
  • BizUnit (Key26) — CHAR(4) — Foreign key → TB_WorkPerform.BizUnit — NOT NULL
  • WorkPerformNo (Key34) — NVARCHAR(20) — Foreign key → TB_WorkPerform.WorkPerformNo — NOT NULL
  • CompCd (Key45) — CHAR(13) — Foreign key → TB_WorkPerform.CompCd — NOT NULL
  • BizUnit (Key223) — CHAR(13) — Foreign key → TB_WorkPerform.BizUnit — NOT NULL
  • ItemCd (Key423) — NVARCHAR(40) — Foreign key → TB_WorkPerform.ItemCd — NOT NULL
  • CompCd (CompCd5) — CHAR(13) — Foreign key → TB_WorkPerform.CompCd — NOT NULL
  • UserCd (usercd2) — INT — Foreign key → TB_WorkPerform.UserCd — NOT NULL
  • CompCd (CompCd24) — CHAR(13) — Foreign key → TB_WorkPerform.CompCd — NOT NULL
  • BizUnit (bizunit24) — CHAR(4) — Foreign key → TB_WorkPerform.BizUnit — NOT NULL
  • GroupCd (groupcd22) — INT — Foreign key → TB_WorkPerform.GroupCd — NOT NULL
  • CompCd (CompCd222) — CHAR(13) — Foreign key → TB_WorkPerform.CompCd — NOT NULL
  • BizUnit (bizunit222) — CHAR(4) — Foreign key → TB_WorkPerform.BizUnit — NOT NULL
  • Seq (Field) — INT
  • ParCd (Field2) — NVARCHAR
  • ReqQty (Field3) — DECIMAL
  • Remk (Field4) — NVARCHAR
  • RegUserId (Field5) — INT
  • RegDate (Field6) — DATETIME
  • UptUserId (Field7) — INT
  • UptDate (Field8) — DATETIME

TB_BizUnit (TB_BIzUnit)

  • CompCd — CHAR(13) — Primary key — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Primary key — NOT NULL
  • BizNm — NVARCHAR(30)
  • BizLoc — NVARCHAR(40)
  • BizType — CHAR(2)
  • OwnerNm — NVARCHAR(10)
  • PhoneNo — NVARCHAR(20)
  • LawBusiNo — NVARCHAR(20)
  • SoleBusiNo — NVARCHAR(20)
  • AnnualSales — NVARCHAR(20)
  • EmpNumber — INT
  • Country — NVARCHAR(20)
  • RegUserId — INT
  • RegDate — DATETIME
  • UptUserId — INT
  • UptDate — DATETIME
  • Field

TB_CheckStkItem (Untitled15)

  • CompCd (Key) — NVARCHAR — Primary key — NOT NULL
  • BizUnit (Key2) — NVARCHAR — Primary key — NOT NULL
  • ItemCd (Key3) — NVARCHAR — Primary key — NOT NULL
  • CheckSeq (Key4) — INT — Primary key — NOT NULL
  • CheckStkDate (Field) — NVARCHAR
  • WhCd (Field2) — NVARCHAR
  • CheckStkGroupCd (Field3) — INT
  • CheckStkUserId (Field4) — INT
  • Price (Field5) — DECIMAL
  • CheckStkQty (Field6) — DECIMAL
  • CheckStkAmt (Field7) — DECIMAL
  • SlipNo (Field8) — NVARCHAR
  • SlipSeq (Field9) — INT
  • DelYN (Field10) — NVARCHAR
  • Remk (Field11) — NVARCHAR
  • RegUserId (Field12) — INT
  • RegDate (Field13) — DATETIME
  • UptUserId (Field14) — INT
  • UptDate (Field15) — DATETIME

TB_CheckStkPDItem (Untitled14)

  • CompCd (Key) — NVARCHAR — Primary key — NOT NULL
  • BizUnit (Key2) — NVARCHAR — Primary key — NOT NULL
  • FactBizUnit (Key3) — NVARCHAR — Primary key — NOT NULL
  • ItemCd (Key4) — NVARCHAR — Primary key — NOT NULL
  • WhCd (Key5) — NVARCHAR — Primary key — NOT NULL
  • CheckSeq (Key6) — INT — Primary key — NOT NULL
  • CheckStkDate (Field) — NVARCHAR
  • CheckStkGroupCd (Field2) — INT
  • CheckStkUserId (Field3) — INT
  • Price (Field4) — DECIMAL
  • CheckStkQty (Field5) — DECIMAL
  • CheckStkAmt (Field6) — DECIMAL
  • SlipNo (Field7) — NVARCHAR
  • SlipSeq (Field8) — INT
  • DelYN (Field9) — NVARCHAR
  • Remk (Field10) — NVARCHAR
  • RegUserId (Field11) — INT
  • RegDate (Field12) — DATETIME
  • UptUserId (Field13) — INT
  • UptDate (Field14) — DATETIME

TB_CodeD

  • CompCd — CHAR(13) — Primary key — NOT NULL
  • CodeId (codeid) — INT — Primary key — NOT NULL
  • CodeSeq (codeseq) — INT
  • CodeNm (codenm) — NVARCHAR(40)
  • Remk (remk) — NVARCHAR(300)
  • RegUserId (reguserid) — INT
  • RegDate (regdate) — DATETIME
  • UptUserId (uptuserid) — INT
  • UptDate (uptdate) — DATETIME
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_Group.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_Group.BizUnit — NOT NULL
  • GroupCd (groupcd) — INT — Foreign key → TB_Group.GroupCd — NOT NULL
  • CompCd (CompCd22) — CHAR(13) — Foreign key → TB_Group.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_Group.BizUnit — NOT NULL

TB_CodeM

  • CompCd — CHAR(13) — Primary key — NOT NULL
  • CodeId (codeid) — INT — Primary key — NOT NULL
  • CodeNm (codenm) — NVARCHAR(40)
  • Remk (remk) — NVARCHAR(300)
  • UseYN (useyn) — CHAR(1)
  • RegUserId (reguserid) — INT
  • RegDate (regdate) — DATETIME
  • UptUserId (uptuserid) — INT
  • UptDate (uptdate) — DATETIME
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_Group.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_Group.BizUnit — NOT NULL
  • GroupCd (groupcd) — INT — Foreign key → TB_Group.GroupCd — NOT NULL
  • CompCd (CompCd22) — CHAR(13) — Foreign key → TB_Group.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_Group.BizUnit — NOT NULL

TB_Customer (Untitled21)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • CustomerCd (Key3) — NVARCHAR(100) — Primary key — NOT NULL
  • ConsultDt (Key5) — NVARCHAR(10) — Primary key — NOT NULL
  • CustomerNm (Key4) — NVARCHAR(20) — NOT NULL
  • Birth (Field2) — DATETIME
  • Gender (Field) — NVARCHAR(20)
  • PhoneNo (Field3) — NVARCHAR(20)
  • Email (Field4) — NVARCHAR(100)
  • ZipCode (Field5) — NVARCHAR(10)
  • Address (Field6) — NVARCHAR(40)
  • DetailAddress (Field7) — NVARCHAR(40)
  • Job (Field8) — NVARCHAR(20)
  • Hobby (Field9) — NVARCHAR(20)
  • Rank (Field10) — NVARCHAR(10)
  • Motive (Field11) — NVARCHAR(100)
  • HairLossType (Field12) — NVARCHAR(20)
  • WigExperience (Field13) — NVARCHAR(20)
  • Remk (Field14) — NVARCHAR(200)
  • RegUserId (Field15) — INT
  • RegDate (Field16) — DATETIME
  • UptUserId (Field17) — INT
  • UptDate (Field18) — DATETIME
  • CompCd — CHAR(13) — Foreign key → TB_BizUnit.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_BizUnit.BizUnit — NOT NULL

TB_File (Untitled)

  • CompCd (Key2) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key3) — CHAR(4) — Primary key — NOT NULL
  • CompCd — CHAR(13) — Foreign key → TB_CodeM.CompCd — NOT NULL
  • CodeId (codeid) — INT — Foreign key → TB_CodeM.CodeId — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_CodeD.CompCd — NOT NULL
  • CodeId (codeid2) — INT — Foreign key → TB_CodeD.CodeId — NOT NULL
  • FileNo (Key) — INT — NOT NULL
  • FileCls (Field) — INT
  • DetailCls (Field2) — INT
  • CustomerNo (Field3) — NVARCHAR(20)
  • UserCd (Field4) — INT
  • GroupCd (Field5) — INT
  • ItemCd (Field6) — NVARCHAR(40)
  • FIleNm (Field7) — NVARCHAR(400)
  • FileData (Field8) — NVARCHAR(MAX)
  • FileType (Field9) — NVARCHAR(100)
  • CnfDt (Field10) — NVARCHAR(20)
  • CnfUserCd (Field11) — INT
  • ConfYN (Field12) — NVARCHAR(1)
  • EffStDt (Field13) — NVARCHAR(10)
  • EffEnDt (Field14) — NVARCHAR(10)
  • Remk (Field15) — NVARCHAR(200)
  • RegUserId (Field16) — INT
  • RegDate (Field17) — DATETIME
  • UptUserId (Field18) — INT
  • UptDate (Field19) — DATETIME

TB_Group

  • CompCd — CHAR(13) — Primary key — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Primary key — NOT NULL
  • GroupCd (groupcd) — INT — Primary key — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_BizUnit.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_BizUnit.BizUnit — NOT NULL
  • GroupNm (groupnm) — NVARCHAR(30)
  • GroupType (grouptype) — NVARCHAR(30)
  • ParentGCd (parentgcd) — INT
  • DispSeq (dispseq) — INT
  • RegUserId (reguserid) — INT
  • RegDate (regdate) — DATETIME
  • UptUserId (uptuserid) — INT
  • UptDate (uptdate) — DATETIME

TB_HandMdItem (Untitled18)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • ItemCd (Key2) — NVARCHAR(40) — Primary key — NOT NULL
  • ModelType (Field) — NVARCHAR(10)
  • AttachQty (Field2) — DECIMAL(18,4)
  • ItemWidth (Field3) — DECIMAL(18,4)
  • ItemHeight (Field4) — DECIMAL(18,4)
  • HairDirectionX (Field5) — NVARCHAR(10)
  • FiberTypeCN (Field6) — DECIMAL(18,4)
  • FiberTypeIN (Field7) — DECIMAL(18,4)
  • FiberTypeSTN (Field8) — DECIMAL(18,4)
  • FiberTypeH (Field9) — DECIMAL(18,4)
  • FiberTypeEtc (Field10) — DECIMAL(18,4)
  • HairColor (Field11) — NVARCHAR(10)
  • HairColorFront (Field12) — DECIMAL(18,4)
  • HairColorCenter (Field13) — DECIMAL(18,4)
  • HairColorEar (Field14) — DECIMAL(18,4)
  • HairColorSide (Field15) — DECIMAL(18,4)
  • HaircolorBack (Field16) — DECIMAL(18,4)
  • HairLengthFront (Field17) — DECIMAL(18,4)
  • HairLengthCenter (Field18) — DECIMAL(18,4)
  • HairLengthEar (Field19) — DECIMAL(18,4)
  • HairLengthSide (Field20) — DECIMAL(18,4)
  • HairLengthBack (Field21) — DECIMAL(18,4)
  • HairAmountFront (Field22) — DECIMAL(18,4)
  • HairAmountCenter (Field23) — DECIMAL(18,4)
  • HairAmountEar (Field24) — DECIMAL(18,4)
  • HairAmountSide (Field25) — DECIMAL(18,4)
  • HairAmountBack (Field26) — DECIMAL(18,4)
  • WHairAmountFront (Field27) — DECIMAL(18,4)
  • WHairAmountCenter (Field28) — DECIMAL(18,4)
  • WHairAmountEar (Field29) — DECIMAL(18,4)
  • WHairAmountSide (Field30) — DECIMAL(18,4)
  • WHairAmountBack (Field31) — DECIMAL(18,4)
  • CurlFront (Field32) — DECIMAL(18,4)
  • CurlCenter (Field33) — DECIMAL(18,4)
  • CurlEar (Field34) — DECIMAL(18,4)
  • CurlSide (Field35) — DECIAML(18,4)
  • CurlBack (Field36) — DECIMAL(18,4)
  • UnderKnotting (Field37) — NVARCHAR(10)
  • FrontKnotting (Field38) — NVARCHAR(10)
  • NanoSkinThin (Field39) — NVARCHAR(10)
  • CapColor (Field40) — NVARCHAR(10)
  • CapColorNo (Field41) — NVARCHAR(10)
  • BaseNet (Field42) — NVARCHAR(20)
  • SkinColor (Field43) — NVARCHAR(10)
  • RegUserId (Field44) — INT
  • RegDate (Field45) — DATETIME
  • UptUserId (Field46) — INT
  • UptDate (Field47) — DATETIME

TB_Item (CopyOfUntitled16)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(13) — Primary key — NOT NULL
  • ItemCd (Key4) — NVARCHAR(40) — Primary key — NOT NULL
  • ItemNm (Field) — NVARCHAR(40)
  • ItemCls (Field3) — NVARCHAR(40)
  • Item1Cls (Field4) — NVARCHAR(40)
  • Item2Cls (Field5) — NVARCHAR(40)
  • Item3Cls (Field6) — NVARCHAR(40)
  • WhCd (Field7) — NVARCHAR(10)
  • Unit (Field8) — NVARCHAR(20)
  • Price (Field9) — DECIMAL(18,4)
  • Remk (Field10) — NVARCHAR(100)
  • DelYN (Field11) — NVARCHAR(1)
  • RegUserId (Field12) — INT
  • RegDate (Field13) — DATETIME
  • UptUserId (Field14) — INT
  • UptDate (Field15) — DATETIME

TB_ItemOrderD (Untitled24)

  • CompCd (Key) — NVARCHAR — Primary key — NOT NULL
  • BizUnit (Key2) — NVARCHAR — Primary key — NOT NULL
  • OrderNo (Key3) — NVARCHAR — Primary key — NOT NULL
  • OrderSeq (Key4) — INT — Primary key — NOT NULL
  • ItemCd (Field) — NVARCHAR
  • Qty (Field2) — DECIMAL
  • UPR (Field3) — DECIMAL
  • Price (Field4) — DECIMAL
  • VAT (Field5) — DECIMAL
  • RegUserId (Field6) — INT
  • RegDate (Field7) — DATETIME
  • UptUserId (Field8) — INT
  • UptDate (Field9) — DATETIME

TB_ItemOrderM (Untitled23)

  • CompCd (Key) — NVARCHAR — Primary key — NOT NULL
  • BizUnit (Key2) — NVARCHAR — Primary key — NOT NULL
  • OrderNo (Key3) — NVARCHAR — Primary key — NOT NULL
  • OrderDt (Field) — NVARCHAR
  • OrderCls (Field2) — INT
  • CustomerCd (Field3) — INT
  • PlCCd (Field4) — INT
  • PayYN (Field5) — NVARCHAR
  • PayDt (Field6) — NVARCHAR
  • EctRequest (Field7) — NVARCHAR
  • TotPrice (Field8) — DECIMAL
  • TotVAT (Field9) — DECIMAL
  • Remk (Field10) — NVARCHAR
  • RegUserId (Field11) — INT
  • RegDate (Field12) — DATETIME
  • UptUserId (Field13) — INT
  • UptDate (Field14) — DATETIME

TB_MachineMdItemD (CopyOfUntitled17)

  • CompCd (Key) — NVARCHAR — Primary key — NOT NULL
  • BizUnit (Key3) — NVARCHAR — Primary key — NOT NULL
  • FactBizUnit (Key4) — NVARCHAR — Primary key — NOT NULL
  • ItemCd (Key2) — NVARCHAR — Primary key — NOT NULL
  • Seq (Field) — INT
  • Size (Field2) — INT
  • StretchCut (Field3) — NVARCHAR
  • StretchYN (Field4) — NVARCHAR
  • StretchWeight (Field5) — NVARCHAR
  • TwinHairLength (Field6) — NVARCHAR
  • TwinHand (Field7) — NVARCHAR
  • TwinCut (Field8) — NVARCHAR
  • CurlPipe (Field9) — NVARCHAR
  • CurlDirection (Field10) — NVARCHAR
  • CurlSpecial (Field11) — NVARCHAR
  • CurlRemk (Field12) — NVARCHAR
  • CurlThickness (Field13) — NVARCHAR
  • DelYN (Field14) — NVARCHAR
  • RegUserId (Field15) — INT
  • RegDate (Field16) — DATETIME
  • UptUserId (Field17) — INT
  • UptDate (Field18) — DATETIME

TB_MachineMdItemM (Untitled17)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • ItemCd (Key2) — NVARCHAR(40) — Primary key — NOT NULL
  • Buyer (Field) — NVARCHAR(20)
  • Fiber (Field2) — NVARCHAR(40)
  • ModelType (Field3) — NVARCHAR(40)
  • Weight (Field4) — DECIMAL(18,4)
  • ManufactedDt (Field5) — NVARCHAR(10)
  • Size (Field6) — DECIMAL(18,4)
  • HairLength (Field7) — DECIMAL(18,4)
  • GongGo (Field8) — NVARCHAR(10)
  • GongInsoo (Field9) — NVARCHAR(10)
  • GongIngye (Field10) — NVARCHAR(10)
  • WeightHand (Field11) — NVARCHAR(10)
  • WeightInsoo (Field12) — NVARCHAR(10)
  • WeightIngye (Field13) — NVARCHAR(10)
  • WeightLength (Field14) — DECIMAL(18,4)
  • CapWeight (Field15) — DECIMAL(18,4)
  • CapRound (Field16) — DECIMAL(18,4)
  • CapLength (Field17) — DECIMAL(18,4)
  • CapFrontBack (Field18) — NVARCHAR(10)
  • CapPartItem (Field19) — NVARCHAR(10)
  • PartHair (Field20) — NVARCHAR(10)
  • PartSize (Field21) — NVARCHAR(10)
  • SkinWeight (Field22) — DECIMAL(18,4)
  • Loss (Field23) — NVARCHAR(10)
  • TotalWeight (Field24) — DECIMAL(18,4)
  • RegUserId (Field25) — INT
  • RegDate (Field26) — DATETIME
  • UptUserId (Field27) — INT
  • UptDate (Field28) — DATETIME

TB_Menu

  • CompCd — CHAR(13) — Primary key — NOT NULL
  • MenuId (menuid) — INT — Primary key — NOT NULL
  • MenuNm (menunm) — NVARCHAR(100)
  • MenuDesc (menudesc) — NVARCHAR(100)
  • ParentMID (parentmid) — INT
  • DispSeq (dispseq) — INT
  • UseYN (useyn) — CHAR(1)
  • RegUserId (reguserid) — INT
  • RegDate (regdate) — DATETIME
  • UptUserId (uptuserid) — INT
  • UptDate (uptdate) — DATETIME

TB_Notice

  • CompCd — CHAR(13) — Primary key — NOT NULL
  • NoticeCd (noticecd) — INT — Primary key — NOT NULL
  • Title (title) — NVARCHAR(100)
  • Contents (contents) — NVARCHAR(MAX)
  • StartDate (startdate) — NVARCHAR(10)
  • EndDate (Field4) — NVARCHAR(10)
  • Remk (Field5) — NVARCHAR(300)
  • RegUserId (Field6) — INT
  • RegDate (Field7) — DATETIME
  • UptUserId (Field8) — INT
  • UptDate (Field9) — DATETIME
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • UserCd (usercd) — INT — Foreign key → TB_User.UserCd — NOT NULL
  • CompCd (CompCd22) — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_User.BizUnit — NOT NULL
  • GroupCd (groupcd2) — INT — Foreign key → TB_User.GroupCd — NOT NULL
  • CompCd (CompCd222) — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • BizUnit (bizunit22) — CHAR(4) — Foreign key → TB_User.BizUnit — NOT NULL

TB_Order (Untitled22)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • OrderNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • OrderDt (Field) — NVARCHAR(10)
  • OrderCls (Field2) — NVARCHAR(10)
  • CustomerCd (Field3) — INT
  • PlCCd (Field4) — INT
  • ItemCd (Field5) — NVARCHAR(40)
  • ItemNm (Field6) — NVARCHAR(40)
  • Qty (Field7) — INT
  • PayYN (Field8) — CHAR(1)
  • PayDt (Field9) — NVARCHAR(10)
  • FactBizUnit (Field10) — NVARCHAR
  • EctRequest (Field11) — NVARCHAR(10)
  • Price (Field12) — DECIMAL(18,0)
  • VAT (Field13) — DECIMAL(18,0)
  • WorkState (Field14) — NVARCHAR(10)
  • Remk (Field15) — NVARCHAR(200)
  • RegUserId (Field16) — INT
  • RegDate (Field17) — DATETIME
  • UptUserId (Field18) — INT
  • UptDate (Field19) — DATETIME

TB_OrderImg (Untitled25)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • OrderNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • Seq (Key4) — INT — Primary key — NOT NULL
  • OrderCls (Field) — IMAGE
  • CustomerCd (Field2) — NVARCHAR(100)
  • PlCCd (Field3) — NVARCHAR(200)
  • RegUserId (Field4) — INT
  • RegDate (Field5) — DATETIME
  • UptUserId (Field6) — INT
  • UptDate (Field7) — DATETIME
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_Order.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_Order.BizUnit — NOT NULL
  • OrderNo (Key32) — NVARCHAR(20) — Foreign key → TB_Order.OrderNo — NOT NULL

TB_OutItem (Untitled11)

  • CompCd (Key) — NVARCHAR — Primary key — NOT NULL
  • BizUnit (Key2) — NVARCHAR — Primary key — NOT NULL
  • OrderNo (Key3) — NVARCHAR — Primary key — NOT NULL
  • OrderSeq (Key4) — INT — Primary key — NOT NULL
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_Order.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_Order.BizUnit — NOT NULL
  • OrderNo (Key32) — NVARCHAR(20) — Foreign key → TB_Order.OrderNo — NOT NULL
  • OutSeq (Field) — INT
  • OutDate (Field2) — NVARCHAR
  • OutGroupCd (Field3) — INT
  • OutUserId (Field4) — INT
  • ItemCd (Field5) — NVARCHAR
  • OutQty (Field6) — DECIMAL
  • Remk (Field7) — NVARCHAR
  • Remk2 (Field8) — NVARCHAR
  • RegUserId (Field9) — INT
  • RegDateD (Field10) — DATETIME

TB_OutPDItem (Untitled10)

  • CompCdC (Key) — NVARCHAR — Primary key — NOT NULL
  • BizUnit (Key2) — NVARCHAR — Primary key — NOT NULL
  • FactBizUnit (Key3) — NVARCHAR — Primary key — NOT NULL
  • OrderNo (Key4) — NVARCHAR — Primary key — NOT NULL
  • OutSeq (Key5) — INT — Primary key — NOT NULL
  • CompCd (Key6) — CHAR(13) — Foreign key → TB_PDItem.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(13) — Foreign key → TB_PDItem.BizUnit — NOT NULL
  • FactBizUnit (Key32) — CHAR(13) — Foreign key → TB_PDItem.FactBizUnit — NOT NULL
  • ItemCd (Key42) — NVARCHAR(40) — Foreign key → TB_PDItem.ItemCd — NOT NULL
  • CompCd (Key52) — CHAR(13) — Foreign key → TB_PDItem.CompCd — NOT NULL
  • BizUnit (Key222) — CHAR(4) — Foreign key → TB_PDItem.BizUnit — NOT NULL
  • OrderNo (Key322) — NVARCHAR(20) — Foreign key → TB_PDItem.OrderNo — NOT NULL
  • CompCd (Key62) — CHAR(13) — Foreign key → TB_PDItem.CompCd — NOT NULL
  • ItemCd (Key23) — NVARCHAR(40) — Foreign key → TB_PDItem.ItemCd — NOT NULL
  • OutDate (Field) — NVARCHAR
  • OutGroupCd (Field2) — INT
  • OutUserId (Field3) — INT
  • ItemCd (Field4) — NVARCHAR
  • OutQty (Field5) — DECIMAL
  • Unit (Field6) — NVARCHAR
  • Tax (Field7) — DECIMAL
  • Remk (Field8) — NVARCHAR
  • ReguUserId (Field9) — INT
  • RegDate (Field10) — DATETIME
  • UptUserId (Field11) — INT
  • UptDate (Field12) — DATETIME

TB_PDItem (Untitled16)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(13) — Primary key — NOT NULL
  • FactBizUnit (Key3) — CHAR(13) — Primary key — NOT NULL
  • ItemCd (Key4) — NVARCHAR(40) — Primary key — NOT NULL
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_Order.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_Order.BizUnit — NOT NULL
  • OrderNo (Key32) — NVARCHAR(20) — Foreign key → TB_Order.OrderNo — NOT NULL
  • CompCd (Key6) — CHAR(13) — Foreign key → TB_HandMdItem.CompCd — NOT NULL
  • ItemCd (Key23) — NVARCHAR(40) — Foreign key → TB_HandMdItem.ItemCd — NOT NULL
  • ItemNm (Field) — NVARCHAR(40)
  • MadeType (Field2) — INT
  • ItemCls (Field3) — NVARCHAR(40)
  • Item1Cls (Field4) — NVARCHAR(40)
  • Item2Cls (Field5) — NVARCHAR(40)
  • Item3Cls (Field6) — NVARCHAR(40)
  • WhCd (Field7) — NVARCHAR(10)
  • Unit (Field8) — NVARCHAR(20)
  • Price (Field9) — DECIMAL(18,4)
  • Remk (Field10) — NVARCHAR(100)
  • DelYN (Field11) — NVARCHAR(1)
  • RegUserId (Field12) — INT
  • RegDate (Field13) — DATETIME
  • UptUserId (Field14) — INT
  • UptDate (Field15) — DATETIME

TB_PDItemImg (Untitled19)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • ItemCd (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • Seq (Key4) — INT — Primary key — NOT NULL
  • OrderCls (Field) — IMAGE
  • CustomerCd (Field2) — NVARCHAR(100)
  • PlCCd (Field3) — NVARCHAR(200)
  • RegUserId (Field4) — INT
  • RegDate (Field5) — DATETIME
  • UptUserId (Field6) — INT
  • UptDate (Field7) — DATETIME
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_PDItem.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(13) — Foreign key → TB_PDItem.BizUnit — NOT NULL
  • FactBizUnit (Key32) — CHAR(13) — Foreign key → TB_PDItem.FactBizUnit — NOT NULL
  • ItemCd (Key42) — NVARCHAR(40) — Foreign key → TB_PDItem.ItemCd — NOT NULL
  • CompCd (Key52) — CHAR(13) — Foreign key → TB_PDItem.CompCd — NOT NULL
  • BizUnit (Key222) — CHAR(4) — Foreign key → TB_PDItem.BizUnit — NOT NULL
  • OrderNo (Key322) — NVARCHAR(20) — Foreign key → TB_PDItem.OrderNo — NOT NULL
  • CompCd (Key6) — CHAR(13) — Foreign key → TB_PDItem.CompCd — NOT NULL
  • ItemCd (Key23) — NVARCHAR(40) — Foreign key → TB_PDItem.ItemCd — NOT NULL

TB_POInItemD (Untitled9)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • POInitemNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • Seq (Key4) — INT — Primary key — NOT NULL
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_POrderD.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_POrderD.BizUnit — NOT NULL
  • POrderNo (Key32) — NVARCHAR(20) — Foreign key → TB_POrderD.POrderNo — NOT NULL
  • Seq (Key42) — INT — Foreign key → TB_POrderD.Seq — NOT NULL
  • CompCd (Key52) — CHAR(13) — Foreign key → TB_POrderD.CompCd — NOT NULL
  • BizUnit (Key222) — CHAR(4) — Foreign key → TB_POrderD.BizUnit — NOT NULL
  • POrderNo (Key322) — NVARCHAR(20) — Foreign key → TB_POrderD.POrderNo — NOT NULL
  • CompCd — CHAR(13) — Foreign key → TB_POrderD.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_POrderD.BizUnit — NOT NULL
  • GroupCd (groupcd) — INT — Foreign key → TB_POrderD.GroupCd — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_POrderD.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_POrderD.BizUnit — NOT NULL
  • CompCd (CompCd3) — CHAR(13) — Foreign key → TB_POrderD.CompCd — NOT NULL
  • BizUnit (bizunit3) — CHAR(4) — Foreign key → TB_POrderD.BizUnit — NOT NULL
  • POrderNo (Field) — NVARCHAR(20)
  • POSeq (Field2) — INT
  • ItemCd (Field3) — NVARCHAR(40)
  • WhCd (Field4) — NVARCHAR(10)
  • Qty (Field5) — DECIMAL(18,4)
  • Price (Field6) — DECIMAL(18,4)
  • Amt (Field7) — DECIMAL(18,4)
  • Unit (Field8) — NVARCHAR
  • Weight (Field9) — DECIMAL
  • Remk (Field10) — NVARCHAR(200)
  • RegUserId (Field11) — INT
  • RegDate (Field12) — DATETIME
  • UptUserId (Field13) — INT
  • UptDate (Field14) — DATETIME

TB_POInItemM (Untitled8)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • POInItemNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • CompCd (Key4) — CHAR(13) — Foreign key → TB_POrderM.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_POrderM.BizUnit — NOT NULL
  • POrderNo (Key32) — NVARCHAR(20) — Foreign key → TB_POrderM.POrderNo — NOT NULL
  • CompCd — CHAR(13) — Foreign key → TB_POrderM.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_POrderM.BizUnit — NOT NULL
  • GroupCd (groupcd) — INT — Foreign key → TB_POrderM.GroupCd — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_POrderM.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_POrderM.BizUnit — NOT NULL
  • CompCd (CompCd3) — CHAR(13) — Foreign key → TB_POrderM.CompCd — NOT NULL
  • BizUnit (bizunit3) — CHAR(4) — Foreign key → TB_POrderM.BizUnit — NOT NULL
  • POInDate (Field) — CHAR(1)
  • POInGroupCd (Field2) — INT
  • POInUserId (Field3) — INT
  • POInCustCd (Field4) — NVARCHAR(20)
  • TotQty (Field5) — DECIMAL(18,4)
  • TotAmt (Field6) — DECIMAL(18,4)
  • Remk (Field7) — NVARCHAR(300)
  • RegUserId (Field8) — INT
  • RegDate (Field9) — DATETIME
  • UptUserId (Field10) — INT
  • UptDate (Field11) — DATETIME

TB_POrderD (Untitled7)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • POrderNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • Seq (Key4) — INT — Primary key — NOT NULL
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_POrderM.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_POrderM.BizUnit — NOT NULL
  • POrderNo (Key32) — NVARCHAR(20) — Foreign key → TB_POrderM.POrderNo — NOT NULL
  • CompCd — CHAR(13) — Foreign key → TB_POrderM.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_POrderM.BizUnit — NOT NULL
  • GroupCd (groupcd) — INT — Foreign key → TB_POrderM.GroupCd — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_POrderM.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_POrderM.BizUnit — NOT NULL
  • CompCd (CompCd3) — CHAR(13) — Foreign key → TB_POrderM.CompCd — NOT NULL
  • BizUnit (bizunit3) — CHAR(4) — Foreign key → TB_POrderM.BizUnit — NOT NULL
  • ItemCd (Field) — NVARCHAR(40)
  • Qty (Field2) — DECIMAL(18,4)
  • Price (Field3) — DECIMAL(18,4)
  • Amt (Field4) — DECIMAL(18,4)
  • UnitCd (Field5) — DECIMAL(18,4)
  • Weight (Field6) — DECIMAL(18,4)
  • ReqDelvDate (Field7) — DATETIME
  • DelvPlace (Field8) — NVARCHAR(50)
  • RegUserId (Field9) — INT
  • RegDate (Field10) — DATETIME
  • UptUserId (Field11) — INT
  • UptDate (Field12) — DATETIME

TB_POrderM (Untitled6)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • POrderNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • CompCd — CHAR(13) — Foreign key → TB_Group.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_Group.BizUnit — NOT NULL
  • GroupCd (groupcd) — INT — Foreign key → TB_Group.GroupCd — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_Group.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_Group.BizUnit — NOT NULL
  • CompCd (CompCd3) — CHAR(13) — Foreign key → TB_BizUnit.CompCd — NOT NULL
  • BizUnit (bizunit3) — CHAR(4) — Foreign key → TB_BizUnit.BizUnit — NOT NULL
  • VatYN (Field) — CHAR(1)
  • GroupCd (Field2) — INT
  • POrderUserId (Field3) — INT
  • POrderCustCd (Field4) — NVARCHAR(20)
  • Amt (Field5) — DECIMAL
  • Vat (Field6) — DECIMAL
  • Remk (Field7) — NVARCHAR(300)
  • RegUserId (Field8) — INT
  • RegDate (Field9) — DATETIME
  • UptUserId (Field10) — INT
  • UptDate (Field11) — DATETIME

TB_RoleD

  • CompCd — CHAR(13) — Primary key — NOT NULL
  • RoleId (roleid) — INT — Primary key — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_Menu.CompCd — NOT NULL
  • MenuId (menuid2) — INT — Foreign key → TB_Menu.MenuId — NOT NULL
  • RoleSeq (roleseq) — INT
  • MenuId (menuid) — INT
  • ReadWrtYN (readwrtyn) — CHAR(1)
  • ReadYN (readyn) — CHAR(1)
  • RegUserId (reguserid) — INT
  • RegDater (regdate) — DATETIME
  • UptUserId (uptuserid) — INT
  • UptDate (uptdate) — DATETIME

TB_RoleM

  • CompCd — CHAR(13) — Primary key — NOT NULL
  • RoleId (roleid) — INT — Primary key — NOT NULL
  • CompCd (CompCd3) — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • UserCd (usercd) — INT — Foreign key → TB_User.UserCd — NOT NULL
  • CompCd (CompCd22) — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_User.BizUnit — NOT NULL
  • GroupCd (groupcd2) — INT — Foreign key → TB_User.GroupCd — NOT NULL
  • CompCd (CompCd222) — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • BizUnit (bizunit22) — CHAR(4) — Foreign key → TB_User.BizUnit — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_Menu.CompCd — NOT NULL
  • MenuId (menuid) — INT — Foreign key → TB_Menu.MenuId — NOT NULL
  • RoleNm (rolenm) — NVARCHAR(30)
  • RoleDesc (roledesc) — NVARCHAR(100)
  • UseYN (useyn) — CHAR(1)
  • RegUserId (reguserid) — INT
  • RegDate (regdate) — DATETIME
  • UptUserId (uptuserid) — INT
  • UptDate (uptdate) — DATETIME

TB_StkItem (Untitled13)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • SlipNo (Key3) — INT — Primary key — NOT NULL
  • SlipSeq (Key4) — NVARCHAR(20) — Primary key — NOT NULL
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_Order.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_Order.BizUnit — NOT NULL
  • OrderNo (Key32) — NVARCHAR(20) — Foreign key → TB_Order.OrderNo — NOT NULL
  • StkYM (Field) — NVARCHAR(20)
  • SlipGroupCd (Field2) — INT
  • SlipUserId (Field3) — NVARCHAR(20)
  • SlipType (Field4) — NVARCHAR(10)
  • SlipDate (Field5) — DECIMAL(18,4)
  • Whcd (Field6) — NVARCHAR(10)
  • ItemCd (Field7) — NVARCHAR(40)
  • Qty (Field8) — INT
  • Price (Field9) — DECIMAL(18,4)
  • Amt (Field10) — INT
  • InSlipNo (Field11) — NVARCHAR
  • InSlipSeq (Field12) — INT
  • WOSlipNo (Field13) — NVARCHAR
  • WOSlipSeq (Field14) — INT
  • WPSlipNo (Field15) — NVARCHAR
  • WPSlipSeq (Field16) — INT
  • OutSlipNo (Field17) — NVARCHAR
  • OutSlipSeq (Field18) — INT
  • Remk (Field19) — NVARCHAR
  • RegUserId (Field20) — INT
  • RegDate (Field21) — DATETIME
  • UptUserId (Field22) — INT
  • UptDate (Field23) — DATETIME

TB_StkPDItem (Untitled12)

  • CompCd (Key) — NVARCHAR — Primary key — NOT NULL
  • BizUnit (Key2) — NVARCHAR — Primary key — NOT NULL
  • FactBizUnit (Key3) — NVARCHAR — Primary key — NOT NULL
  • SlipNo (Key4) — NVARCHAR — Primary key — NOT NULL
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_PDItem.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(13) — Foreign key → TB_PDItem.BizUnit — NOT NULL
  • FactBizUnit (Key32) — CHAR(13) — Foreign key → TB_PDItem.FactBizUnit — NOT NULL
  • ItemCd (Key42) — NVARCHAR(40) — Foreign key → TB_PDItem.ItemCd — NOT NULL
  • CompCd (Key52) — CHAR(13) — Foreign key → TB_PDItem.CompCd — NOT NULL
  • BizUnit (Key222) — CHAR(4) — Foreign key → TB_PDItem.BizUnit — NOT NULL
  • OrderNo (Key322) — NVARCHAR(20) — Foreign key → TB_PDItem.OrderNo — NOT NULL
  • CompCd (Key6) — CHAR(13) — Foreign key → TB_PDItem.CompCd — NOT NULL
  • ItemCd (Key23) — NVARCHAR(40) — Foreign key → TB_PDItem.ItemCd — NOT NULL
  • SlipYM (Field2) — NVARCHAR
  • SlipNo (Field) — NVARCHAR
  • SlipGroupCd (Field3) — INT
  • SlipUserId (Field4) — INT
  • SlipType (Field5) — INT
  • SlipDate (Field6) — NVARCHAR
  • Whcd (Field7) — NVARCHAR
  • ItemCd (Field8) — NVARCHAR
  • Qty (Field9) — DECIMAL
  • WOSlipNo (Field10) — NVARCHAR
  • WPSlipSeq (Field11) — INT
  • OrSlipNo (Field12) — NVARCHAR
  • OutSlipSeq (Field13) — INT
  • Remk (Field14) — NVARCHAR
  • DELYN (Field15) — NVARCHAR
  • RegUserId (Field16) — INT
  • RegDate (Field17) — DATETIME
  • UptUserId (Field18) — INT
  • UptDate (Field19) — DATETIME

TB_User

  • CompCd — CHAR(13) — Primary key — NOT NULL
  • UserCd (usercd) — INT — Primary key — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_Group.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_Group.BizUnit — NOT NULL
  • GroupCd (groupcd2) — INT — Foreign key → TB_Group.GroupCd — NOT NULL
  • CompCd (CompCd22) — CHAR(13) — Foreign key → TB_Group.CompCd — NOT NULL
  • BizUnit (bizunit22) — CHAR(4) — Foreign key → TB_Group.BizUnit — NOT NULL
  • BizUnit (bizunit) — CHAR(4)
  • GroupCd (groupcd) — INT
  • UserNm (usernm) — NVARCHAR(30)
  • LoginId (loginid) — NVARCHAR(100)
  • LoginPw (loginpw) — NVARCAHR(100)
  • PhoneNo (phoneno) — NVARCHAR(20)
  • Eamil (email) — NVARCHAR(100)
  • RoleId (roleid) — INT
  • HireDate (hiredate) — NVARCHAR(10)
  • RegUserId (reguserid) — INT
  • RegDate (regdate) — DATETIME
  • UptUserId (uptuserid) — INT
  • UptDate (uptdate) — DATETIME
  • Field

TB_VOC (Untitled27)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • VocNo (Field) — NVARCHAR(20)
  • VocCls (Field2) — NVARCHAR(20)
  • VocDetailCls (Field3) — NVARCHAR(20)
  • CustomerCd (Field4) — NVARCHAR(20)
  • Title (Field5) — NVARCHAR(200)
  • Contents (Field6) — NVARCHAR(MAX)
  • ProcContents (Field7) — NVARCHAR(100)
  • VocUserId (Field8) — INT
  • VocManagerId (Field9) — INT
  • RegUserId (Field10) — INT
  • RegDate (Field11) — DATETIME
  • UptUserId (Field12) — INT
  • UptDate (Field13) — DATETIME
  • CompCd (Key3) — CHAR(13) — Foreign key → TB_Customer.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_Customer.BizUnit — NOT NULL
  • CustomerCd (Key32) — NVARCHAR(100) — Foreign key → TB_Customer.CustomerCd — NOT NULL
  • ConsultDt (Key5) — NVARCHAR(10) — Foreign key → TB_Customer.ConsultDt — NOT NULL

TB_WorkOrder (Untitled5)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • WorkOrderNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • CompCd (Key4) — CHAR(13) — Foreign key → TB_Order.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_Order.BizUnit — NOT NULL
  • OrderNo (Key32) — NVARCHAR(20) — Foreign key → TB_Order.OrderNo — NOT NULL
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (Key23) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • WorkPlanNo (Key33) — NVARCHAR(20) — Foreign key → TB_WorkPlan.WorkPlanNo — NOT NULL
  • CompCd — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • UserCd (usercd) — INT — Foreign key → TB_WorkPlan.UserCd — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • GroupCd (groupcd2) — INT — Foreign key → TB_WorkPlan.GroupCd — NOT NULL
  • CompCd (CompCd22) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (bizunit22) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • CompCd (CompCd3) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • CompCd (CompCd4) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (bizunit3) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • GroupCd (groupcd) — INT — Foreign key → TB_WorkPlan.GroupCd — NOT NULL
  • CompCd (CompCd23) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (bizunit23) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • CompCd (Key42) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (Key222) — CHAR(13) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • ItemCd (Key422) — NVARCHAR(40) — Foreign key → TB_WorkPlan.ItemCd — NOT NULL
  • CompCd (Key52) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • ItemCd (Key232) — NVARCHAR(40) — Foreign key → TB_WorkPlan.ItemCd — NOT NULL
  • CompCd (Key6) — NVARCHAR — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (Key322) — NVARCHAR — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • FactBizUnit (Key43) — NVARCHAR — Foreign key → TB_WorkPlan.FactBizUnit — NOT NULL
  • ItemCd (Key24) — NVARCHAR — Foreign key → TB_WorkPlan.ItemCd — NOT NULL
  • WorkOrderDt (Field) — NVARCHAR(10)
  • OrderNo (Field2) — NVARCHAR(20)
  • WorkPlanNo (Field3) — NVARCHAR(20)
  • ItemCd (Field4) — NVARCHAR(40)
  • Qty (Field5) — DECIMAL(18,4)
  • ShipDt (Field6) — NVARCHAR(10)
  • ProdDueDt (Field7) — NVARCHAR(10)
  • BomCd (Field8) — NVARCHAR(20)
  • MaterialYN (Field9) — CHAR(1)
  • RegUserId (Field10) — INT
  • RegDate (Field11) — DATETIME
  • UptUserId (Field12) — INT
  • UptDate (Field13) — DATETIME

TB_WorkPerform (Untitled4)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • WorkPerformNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • CompCd (Key4) — CHAR(13) — Foreign key → TB_Item.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(13) — Foreign key → TB_Item.BizUnit — NOT NULL
  • ItemCd (Key42) — NVARCHAR(40) — Foreign key → TB_Item.ItemCd — NOT NULL
  • CompCd — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • UserCd (usercd) — INT — Foreign key → TB_User.UserCd — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_User.BizUnit — NOT NULL
  • GroupCd (groupcd2) — INT — Foreign key → TB_User.GroupCd — NOT NULL
  • CompCd (CompCd22) — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • BizUnit (bizunit22) — CHAR(4) — Foreign key → TB_User.BizUnit — NOT NULL
  • Seq (Field) — INT
  • ItemCd (Field2) — NVARCHAR(40)
  • WorkPerformDt (Field3) — DATETIME
  • Qty (Field4) — DECIMAL(18,4)
  • OkQty (Field5) — DECIMAL(18,4)
  • BadQty (Field6) — DECIMAL(18,4)
  • BadType (Field7) — NVARCHAR(20)
  • BadReason (Field8) — NVARCHAR(500)
  • RegDate (Field9) — DATETIME
  • RegUserId (Field10) — INT
  • UptUserId (Field11) — INT
  • UptDate (Field12) — DATETIME

TB_WorkPlan (Untitled2)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • WorkPlanNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • CompCd — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • UserCd (usercd) — INT — Foreign key → TB_User.UserCd — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_User.BizUnit — NOT NULL
  • GroupCd (groupcd2) — INT — Foreign key → TB_User.GroupCd — NOT NULL
  • CompCd (CompCd22) — CHAR(13) — Foreign key → TB_User.CompCd — NOT NULL
  • BizUnit (bizunit22) — CHAR(4) — Foreign key → TB_User.BizUnit — NOT NULL
  • CompCd (CompCd3) — CHAR(13) — Foreign key → TB_BizUnit.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_BizUnit.BizUnit — NOT NULL
  • CompCd (CompCd4) — CHAR(13) — Foreign key → TB_Group.CompCd — NOT NULL
  • BizUnit (bizunit3) — CHAR(4) — Foreign key → TB_Group.BizUnit — NOT NULL
  • GroupCd (groupcd) — INT — Foreign key → TB_Group.GroupCd — NOT NULL
  • CompCd (CompCd23) — CHAR(13) — Foreign key → TB_Group.CompCd — NOT NULL
  • BizUnit (bizunit23) — CHAR(4) — Foreign key → TB_Group.BizUnit — NOT NULL
  • CompCd (Key4) — CHAR(13) — Foreign key → TB_Item.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(13) — Foreign key → TB_Item.BizUnit — NOT NULL
  • ItemCd (Key42) — NVARCHAR(40) — Foreign key → TB_Item.ItemCd — NOT NULL
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_MachineMdItemM.CompCd — NOT NULL
  • ItemCd (Key23) — NVARCHAR(40) — Foreign key → TB_MachineMdItemM.ItemCd — NOT NULL
  • CompCd (Key6) — NVARCHAR — Foreign key → TB_MachineMdItemD.CompCd — NOT NULL
  • BizUnit (Key32) — NVARCHAR — Foreign key → TB_MachineMdItemD.BizUnit — NOT NULL
  • FactBizUnit (Key43) — NVARCHAR — Foreign key → TB_MachineMdItemD.FactBizUnit — NOT NULL
  • ItemCd (Key24) — NVARCHAR — Foreign key → TB_MachineMdItemD.ItemCd — NOT NULL
  • WorkPlanDt (Field) — NVARCHAR(10)
  • ItemCd (Field2) — CHAR(13)
  • ItemNm (Field3) — NVARCHAR(40)
  • Qty (Field4) — INT
  • FactBizUnit (Field5) — CHAR(4)
  • EctRequest (Field6) — NVARCHAR(200)
  • AppUserId (Field7) — INT
  • AppDt (Field8) — NVARCHAR(10)
  • AppYN (Field9) — CHAR(1)
  • WorkState (Field10) — NVARCHAR(10)
  • Remk (Field11) — NVARCHAR(200)
  • RegUserId (Field12) — INT
  • RegDate (Field13) — DATETIME
  • UptUserId (Field14) — INT
  • UptDate (Field15) — DATETIME

TB_WorkPlanImg (Untitled3)

  • CompCd (Key) — CHAR(13) — Primary key — NOT NULL
  • BizUnit (Key2) — CHAR(4) — Primary key — NOT NULL
  • PlanNo (Key3) — NVARCHAR(20) — Primary key — NOT NULL
  • Seq (Key4) — INT — Primary key — NOT NULL
  • OrderCls (Field) — IMAGE
  • CustomerCd (Field2) — NVARCHAR(100)
  • PLCCd (Field3) — NVARCHAR(200)
  • RegUserId (Field4) — INT
  • RegDate (Field5) — DATETIME
  • UptUserId (Field6) — INT
  • UptDate (Field7) — DATETIME
  • CompCd (Key5) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (Key22) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • WorkPlanNo (Key32) — NVARCHAR(20) — Foreign key → TB_WorkPlan.WorkPlanNo — NOT NULL
  • CompCd — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • UserCd (usercd) — INT — Foreign key → TB_WorkPlan.UserCd — NOT NULL
  • CompCd (CompCd2) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (bizunit2) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • GroupCd (groupcd2) — INT — Foreign key → TB_WorkPlan.GroupCd — NOT NULL
  • CompCd (CompCd22) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (bizunit22) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • CompCd (CompCd3) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (bizunit) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • CompCd (CompCd4) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (bizunit3) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • GroupCd (groupcd) — INT — Foreign key → TB_WorkPlan.GroupCd — NOT NULL
  • CompCd (CompCd23) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (bizunit23) — CHAR(4) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • CompCd (Key42) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (Key222) — CHAR(13) — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • ItemCd (Key422) — NVARCHAR(40) — Foreign key → TB_WorkPlan.ItemCd — NOT NULL
  • CompCd (Key52) — CHAR(13) — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • ItemCd (Key23) — NVARCHAR(40) — Foreign key → TB_WorkPlan.ItemCd — NOT NULL
  • CompCd (Key6) — NVARCHAR — Foreign key → TB_WorkPlan.CompCd — NOT NULL
  • BizUnit (Key322) — NVARCHAR — Foreign key → TB_WorkPlan.BizUnit — NOT NULL
  • FactBizUnit (Key43) — NVARCHAR — Foreign key → TB_WorkPlan.FactBizUnit — NOT NULL
  • ItemCd (Key24) — NVARCHAR — Foreign key → TB_WorkPlan.ItemCd — NOT NULL