Repository navigation
Expand file tree
/
Copy pathEq2_proyFinalScript.sql
More file actions
190 lines (171 loc) · 4.58 KB
/
Copy pathEq2_proyFinalScript.sql
File metadata and controls
190 lines (171 loc) · 4.58 KB
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
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
CREATE DATABASE proyecto;
USE proyecto
CREATE TABLE INMUEBLE(
CveInmueble INT NOT NULL PRIMARY KEY,
NomInmueble VARCHAR(30) NOT NULL,
DirInmueble VARCHAR(50) NOT NULL,
TamInmueble INT NOT NULL
) ENGINE=InnoDB;
CREATE TABLE EVENTO(
CveEvento INT NOT NULL PRIMARY KEY,
NomEvento VARCHAR(30) NOT NULL,
FechaEvento DATE NOT NULL,
sjdjadjsaj
TipoEvento VARCHAR (20) NOT NULL,
CveInmueble INT NOT NULL,
FOREIGN KEY (CveInmueble) REFERENCES INMUEBLE(CveInmueble)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE GENEROMUSICAL(
CveEvento INT NOT NULL,
GeneroMusic VARCHAR(15) NOT NULL,
PRIMARY KEY (CveEvento,GeneroMusic),
FOREIGN KEY (CveEvento) REFERENCES EVENTO(CveEvento)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE ARTISTA(
CveArtista INT NOT NULL PRIMARY KEY,
NomArtista VARCHAR(30) NOT NULL,
GeneroArtista VARCHAR(15) NOT NULL,
EscenarioArtista VARCHAR(20) NOT NULL
) ENGINE=InnoDB;
CREATE TABLE CASHLESS(
CveCash INT NOT NULL PRIMARY KEY,
Saldo INT NOT NULL,
ApPa VARCHAR(20),
ApMa VARCHAR(20),
NomP VARCHAR(30),
CveEvento INT NOT NULL,
FOREIGN KEY (CveEvento) REFERENCES EVENTO(CveEvento)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE PERSONA(
CvePersona INT NOT NULL PRIMARY KEY,
ApPat VARCHAR(20) NOT NULL,
ApMat VARCHAR(20),
NomPila VARCHAR(20) NOT NULL,
Correo VARCHAR(25) NOT NULL
) ENGINE=InnoDB;
CREATE TABLE COMPRA(
CveCompra INT NOT NULL PRIMARY KEY,
CveEvento INT NOT NULL,
CvePersona INT NOT NULL,
FOREIGN KEY (CveEvento) REFERENCES EVENTO(CveEvento)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY (CvePersona) REFERENCES PERSONA(CvePersona)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE BOLETO(
CveBoleto INT NOT NULL PRIMARY KEY,
NomEvento VARCHAR(30) NOT NULL,
NoAsiento INT,
TipoBoleto VARCHAR(20) NOT NULL,
Fecha DATE NOT NULL,
Seccion VARCHAR(10)
) ENGINE=InnoDB;
CREATE TABLE DETALLECOMPRA(
FecCompra DATE NOT NULL,
Monto INT NOT NULL,
Cantidad INT NOT NULL,
CveCompra INT NOT NULL,
CveBoleto INT NOT NULL,
PRIMARY KEY (FecCompra,CveCompra,CveBoleto),
FOREIGN KEY (CveCompra) REFERENCES COMPRA(CveCompra)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY (CveBoleto) REFERENCES BOLETO(CveBoleto)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE ORGANIZACION(
CveOrga INT NOT NULL PRIMARY KEY,
NoEmpleados INT NOT NULL,
SupervisorOrg INT NOT NULL,
TipoOrg VARCHAR(15) NOT NULL,
EncargadosOrg INT NOT NULL,
CveInmueble INT NOT NULL,
FOREIGN KEY (CveInmueble) REFERENCES INMUEBLE(CveInmueble)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE EMPLEADO(
CveEmpleado INT NOT NULL PRIMARY KEY,
ApPa VARCHAR(20) NOT NULL,
ApMa VARCHAR(20) NOT NULL,
NomP VARCHAR(30) NOT NULL,
DirEmpleado VARCHAR(50) NOT NULL,
Cargo VARCHAR(20) NOT NULL
) ENGINE=InnoDB;
CREATE TABLE TURNOS(
CveEmpleado INT NOT NULL,
TurnosEm VARCHAR(30) NOT NULL,
PRIMARY KEY (CveEmpleado,TurnosEm),
FOREIGN KEY (CveEmpleado) REFERENCES EMPLEADO(CveEmpleado)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE PATROCINIO(
CvePatro INT NOT NULL PRIMARY KEY,
NomPat VARCHAR(30),
EmpresaCargo VARCHAR(30),
TipoPat VARCHAR(20)
) ENGINE=InnoDB;
CREATE TABLE ACREDITACION(
CveAcre INT NOT NULL PRIMARY KEY,
Zona VARCHAR(20) NOT NULL,
TipoAcre VARCHAR(20) NOT NULL,
CvePersona INT NOT NULL,
FOREIGN KEY (CvePersona) REFERENCES PERSONA(CvePersona)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE PUBLICIDAD(
CvePubli INT NOT NULL PRIMARY KEY,
NomPub VARCHAR(30) NOT NULL,
TipoPubl VARCHAR(20) NOT NULL,
EncargadiPub VARCHAR(30) NOT NULL,
CvePatro INT NOT NULL,
FOREIGN KEY (CvePatro) REFERENCES PATROCINIO(CvePatro)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE ARTISTA_EVENTO(
CveArtista INT NOT NULL,
CveEvento INT NOT NULL,
Fecha DATE NOT NULL,
HORA TIME NOT NULL,
PRIMARY KEY (CveArtista,CveEvento),
FOREIGN KEY (CveArtista) REFERENCES ARTISTA(CveArtista)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY (CveEvento) REFERENCES EVENTO(CveEvento)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE PATROCINADO(
CveInmueble INT NOT NULL,
CvePatro INT NOT NULL,
PRIMARY KEY (CveInmueble,CvePatro),
FOREIGN KEY (CveInmueble) REFERENCES INMUEBLE(CveInmueble)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY (CvePatro) REFERENCES PATROCINIO(CvePatro)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;
CREATE TABLE TRABAJA_EN(
CveOrga INT NOT NULL,
CveEmpleado INT NOT NULL,
PRIMARY KEY (CveOrga,CveEmpleado),
FOREIGN KEY (CveOrga) REFERENCES ORGANIZACION(CveOrga)
ON DELETE CASCADE
ON UPDATE CASCADE,
FOREIGN KEY (CveEmpleado) REFERENCES EMPLEADO(CveEmpleado)
ON DELETE CASCADE
ON UPDATE CASCADE
) ENGINE=InnoDB;