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