def |
Artist |
PAINTER |
PTR_AREACODE |
4 |
NULL
|
YES |
char |
3 |
12 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(3) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Artist |
PAINTER |
PTR_FIRSTNAME |
3 |
NULL
|
NO |
varchar |
15 |
60 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(15) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Artist |
PAINTER |
PTR_LASTNAME |
2 |
NULL
|
NO |
varchar |
15 |
60 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(15) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Artist |
PAINTER |
PTR_NUM |
1 |
NULL
|
NO |
char |
4 |
16 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(4) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
Artist |
PAINTER |
PTR_PHONE |
5 |
NULL
|
YES |
char |
7 |
28 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(7) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Artist |
PAINTING |
PNTG_NUM |
1 |
NULL
|
NO |
char |
4 |
16 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(4) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
Artist |
PAINTING |
PNTG_PRICE |
3 |
NULL
|
NO |
float |
NULL
|
NULL
|
9 |
2 |
NULL
|
NULL
|
NULL
|
float(9,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Artist |
PAINTING |
PNTG_TITLE |
2 |
NULL
|
NO |
varchar |
35 |
140 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(35) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
Artist |
PAINTING |
PTR_NUM |
4 |
NULL
|
YES |
char |
4 |
16 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
char(4) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Cantidad Ciclo Estándar |
10 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Cantidad Consumida |
12 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Cantidad Planificada |
11 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Código |
6 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Código Operación |
4 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Código TdC |
1 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Descripción |
7 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Descripción Operación |
5 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Proceso |
2 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Tipo Material |
9 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Tipo TdC |
3 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
PRUEBA |
MATERIAL |
Unidad de Medida |
8 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
StdMdDB |
course |
hours_number |
3 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
StdMdDB |
course |
id |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
StdMdDB |
course |
label |
2 |
NULL
|
NO |
varchar |
50 |
200 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(50) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
StdMdDB |
score |
course_id |
2 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|