NRT

Tables (5)

TB_CaseProjectPlanActivity

  • SmallCodeNo — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanSmallCode.SmallCodeNo — NOT NULL
  • OrderNo — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanSmallCode.OrderNo — NOT NULL
  • ProjectNo — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanSmallCode.ProjectNo — NOT NULL
  • MidCodeNo — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanSmallCode.MidCodeNo — NOT NULL
  • OrganizationCode — NVARCHAR(10) — Foreign key → TB_CaseProjectPlanSmallCode.OrganizationCode — NOT NULL
  • CaseNo — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanSmallCode.CaseNo — NOT NULL
  • OrderNo (OrderNo2) — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanMidCode.OrderNo — NOT NULL
  • ProjectNo (ProjectNo2) — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanMidCode.ProjectNo — NOT NULL
  • MidCodeNo (MidCodeNo2) — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanMidCode.MidCodeNo — NOT NULL
  • OrganizationCode (OrganizationCode2) — NVARCHAR(10) — Foreign key → TB_CaseProjectPlanMidCode.OrganizationCode — NOT NULL
  • CaseNo (CaseNo2) — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanMidCode.CaseNo — NOT NULL
  • BlockGB — NVARCHAR(10) — NOT NULL
  • ActivityCode — NVARCHAR(30) — NOT NULL
  • ActivityName — NVARCHAR(100)
  • ActivityIndex — INT
  • PlanStart — NVARCHAR(10)
  • PlanEnd — NVARCHAR(10)
  • PlanDuration — INT
  • PerformanceStart — NVARCHAR(10)
  • PerformanceEnd — NVARCHAR(10)
  • PerformanceDuration — INT
  • PerformanceProgress — INT
  • Status — NVARCHAR(100)
  • LocID — NVARCHAR(100)
  • WorkingType — NVARCHAR(100)
  • OutsourcingCompID — NVARCHAR(100)
  • OutsourcingCompName — NVARCHAR(100)
  • UseFlag — NVARCHAR(1) — NOT NULL
  • MidCodeNoSerialID — INT
  • SmallCodeNoSerialID — INT
  • Attribute01 — NVARCHAR(100)
  • Attribute02 — NVARCHAR(100)
  • Attribute03 — NVARCHAR(100)
  • Attribute04 — NVARCHAR(100)
  • Attribute05 — NVARCHAR(100)
  • CreatedBy — NVARCHAR(20) — NOT NULL
  • CreationDate — DATETIME — NOT NULL
  • LastUpdatedBy — NVARCHAR(20)
  • LastUpdateDate — DATETIME

TB_CaseProjectPlanDtl

  • OrganizationCode — NVARCHAR(10) — Foreign key → TB_CaseProjectPlanMst.OrganizationCode — NOT NULL
  • CaseNo — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanMst.CaseNo — NOT NULL
  • OrderNo — NVARCHAR(30) — NOT NULL
  • ProjectNo — NVARCHAR(30) — NOT NULL
  • DeliveryDate — NVARCHAR(10) — NOT NULL
  • Attribute01 — NVARCHAR(100)
  • Attribute02 — NVARCHAR(100)
  • Attribute03 — NVARCHAR(100)
  • Attribute04 — NVARCHAR(100)
  • Attribute05 — NVARCHAR(100)
  • CreatedBy — NVARCHAR(20) — NOT NULL
  • CreationDate — DATETIME — NOT NULL
  • LastUpdatedBy — NVARCHAR(20) — NOT NULL
  • LastUpdateDate — DATETIME — NOT NULL

