SKKU_test
Tables (19)
MaterialHandlingInfo (Untitled3)
[Plan]Master (PLAN_MAS)
- Id (ID) — BIGINT — Primary key — Sequential ID
- Guid (GUID) — NVARCHAR(36)
[Plan]TargetVolume (PLAN_TARGET_VOLUME)
- Id (ID) — BIGINT — Primary key — NOT NULL — Sequential ID
- PlanId (PLAN_ID) — BIGINT — Foreign key → [Plan]Master.Id — NOT NULL
- Guid (GUID) — NVARCHAR(36) — Sequential ID
[Process]Master (PROCESS_MAS)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
[Process]OperationInfo (PROCESS_OP_INFO)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- ProcessId (PROCESS_ID) — BIGINT — Foreign key → [Process]Master.Id — NOT NULL
[Process]OperationInfoPartConsumed (PROCESS_OP_PART_CONSUMED)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- Id (ID2) — BIGINT — Foreign key → [Process]OperationInfo.Id — NOT NULL
[Process]OperationInfoPartProduced (PROCESS_OP_PART_PRODUCED)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Field (GUID) — NVARCHAR(36)
- OperationInfoId (OP_INFO_ID) — BIGINT — Foreign key → [Process]OperationInfo.Id — NOT NULL
[Process]OperationInfoProcessInfo (PROCESS_OP_PROCESS_INFO)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- OperationInfoId (OP_INFO_ID) — BIGINT — Foreign key → [Process]OperationInfo.Id — NOT NULL
[Process]OperationInfoType (PROCESS_OP_TYPE)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- OperationInfoId (OP_INFO_ID) — BIGINT — Foreign key → [Process]OperationInfo.Id — NOT NULL
[Process]OperationInfoWorkInfo (PROCESS_OP_WORKER)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- OperationInfoId (OP_INFO_ID) — BIGINT — Foreign key → [Process]OperationInfo.Id — NOT NULL
[Process]PartId (PART_ID)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- Id (ID2) — BIGINT — Foreign key → [Process]SourceInputInfo.Id — NOT NULL
[Process]SourceInputInfo (PROCESS_SOURCE_INPUT_INFO)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- ProcessId (PROCESS_ID) — BIGINT — Foreign key → [Process]Master.Id — NOT NULL
[Process]SourceInputInfoIdID (SOURCEINPUT_SII_ID)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- SourceInputInfoId (SOURCE_INPUT_INFO_ID) — BIGINT — Foreign key → [Process]SourceInputInfo.Id — NOT NULL
[Product]BillOfMaterials (PROD_BOM)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (Field) — NVARCHAR(36)
- ProductInfoId (PRODUCT_INFO_ID) — BIGINT — Foreign key → [Product]ProductInfo.Id — NOT NULL
[Product]CustomerInfo (PROD_CUSTOMER_INFO)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- ProductID (PROD_ID) — BIGINT — Foreign key → [Product]Master.Id — NOT NULL
[Product]Item (PROD_ITEM)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- ProductId (PROD_ID) — BIGINT — Foreign key → [Product]Master.Id — NOT NULL
[Product]Master (PROD_MAS)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
[Product]Part (PROD_PART)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- Id (ID2) — BIGINT — Foreign key → [Product]BillOfMaterials.Id — NOT NULL
- ItemID (ITEM_ID) — BIGINT — Foreign key → [Product]Item.Id — NOT NULL
- ParentPartID (P_PART_ID) — BIGINT — Foreign key → [Product]Part.Id — NOT NULL
[Product]ProductInfo (PROD_PRODUCT_INFO)
- Id (ID) — BIGINT — Primary key — NOT NULL
- Guid (GUID) — NVARCHAR(36)
- ProductId (PROD_ID) — BIGINT — Foreign key → [Product]Master.Id — NOT NULL
- ItemID (ITEM_ID) — BIGINT — Foreign key → [Product]Item.Id — NOT NULL
- CustomerId (PROD_CUSTOMER_INFO_ID) — BIGINT — Foreign key → [Product]CustomerInfo.Id — NOT NULL