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