TB_CaseProjectPlanMidCode

  • OrderNo — NVARCHAR(30) — Primary key — NOT NULL
  • ProjectNo — NVARCHAR(30) — Primary key — NOT NULL
  • MidCodeNo — NVARCHAR(30) — Primary key — NOT NULL
  • OrganizationCode — NVARCHAR(10) — Foreign key → TB_CaseProjectPlanMst.OrganizationCode — NOT NULL
  • CaseNo — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanMst.CaseNo — NOT NULL
  • MidCodeName — NVARCHAR(100)
  • MidCodeIndex — INT
  • Pitch — NVARCHAR(10)
  • Duration — INT
  • HorizontalAreaSize — DECIMAL(18, 2)
  • VerticalAreaSize — DECIMAL(18, 2)
  • PlanStart — NVARCHAR(10)
  • PlanEnd — NVARCHAR(10)
  • Status — NVARCHAR(100)
  • LocNo — NVARCHAR(30)
  • MidCodeNoSerialID — INT — NOT NULL
  • Attribute01 — NVARCHAR(100)
  • Attribute02 — NVARCHAR(100)
  • Attribute03 — NVARCHAR(100)
  • Attribute04 — NVARCHAR(100)
  • Attribute05 — NVARCHAR(100)
  • CreatedBy — NVARCHAR(20) — NOT NULL
  • CreationDate — DATETIME — NOT NULL
  • LastUpdatedBy — NVARCHAR(20) — NOT NULL
  • LastUpdateDate — DATETIME — NOT NULL

TB_CaseProjectPlanMst

  • OrganizationCode — NVARCHAR(10) — Primary key — NOT NULL
  • CaseNo — NVARCHAR(30) — Primary key — NOT NULL
  • CaseGB — NVARCHAR(1) — NOT NULL
  • CaseDesc — NVARCHAR(1000) — NOT NULL
  • ConfirmYN — VARCHAR(1) — NOT NULL
  • ConfirmBy — NVARCHAR(20)
  • ConfirmDate — DATETIME
  • PlanMinDate — NVARCHAR(10)
  • PlanMaxDate — NVARCHAR(10)
  • Attribute01 — NVARCHAR(100)
  • Attribute02 — NVARCHAR(100)
  • Attribute03 — NVARCHAR(100)
  • Attribute04 — NVARCHAR(100)
  • Attribute05 — NVARCHAR(100)
  • CreatedBy — NVARCHAR(20) — NOT NULL
  • CreationDate — DATETIME — NOT NULL
  • LastUpdatedBy — NVARCHAR(20) — NOT NULL
  • LastUpdateDate — DATETIME — NOT NULL

TB_CaseProjectPlanSmallCode

  • SmallCodeNo — NVARCHAR(30) — Primary key — NOT NULL
  • OrderNo — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanMidCode.OrderNo — NOT NULL
  • ProjectNo — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanMidCode.ProjectNo — NOT NULL
  • MidCodeNo (MidCodeNo2) — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanMidCode.MidCodeNo — NOT NULL
  • OrganizationCode — NVARCHAR(10) — Foreign key → TB_CaseProjectPlanMidCode.OrganizationCode — NOT NULL
  • CaseNo — NVARCHAR(30) — Foreign key → TB_CaseProjectPlanMidCode.CaseNo — NOT NULL
  • SmallCodeName — NVARCHAR(100)
  • SmallCodeIndex — INT
  • Pitch — NVARCHAR(10)
  • Duration — INT
  • HorizontalAreaSize — DECIMAL(18, 2)
  • VerticalAreaSize — DECIMAL(18, 2)
  • PlanStart — NVARCHAR(10)
  • PlanEnd — NVARCHAR(10)
  • Status — NVARCHAR(100)
  • MidCodeNoSerialID — INT — NOT NULL
  • SmallCodeNoSerialID — INT — NOT NULL
  • Attribute01 — NVARCHAR(100)
  • Attribute02 — NVARCHAR(100)
  • Attribute03 — NVARCHAR(100)
  • Attribute04 — NVARCHAR(100)
  • Attribute05 — NVARCHAR(100)
  • CreatedBy — NVARCHAR(20) — NOT NULL
  • CreationDate — DATETIME — NOT NULL
  • LastUpdatedBy — NVARCHAR(20) — NOT NULL
  • LastUpdateDate — DATETIME — NOT NULL