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