def |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Кількість дзвінків кожного абонента |
Кількість дзвінків |
2 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Кількість дзвінків кожного абонента |
Назва |
1 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Тарифна сітка |
Тип даних |
2 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ |
Тарифна сітка |
Ім'я поля |
1 |
NULL
|
NO |
text |
65535 |
65535 |
NULL
|
NULL
|
NULL
|
utf8 |
utf8_general_ci |
text |
|
|
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
products |
id |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
products |
name |
2 |
NULL
|
YES |
varchar |
30 |
30 |
NULL
|
NULL
|
NULL
|
latin1 |
latin1_swedish_ci |
varchar(30) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
products |
price |
3 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users |
email_id |
2 |
NULL
|
NO |
varchar |
255 |
255 |
NULL
|
NULL
|
NULL
|
latin1 |
latin1_swedish_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users |
first_name |
3 |
NULL
|
NO |
varchar |
20 |
20 |
NULL
|
NULL
|
NULL
|
latin1 |
latin1_swedish_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users |
id |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users |
last_name |
4 |
NULL
|
YES |
varchar |
20 |
20 |
NULL
|
NULL
|
NULL
|
latin1 |
latin1_swedish_ci |
varchar(20) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users |
password |
7 |
NULL
|
NO |
varchar |
255 |
255 |
NULL
|
NULL
|
NULL
|
latin1 |
latin1_swedish_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users |
phone |
5 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(10) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users |
registration_time |
6 |
CURRENT_TIMESTAMP |
NO |
timestamp |
NULL
|
NULL
|
NULL
|
NULL
|
0 |
NULL
|
NULL
|
timestamp |
|
DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users_products |
id |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
auto_increment |
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users_products |
item_id |
3 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users_products |
status |
4 |
NULL
|
NO |
enum |
13 |
13 |
NULL
|
NULL
|
NULL
|
latin1 |
latin1_swedish_ci |
enum('Added To Cart','Confirmed') |
|
|
select,insert,update,references |
|
|
NULL
|
def |
"ecommerce" |
users_products |
user_id |
2 |
NULL
|
YES |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
MUL |
|
select,insert,update,references |
|
|
NULL
|
def |
FitriAssignment2 |
ITEMS |
ItemID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
FitriAssignment2 |
ITEMS |
ItemName |
2 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
FitriAssignment2 |
ITEMS |
Type |
3 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
FitriAssignment2 |
ITEMS |
UnitPrice |
4 |
NULL
|
YES |
decimal |
NULL
|
NULL
|
10 |
2 |
NULL
|
NULL
|
NULL
|
decimal(10,2) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
LeaderNameAssignment2 |
ITEMS |
ItemID |
1 |
NULL
|
NO |
int |
NULL
|
NULL
|
10 |
0 |
NULL
|
NULL
|
NULL
|
int(11) |
PRI |
|
select,insert,update,references |
|
|
NULL
|
def |
LeaderNameAssignment2 |
ITEMS |
ItemName |
2 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|
def |
LeaderNameAssignment2 |
ITEMS |
Type |
3 |
NULL
|
YES |
varchar |
255 |
1020 |
NULL
|
NULL
|
NULL
|
utf8mb4 |
utf8mb4_0900_ai_ci |
varchar(255) |
|
|
select,insert,update,references |
|
|
NULL
|