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
Publicado por en

No hay comentarios:

Publicar un comentario

Suscribirse a: Enviar comentarios (Atom)