Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Los script para Creación de Dimensiones
- CREATE TABLE [dbo].[DM_Cliente](
- [RUT] [varchar](255) not NULL,
- [NombreCompleto] [varchar](255) NULL,
- [Edad] [smallint] NULL,
- [Estado Civil] [varchar](255) NULL,
- [Cantidad de Hijos] [smallint] NULL
- CONSTRAINT [PK_DIM_Clientes] PRIMARY KEY CLUSTERED
- (
- [RUT] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- CREATE TABLE [dbo].[DIM_Sucursal](
- [ID_sucursal] [smallint] NOT NULL,
- [REGION_ID] [smallint] NULL,
- [REGION] [varchar](255) NULL,
- [PROVINCIA_ID] [smallint] NULL,
- [PROVINCIA] [varchar](255) NULL,
- [COMUNA_ID] [smallint] NULL,
- [CIUDAD_COMUNA] [varchar](255) NULL,
- CONSTRAINT [PK_DIM_Sucursal] PRIMARY KEY CLUSTERED
- (
- [ID_sucursal] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
- CREATE TABLE [dbo].[DIM_Producto](
- [CODIGO_ARTICULO] [varchar](255) NOT NULL,
- [Descripción] [varchar](255) NULL,
- [Categoría] [varchar](255) NULL,
- [SubCategoría] [varchar](255) NULL,
- [CostoUnitario] [int] NULL,
- CONSTRAINT [PK_DIM_Producto] PRIMARY KEY CLUSTERED
- (
- [CODIGO_ARTICULO] ASC
- )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
- ) ON [PRIMARY]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement