Product Management - Copy this React, Tailwind Component to your project
A partir de la las tabla CREATE SCHEMA [dbo] GO CREATE TABLE [N1_N_PAIS] ( [pkPais] INT PRIMARY KEY IDENTITY(1, 1), [descripcion] TEXT ) GO CREATE TABLE [N1_N_CLASE] ( [pkClase] INT PRIMARY KEY IDENTITY(1, 1), [descripcion] TEXT ) GO CREATE TABLE [N1_N_Categoria] ( [pkCategoria] INT PRIMARY KEY IDENTITY(1, 1), [descripcion] TEXT ) GO CREATE TABLE [N1_N_PRODUCTO] ( [pkProducto] INT PRIMARY KEY IDENTITY(1, 1), [fkPais] INT NOT NULL, [fkClase] INT NOT NULL, [fkCategoria] INT NOT NULL, [descripcionProducto] VARCHAR(255) NOT NULL, [descripcionComercial] VARCHAR(255), [codigoSAP] VARCHAR(50), [fkUnidadMedida] INT NOT NULL ) GO CREATE TABLE [N1_N_DETALLE_PRODUCTO] ( [pkDetalleProducto] INT PRIMARY KEY IDENTITY(1, 1), [fkProducto] INT NOT NULL, [fkCultivo] INT NOT NULL, [inactivo] BIT NOT NULL DEFAULT (0), [fechaInicio] DATE NOT NULL, [fechaFin] DATE NOT NULL, [fkObjetivo] INT NOT NULL, [fkEstadoPlagaObjetivo] INT NOT NULL, [codigoObjetivo] VARCHAR(50), [fkMomentoAplicacionCodigoEtapa] INT NOT NULL, [periodoReingreso] INT, [periodoCarencia] INT, [periodoCarenciaCamposol] INT, [dosisMinimaUnidHa] DECIMAL(10,4), [dosisMaximaUnidHa] DECIMAL(10,4), [concentracionMin] DECIMAL(10,4), [concentracionMax] DECIMAL(10,4), [maximoNumeroAplicaciones] INT, [lmr] DECIMAL(10,4), [fkMetodoAplicacion] INT NOT NULL, [codigoCorrelativo] INT ) GO CREATE TABLE [dbo].[N1_N_DETALLE_PRODUCTO_INGREDIENTEACTIVO] ( [pkDetalleProductoIngrediente] bigint NOT NULL IDENTITY(1, 1), [porIngredienteActivo] varchar(200), [fkProducto] int, [fkIngredienteActivo] int, [estadoRegistro] bit, [fechaRegistro] datetime ) GO ALTER TABLE [N1_N_PRODUCTO] ADD FOREIGN KEY ([fkPais]) REFERENCES [N1_N_PAIS] ([pkPais]) GO ALTER TABLE [N1_N_PRODUCTO] ADD FOREIGN KEY ([fkCategoria]) REFERENCES [N1_N_Categoria] ([pkCategoria]) GO ALTER TABLE [N1_N_PRODUCTO] ADD FOREIGN KEY ([fkClase]) REFERENCES [N1_N_CLASE] ([pkClase]) GO ALTER TABLE [dbo].[N1_N_DETALLE_PRODUCTO_INGREDIENTEACTIVO] ADD FOREIGN KEY ([fkProducto]) REFERENCES [N1_N_PRODUCTO] ([pkProducto]) GO ALTER TABLE [N1_N_DETALLE_PRODUCTO] ADD FOREIGN KEY ([fkProducto]) REFERENCES [N1_N_PRODUCTO] ([pkProducto]) GO
