SISTEMA INTEGRADO DE REGISTRO, CONTROL Y SEGUIMIETNO DE RECAUDACIONES Y TRAMITES ADMINISTRATIVOS
CASO: GOBIERNO AUTONOMO DEPARTAMENTAL DE LA PAZ
miércoles, 31 de agosto de 2011
SCRIPT
SCRIPT DEL SISTEMA INTEGRADO DE REGISTRO, CONTROL Y SEGUIMIETNO DE RECAUDACIONES Y TRAMITES ADMINISTRATIVOS
CASO: GOBIERNO AUTONOMO DEPARTAMENTAL DE LA PAZ
USE [SIRCSRTA]
GO
/****** Object: Table [dbo].[CUENTA_BANCO] Script Date: 08/27/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CUENTA_BANCO](
[Codigo] [int] NOT NULL,
[Nombre_banco] [varchar](50) NULL,
[Nro_cuenta] [int] NULL,
[Nro_cheque] [int] NULL,
CONSTRAINT [PK_CUENTA_BANCO] PRIMARY KEY CLUSTERED
(
[Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[PERSONAL_TRABAJO] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PERSONAL_TRABAJO](
[Codigo] [int] NOT NULL,
[Nombre_completo] [varchar](50) NULL,
[Nombre_usuario] [varchar](50) NULL,
[Password] [varchar](50) NULL,
[Nivel_acceso] [varchar](50) NULL,
CONSTRAINT [PK_PERSONAL_TRABAJO] PRIMARY KEY CLUSTERED
(
[Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[JEFE_VUT] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[JEFE_VUT](
[Per_Codigo] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Nombre_completo] [varchar](50) NULL,
[Nombre_usuario] [varchar](50) NULL,
[Password] [varchar](50) NULL,
[Nivel_acceso] [varchar](50) NULL,
CONSTRAINT [PK_JEFE_VUT] PRIMARY KEY CLUSTERED
(
[Per_Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[TIPO_SERVICIO] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TIPO_SERVICIO](
[Nro_arancel_gral] [int] NOT NULL,
[Descripcion_Arancel_Gral] [varchar](50) NULL,
CONSTRAINT [PK_TIPO_SERVICIO] PRIMARY KEY CLUSTERED
(
[Nro_arancel_gral] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[RESPONSABLE_VENTANILLA_IV] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RESPONSABLE_VENTANILLA_IV](
[Per_Codigo] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Nombre_completo] [varchar](50) NULL,
[Nombre_usuario] [varchar](50) NULL,
[PAssword] [varchar](50) NULL,
[Nivel_acceso] [varchar](50) NULL,
CONSTRAINT [PK_RESPONSABLE_VENTANILLA_IV] PRIMARY KEY CLUSTERED
(
[Per_Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[RESPONSABLE_VENTANILLA_III] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RESPONSABLE_VENTANILLA_III](
[Per_Codigo] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Nombre_completo] [varchar](54) NOT NULL,
[Nombre_usuario] [varchar](54) NOT NULL,
[Password] [varchar](54) NOT NULL,
[Nivel_acceso] [varchar](54) NOT NULL,
CONSTRAINT [PK_RESPONSABLE_VENTANILLA_III] PRIMARY KEY CLUSTERED
(
[Per_Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[RESPONSABLE_VENTANILLA_II] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RESPONSABLE_VENTANILLA_II](
[Per_Codigo] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Nombre_completo] [varchar](50) NULL,
[Nombre_usuario] [varchar](50) NULL,
[Password] [varchar](50) NULL,
[Nivel_acceso] [varchar](50) NULL,
CONSTRAINT [PK_RESPONSABLE_VENTANILLA_II] PRIMARY KEY CLUSTERED
(
[Per_Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[RESPONSABLE_VENTANILLA_I] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RESPONSABLE_VENTANILLA_I](
[Per_Codigo] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Nombre_completo] [varchar](50) NULL,
[Nombre_usuario] [varchar](50) NULL,
[Password] [varchar](50) NULL,
[Nivel_acceso] [varchar](50) NULL,
CONSTRAINT [PK_RESPONSABLE_VENTANILLA_I] PRIMARY KEY CLUSTERED
(
[Per_Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ESPECIFICACION_DE_SERVICIOS] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ESPECIFICACION_DE_SERVICIOS](
[Codigo] [int] NOT NULL,
[Nro_arancel_gral] [int] NOT NULL,
[Nro_arancel_det] [int] NULL,
[Descripcin_arancel_det] [varchar](50) NULL,
[Monto_Arancel] [int] NULL,
CONSTRAINT [PK_ESPECIFICACION_DE_SERVICIOS] PRIMARY KEY CLUSTERED
(
[Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[TRAMITES_APROB_JEFE_VUT] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TRAMITES_APROB_JEFE_VUT](
[Codigo_jefevut] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Per_Codigo] [int] NOT NULL,
[Res_Codigo] [int] NOT NULL,
[Nro_tramite] [int] NULL,
[NroExtracto] [int] NULL,
[Nro_liquidacion] [int] NULL,
[Fecha_aprobacion] [varchar](50) NULL,
[Codigo_Derivar] [varchar](50) NULL,
[aprobado] [varchar](50) NULL,
CONSTRAINT [PK_TRAMITES_APROB_JEFE_VUT] PRIMARY KEY CLUSTERED
(
[Codigo_jefevut] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[TRAMITE] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TRAMITE](
[Cod_tramite] [int] NOT NULL,
[Per_Codigo] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Jef_Per_Codigo] [int] NOT NULL,
[Jef_Codigo] [int] NOT NULL,
[Tipo_servicio] [varchar](50) NULL,
[Requisitos] [varchar](50) NULL,
[Nombre/Razon_social] [varchar](50) NULL,
[Direccion] [varchar](50) NULL,
CONSTRAINT [PK_TRAMITE] PRIMARY KEY CLUSTERED
(
[Cod_tramite] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[VERIFICA_ARANCEL] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[VERIFICA_ARANCEL](
[Cod_verificacion] [int] NOT NULL,
[Per_Codigo] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Nro_tramite] [int] NULL,
[Nro_liqudacion] [int] NULL,
[Nro_extracto] [int] NULL,
[Monto_cancelado] [int] NULL,
[Forma_pago] [varchar](50) NULL,
CONSTRAINT [PK_VERIFICA_ARANCEL] PRIMARY KEY CLUSTERED
(
[Cod_verificacion] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ENTREGA_DE_DOCUMENTOS] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ENTREGA_DE_DOCUMENTOS](
[Codigo] [int] NOT NULL,
[Per_Codigo] [int] NOT NULL,
[Res_Codigo] [int] NOT NULL,
[Nro_tramite] [int] NULL,
[Codigo_derivar] [int] NULL,
[Fecha_entrega] [date] NULL,
[estado] [int] NULL,
CONSTRAINT [PK_ENTREGA_DE_DOCUMENTOS] PRIMARY KEY CLUSTERED
(
[Codigo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[INGRESO_TRAMITE] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[INGRESO_TRAMITE](
[Codigo_Ingreso] [int] NOT NULL,
[PER_Codigo] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Codigo_jefevut] [int] NOT NULL,
[Res_Per_Codigo] [int] NOT NULL,
[Res_Codigo] [int] NOT NULL,
[Nombre/Razon_social] [varchar](50) NULL,
[Fecha_ingreso] [date] NULL,
[Hora_ingreso] [date] NULL,
[Nro_tramite] [int] NULL,
[Tipo_tramite] [varchar](50) NULL,
[Direccion] [varchar](50) NULL,
[Nro_arancel] [int] NULL,
[Descripcion_arancel] [varchar](50) NULL,
[Monto_arancel] [varchar](50) NULL,
[cod_ci] [int] NULL,
[telefono] [int] NULL,
CONSTRAINT [PK_INGRESO_TRAMITE] PRIMARY KEY CLUSTERED
(
[Codigo_Ingreso] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[DERIVACION_TRAMITE] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DERIVACION_TRAMITE](
[Cod_derivar] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Descripcion] [varchar](50) NULL,
CONSTRAINT [PK_DERIVACION_TRAMITE] PRIMARY KEY CLUSTERED
(
[Cod_derivar] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[USUARIO] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[USUARIO](
[Cod_CI] [int] NOT NULL,
[Cod_tramite] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Ent_Codigo] [int] NOT NULL,
[Nombre] [varchar](50) NULL,
[Direccion] [varchar](50) NULL,
[Telefono] [int] NULL,
CONSTRAINT [PK_USUARIO] PRIMARY KEY CLUSTERED
(
[Cod_CI] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[LIQUIDACION_ARANCEL] Script Date: 08/31/2011 17:01:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LIQUIDACION_ARANCEL](
[Cod_liquidación] [int] NOT NULL,
[Cod_verificacion] [int] NOT NULL,
[Codigo] [int] NOT NULL,
[Codigo_ingreso] [int] NOT NULL,
[Per_Codigo] [int] NOT NULL,
[Res_Codigo] [int] NOT NULL,
[Nro_liquidacion] [int] NULL,
[Nombre/Razon_social] [varchar](50) NULL,
[Direccion] [varchar](50) NULL,
[Nro_cuenta] [int] NULL,
[Forma_pago] [varchar](50) NULL,
[Nr_arancel] [int] NULL,
[Descripcion] [varchar](50) NULL,
[Monto_arancel] [int] NULL,
[Cantidad] [int] NULL,
[Fecha_liquidacion] [date] NULL,
[hora_liquidacion] [date] NULL,
[Glosa] [int] NULL,
CONSTRAINT [PK_LIQUIDACION_ARANCEL] PRIMARY KEY CLUSTERED
(
[Cod_liquidación] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Suscribirse a:
Comentarios (Atom)