-
-
Notifications
You must be signed in to change notification settings - Fork 2
/
BaseDeDatos.sql
59 lines (59 loc) · 3.1 KB
/
BaseDeDatos.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
USE [puntodeVenta]
GO
/****** Object: Table [dbo].[Categorias] Script Date: 12/12/2021 11:08:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Categorias](
[id_categoria] [int] NULL,
[categoria] [nvarchar](30) NULL,
[id_catparent] [int] NULL
) ON [PRIMARY]
GO
/****** Object: Table [dbo].[Empleados] Script Date: 12/12/2021 11:08:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Empleados](
[id_empleado] [int] NULL,
[nombre] [nvarchar](50) NULL,
[apellido] [nvarchar](50) NULL,
[rol] [int] NULL,
[usuario] [nvarchar](10) NULL,
[password] [nvarchar](10) NULL,
[image] [nvarchar](max) NULL,
[lastConn] [nvarchar](30) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Productos] Script Date: 12/12/2021 11:08:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Productos](
[id_producto] [int] NULL,
[nombre] [nvarchar](50) NULL,
[precio] [float] NULL,
[categoria] [int] NULL,
[stock] [int] NULL,
[modo] [int] NULL,
[image] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object: Table [dbo].[Tickets] Script Date: 12/12/2021 11:08:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Tickets](
[idTicket] [int] NULL,
[productos] [nvarchar](max) NULL,
[fecha] [nvarchar](15) NULL,
[hora] [nvarchar](10) NULL,
[tVenta] [float] NULL,
[tPago] [float] NULL,
[idEmpleado] [nchar](10) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO