sap-production-routing-sql-sequence-data.sql

CREATE TABLE `sap_production_routing_sequence_data`
(
  `ProductionRoutingGroup`         varchar(8) NOT NULL,
  `ProductionRouting`              varchar(2) NOT NULL,
  `ProductionRoutingSequence`      varchar(6) NOT NULL,
  `ProductionRoutingSqncIntVers`   varchar(8) NOT NULL,
  `ChangeNumber`                   varchar(12) DEFAULT NULL,
  `ValidityStartDate`              varchar(80) DEFAULT NULL,
  `ValidityEndDate`                varchar(80) DEFAULT NULL,
  `SequenceCategory`               varchar(1) DEFAULT NULL,
  `BillOfOperationsRefSequence`    varchar(6) DEFAULT NULL,
  `MinimumLotSizeQuantity`         varchar(15) DEFAULT NULL,
  `MaximumLotSizeQuantity`         varchar(15) DEFAULT NULL,
  `BillOfOperationsUnit`           varchar(3) DEFAULT NULL,
  `SequenceText`                   varchar(40) DEFAULT NULL,
  `CreationDate`                   varchar(80) DEFAULT NULL,
  `LastChangeDate`                 varchar(80) DEFAULT NULL,
    PRIMARY KEY (`ProductionRoutingGroup`, `ProductionRouting`, `ProductionRoutingSequence`, `ProductionRoutingSqncIntVers`)
    CONSTRAINT `SapProductionRoutingSequenceData_fk` FOREIGN KEY (`ProductionRoutingGroup`, `ProductionRouting`, `ProductionRoutingInternalVers`) REFERENCES `sap_production_routing_header_data` (`ProductionRoutingGroup`, `ProductionRouting`, `ProductionRoutingInternalVers`)
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4;