USE [Minds_Intermedia_Todito]
GO

/****** Object:  Table [dbo].[TARJETA]    Script Date: 21/02/2020 12:36:51 p. m. ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TARJETA](
    [IDREGISTRO] [int] IDENTITY(1,1) NOT NULL,
    [NIC] [varchar](50) NOT NULL,
    [NOCUENTA] [varchar](50) NOT NULL,
    [NOTARJETA] [varchar](50) NOT NULL,
    [FECHAAPERTURA] [datetime] NOT NULL,
    [FECHAVENCIMIENTO] [datetime] NULL,
    [CLAVEMONEDA] [varchar](10) NULL,
    [ACTIVO] [bit] NULL,
    [CLABE] [varchar](255) NULL,
    [FECHAACTUALIZACION] [datetime] NULL,
    [IDESTATUSCARGAMINDS] [int] NOT NULL,
    [IDTIPOTARJETA] [varchar](10) NULL,
    [FECHAREGISTRO] [datetime] NOT NULL,
    [NOMBREBENEF] [varchar](255) NULL,
    [FECHANACBENEF] [datetime] NULL,
    [RFCBENEF] [varchar](17) NULL,
 CONSTRAINT [PK_TARJETA] PRIMARY KEY CLUSTERED
(
    [IDREGISTRO] 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