QT/팀프로젝트01 - 키오스크
[Qt] DB
polibo
2025. 5. 15. 11:59
1. 데이터 베이스 만들기
CREATE DATABASE M4NGO_DB2;
2. DB로 들어가요
USE M4NGO_DB2;
3. MENU 테이블 만들기
CREATE TABLE MENU(
MENU_ID SMALLINT UNSIGNED NOT NULL PRIMARY KEY,
NAME VARCHAR(100),
PRICE INT UNSIGNED,
BASIC_SIZE VARCHAR(2),
SIZE_OPT VARCHAR(2),
SOLDOUT BOOL,
OPTION_EXIST BOOL,
PATH VARCHAR(100));
4. MENU 테이블에 값 넣기
MariaDB [M4NGO_DB2]> LOAD DATA LOCAL INFILE '/home/boeun/QT_PROJECT/QT_Team_Project_gomango/NEW_DB/M4NGO_MENU.csv'
-> INTO TABLE MENU CHARACTER SET 'UTF8'
-> COLUMNS TERMINATED BY ','
-> ENCLOSED BY '"'
-> LINES TERMINATED BY '\r\n'
-> IGNORE 1 LINES;
Query OK, 87 rows affected, 2 warnings (0.013 sec)
Records: 87 Deleted: 0 Skipped: 0 Warnings: 2
MariaDB [M4NGO_DB2]> SHOW WARNINGS;
+---------+------+----------------------------------------------------------------------------+
| Level | Code | Message |
+---------+------+----------------------------------------------------------------------------+
| Warning | 1262 | Row 27 was truncated; it contained more data than there were input columns |
| Warning | 1265 | Data truncated for column 'PATH' at row 67 |
+---------+------+----------------------------------------------------------------------------+
2 rows in set (0.000 sec)MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM MENU;
+--------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------------+------+-----+---------+-------+
| MENU_ID | smallint(5) unsigned | NO | PRI | NULL | |
| NAME | varchar(100) | YES | | NULL | |
| PRICE | int(10) unsigned | YES | | NULL | |
| BASIC_SIZE | varchar(2) | YES | | NULL | |
| SIZE_OPT | varchar(2) | YES | | NULL | |
| SOLDOUT | tinyint(1) | YES | | NULL | |
| OPTION_EXIST | tinyint(1) | YES | | NULL | |
| PATH | varchar(100) | YES | | NULL | |
+--------------+----------------------+------+-----+---------+-------+
8 rows in set (0.001 sec)
5. OPTION 테이블 만들기
MariaDB [M4NGO_DB4]> CREATE TABLE OPTION (
-> OPT_ID TINYINT UNSIGNED NOT NULL PRIMARY KEY,
-> OPT_NAME VARCHAR(30),
-> PATH VARCHAR(100));
Query OK, 0 rows affected (0.015 sec)
6. OPTION 테이블 값 넣기
MariaDB [M4NGO_DB2]> LOAD DATA LOCAL INFILE '/home/boeun/QT_PROJECT/QT_Team_Project_gomango/NEW_DB/M4NGO_OPTION.csv' INTO TABLE OPTION CHARACTER SET 'UTF8' COLUMNS TERMINATED BY ',' ENCLOSED BY '"' LI
NES TERMINATED BY '\r\n' IGNORE 1 LINES;
Query OK, 5 rows affected (0.008 sec)
Records: 5 Deleted: 0 Skipped: 0 Warnings: 0
MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM OPTION;
+----------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+---------------------+------+-----+---------+-------+
| OPT_ID | tinyint(3) unsigned | NO | PRI | NULL | |
| OPT_NAME | varchar(30) | YES | | NULL | |
+----------+---------------------+------+-----+---------+-------+
2 rows in set (0.001 sec)
MariaDB [M4NGO_DB2]> SELECT * FROM OPTION;
+--------+-----------+
| OPT_ID | OPT_NAME |
+--------+-----------+
| 1 | SHOT |
| 2 | SYRUP |
| 3 | JELLY |
| 4 | SAGOPEARL |
| 5 | WHIPPING |
+--------+-----------+
5 rows in set (0.000 sec)
7. OPT_DETAIL 테이블 만들기
MariaDB [M4NGO_DB2]> CREATE TABLE OPT_DETAIL(
-> OPT_DETAIL_ID TINYINT UNSIGNED NOT NULL PRIMARY KEY,
-> OPT_ID TINYINT UNSIGNED NOT NULL,
-> OPT_DETAIL_NAME VARCHAR(50),
-> PRICE SMALLINT UNSIGNED,
-> PATH VARCHAR(100));
Query OK, 0 rows affected (0.017 sec)
8. OPT_DETAIL 테이블에 값 넣기
MariaDB [M4NGO_DB2]> LOAD DATA LOCAL INFILE '/home/boeun/QT_PROJECT/QT_Team_Project_gomango/NEW_DB/M4NGO_OPTION_DETAILED.csv' INTO TABLE OPT_DETAIL CHARACTER SET 'UTF8' COLUMNS TERMINATED BY ',' ENCLO
SED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;
Query OK, 13 rows affected (0.008 sec)
Records: 13 Deleted: 0 Skipped: 0 Warnings: 0
MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM OPT_DETAIL;
+-----------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+----------------------+------+-----+---------+-------+
| OPT_DETAIL_ID | tinyint(3) unsigned | NO | PRI | NULL | |
| OPT_ID | tinyint(3) unsigned | NO | | NULL | |
| OPT_DETAIL_NAME | varchar(50) | YES | | NULL | |
| PRICE | smallint(5) unsigned | YES | | NULL | |
+-----------------+----------------------+------+-----+---------+-------+
4 rows in set (0.001 sec)
MariaDB [M4NGO_DB2]> SELECT * FROM OPT_DETAIL;
+---------------+--------+---------------------------+-------+
| OPT_DETAIL_ID | OPT_ID | OPT_DETAIL_NAME | PRICE |
+---------------+--------+---------------------------+-------+
| 1 | 1 | 추가없음 | 0 |
| 2 | 1 | 1샷추가 | 500 |
| 3 | 1 | 2샷추가 | 1000 |
| 4 | 2 | 추가없음 | 0 |
| 5 | 2 | 바닐라시럽추가 | 500 |
| 6 | 3 | 추가없음 | 0 |
| 7 | 3 | 코코넛젤리추가 | 500 |
| 8 | 3 | 코코넛젤리2회추가 | 1000 |
| 9 | 4 | 추가없음 | 0 |
| 10 | 4 | 사고펄1회추가 | 500 |
| 11 | 4 | 사고펄2회추가 | 1000 |
| 12 | 5 | 휘핑빼기 | 0 |
| 13 | 5 | 기본 | 0 |
+---------------+--------+---------------------------+-------+
13 rows in set (0.000 sec)
9. SIZE 테이블 만들기
MariaDB [M4NGO_DB2]> CREATE TABLE SIZE(
-> SIZE_ID VARCHAR(2) PRIMARY KEY,
-> PRICE SMALLINT UNSIGNED);
Query OK, 0 rows affected (0.017 sec)
10. SIZE 테이블에 값 넣기
MariaDB [M4NGO_DB2]> LOAD DATA LOCAL INFILE '/home/boeun/QT_PROJECT/QT_Team_Project_gomango/NEW_DB/M4NGO_SIZEUP.csv' INTO TABLE SIZE CHARACTER SET 'UTF8' COLUMNS TERMINATED BY ',' ENCLOSED BY '"' LINE
S TERMINATED BY '\r\n' IGNORE 1 LINES;
Query OK, 4 rows affected (0.008 sec)
Records: 4 Deleted: 0 Skipped: 0 Warnings: 0
MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM SIZE;
+---------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+----------------------+------+-----+---------+-------+
| SIZE_ID | varchar(2) | NO | PRI | NULL | |
| PRICE | smallint(5) unsigned | YES | | NULL | |
+---------+----------------------+------+-----+---------+-------+
2 rows in set (0.001 sec)
MariaDB [M4NGO_DB2]> SELECT * FROM SIZE;
+---------+-------+
| SIZE_ID | PRICE |
+---------+-------+
| A | 500 |
| B | 1000 |
| C | 1200 |
| D | 0 |
+---------+-------+
4 rows in set (0.000 sec)
11. MENU_OPT 테이블 만들기
MariaDB [M4NGO_DB2]> CREATE TABLE MENU_OPT(
-> MENU_OPT_ID TINYINT UNSIGNED NOT NULL PRIMARY KEY,
-> MENU_ID SMALLINT UNSIGNED NOT NULL,
-> OPT_ID TINYINT UNSIGNED NOT NULL);
Query OK, 0 rows affected (0.019 sec)
12. MENU_OPT 테이블에 값 넣기
MariaDB [M4NGO_DB2]> LOAD DATA LOCAL INFILE '/home/boeun/QT_PROJECT/QT_Team_Project_gomango/NEW_DB/M4NGO_MENU_OPT.csv' INTO TABLE MENU_OPT CHARACTER SET 'UTF8' COLUMNS TERMINATED BY ',' ENCLOSED BY '"
' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;
Query OK, 102 rows affected (0.010 sec)
Records: 102 Deleted: 0 Skipped: 0 Warnings: 0
MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM MENU_OPT;
+-------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------------+------+-----+---------+-------+
| MENU_OPT_ID | tinyint(3) unsigned | NO | PRI | NULL | |
| MENU_ID | smallint(5) unsigned | NO | | NULL | |
| OPT_ID | tinyint(3) unsigned | NO | | NULL | |
+-------------+----------------------+------+-----+---------+-------+
3 rows in set (0.001 sec)
MariaDB [M4NGO_DB2]> SELECT * FROM MENU_OPT;
+-------------+---------+--------+
| MENU_OPT_ID | MENU_ID | OPT_ID |
+-------------+---------+--------+
| 1 | 102 | 3 |
| 2 | 102 | 4 |
| 3 | 103 | 3 |
| 4 | 103 | 4 |
| 5 | 104 | 3 |
| 6 | 104 | 4 |
| 7 | 107 | 3 |
| 8 | 107 | 4 |
| 9 | 108 | 3 |
| 10 | 108 | 4 |
| 11 | 201 | 3 |
| 12 | 201 | 4 |
| 13 | 202 | 3 |
| 14 | 202 | 4 |
| 15 | 203 | 3 |
| 16 | 203 | 4 |
| 17 | 205 | 3 |
| 18 | 205 | 4 |
| 19 | 206 | 3 |
| 20 | 206 | 4 |
| 21 | 207 | 3 |
| 22 | 207 | 4 |
| 23 | 208 | 3 |
| 24 | 208 | 4 |
| 25 | 210 | 3 |
| 26 | 210 | 4 |
| 27 | 211 | 3 |
| 28 | 211 | 4 |
| 29 | 212 | 3 |
| 30 | 212 | 4 |
| 31 | 213 | 3 |
| 32 | 213 | 4 |
| 33 | 214 | 3 |
| 34 | 214 | 4 |
| 35 | 215 | 3 |
| 36 | 215 | 4 |
| 37 | 216 | 3 |
| 38 | 216 | 4 |
| 39 | 217 | 4 |
| 40 | 217 | 5 |
| 41 | 218 | 3 |
| 42 | 218 | 4 |
| 43 | 218 | 5 |
| 44 | 219 | 3 |
| 45 | 219 | 4 |
| 46 | 222 | 3 |
| 47 | 222 | 4 |
| 48 | 301 | 1 |
| 49 | 302 | 1 |
| 50 | 303 | 1 |
| 51 | 304 | 1 |
| 52 | 304 | 2 |
| 53 | 305 | 1 |
| 54 | 305 | 2 |
| 55 | 308 | 1 |
| 56 | 309 | 1 |
| 57 | 310 | 1 |
| 58 | 310 | 5 |
| 59 | 311 | 1 |
| 60 | 312 | 1 |
| 61 | 312 | 2 |
| 62 | 313 | 1 |
| 63 | 314 | 1 |
| 64 | 315 | 1 |
| 65 | 315 | 2 |
| 66 | 316 | 1 |
| 67 | 407 | 5 |
| 68 | 408 | 5 |
| 69 | 503 | 3 |
| 70 | 503 | 4 |
| 71 | 504 | 3 |
| 72 | 505 | 3 |
| 73 | 506 | 3 |
| 74 | 507 | 3 |
| 75 | 510 | 3 |
| 76 | 510 | 4 |
| 77 | 511 | 3 |
| 78 | 511 | 4 |
| 79 | 701 | 1 |
| 80 | 701 | 2 |
| 81 | 702 | 1 |
| 82 | 702 | 2 |
| 83 | 703 | 3 |
| 84 | 703 | 4 |
| 85 | 704 | 1 |
| 86 | 704 | 2 |
| 87 | 705 | 1 |
| 88 | 705 | 2 |
| 89 | 706 | 3 |
| 90 | 706 | 4 |
| 91 | 707 | 1 |
| 92 | 707 | 2 |
| 93 | 708 | 1 |
| 94 | 708 | 2 |
| 95 | 709 | 1 |
| 96 | 709 | 2 |
| 97 | 710 | 1 |
| 98 | 710 | 2 |
| 99 | 711 | 1 |
| 100 | 711 | 2 |
| 101 | 712 | 1 |
| 102 | 712 | 2 |
+-------------+---------+--------+
102 rows in set (0.000 sec)
13. 외래키 추가해주기
MariaDB [M4NGO_DB2]> ALTER TABLE MENU ADD FOREIGN KEY (SIZE_OPT) REFERENCES SIZE (SIZE_ID);
Query OK, 87 rows affected (0.039 sec)
Records: 87 Duplicates: 0 Warnings: 0
MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM MENU;
+--------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------------+------+-----+---------+-------+
| MENU_ID | smallint(5) unsigned | NO | PRI | NULL | |
| NAME | varchar(100) | YES | | NULL | |
| PRICE | int(10) unsigned | YES | | NULL | |
| BASIC_SIZE | varchar(2) | YES | | NULL | |
| SIZE_OPT | varchar(2) | YES | MUL | NULL | |
| SOLDOUT | tinyint(1) | YES | | NULL | |
| OPTION_EXIST | tinyint(1) | YES | | NULL | |
| PATH | varchar(100) | YES | | NULL | |
+--------------+----------------------+------+-----+---------+-------+
8 rows in set (0.009 sec)
MariaDB [M4NGO_DB2]> ALTER TABLE OPT_DETAIL ADD FOREIGN KEY (OPT_ID) REFERENCES OPTION (OPT_ID);
Query OK, 13 rows affected (0.028 sec)
Records: 13 Duplicates: 0 Warnings: 0
MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM OPT_DETAIL;
+-----------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+----------------------+------+-----+---------+-------+
| OPT_DETAIL_ID | tinyint(3) unsigned | NO | PRI | NULL | |
| OPT_ID | tinyint(3) unsigned | NO | MUL | NULL | |
| OPT_DETAIL_NAME | varchar(50) | YES | | NULL | |
| PRICE | smallint(5) unsigned | YES | | NULL | |
+-----------------+----------------------+------+-----+---------+-------+
4 rows in set (0.009 sec)
MariaDB [M4NGO_DB2]> ALTER TABLE MENU_OPT ADD FOREIGN KEY (OPT_ID) REFERENCES OPTION (OPT_ID);
Query OK, 102 rows affected (0.034 sec)
Records: 102 Duplicates: 0 Warnings: 0
MariaDB [M4NGO_DB2]> ALTER TABLE MENU_OPT ADD FOREIGN KEY (MENU_ID) REFERENCES MENU (MENU_ID);
Query OK, 102 rows affected (0.038 sec)
Records: 102 Duplicates: 0 Warnings: 0
MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM MENU_OPT;
+-------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------------+------+-----+---------+-------+
| MENU_OPT_ID | tinyint(3) unsigned | NO | PRI | NULL | |
| MENU_ID | smallint(5) unsigned | NO | MUL | NULL | |
| OPT_ID | tinyint(3) unsigned | NO | MUL | NULL | |
+-------------+----------------------+------+-----+---------+-------+
3 rows in set (0.004 sec)
14. USER_INFO 테이블 만들기
MariaDB [M4NGO_DB2]> CREATE TABLE USER_INFO( USER_ID VARCHAR(11) NOT NULL PRIMARY KEY, TOTAL_STAMP TINYINT UNSIGNED, USED_STAMP TINYINT UNSIGNED);
Query OK, 0 rows affected (0.015 sec)
MariaDB [M4NGO_DB2]> INSERT INTO USER_INFO VALUES('01000000000', 3, 0);
Query OK, 1 row affected (0.008 sec)
MariaDB [M4NGO_DB2]> SELECT * FROM USER_INFO;
+-------------+-------------+------------+
| USER_ID | TOTAL_STAMP | USED_STAMP |
+-------------+-------------+------------+
| 01000000000 | 3 | 0 |
+-------------+-------------+------------+
1 row in set (0.000 sec)
DEFAULT값 변경하기
MariaDB [M4NGO_DB3]> ALTER TABLE USER_INFO ALTER COLUMN USED_STAMP SET DEFAULT 0;
Query OK, 0 rows affected (0.018 sec)
Records: 0 Duplicates: 0 Warnings: 0
MariaDB [M4NGO_DB3]> SHOW COLUMNS FROM USER_INFO;
+-------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+-------+
| USER_ID | varchar(11) | NO | PRI | NULL | |
| TOTAL_STAMP | tinyint(3) unsigned | YES | | NULL | |
| USED_STAMP | tinyint(3) unsigned | YES | | 0 | |
+-------------+---------------------+------+-----+---------+-------+15. 결제 TABLE 만들기
MariaDB [M4NGO_DB2]> CREATE TABLE PAY(PAY_ID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, ORDER_TIME DATETIME, PRICE INT UNSIGNED);
Query OK, 0 rows affected (0.017 sec)
MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM PAY;
+------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+------------------+------+-----+---------+----------------+
| PAY_ID | int(10) unsigned | NO | PRI | NULL | auto_increment |
| ORDER_TIME | datetime | YES | | NULL | |
| PRICE | int(10) unsigned | YES | | NULL | |
+------------+------------------+------+-----+---------+----------------+
3 rows in set (0.001 sec)
MariaDB [M4NGO_DB2]> INSERT INTO PAY VALUES(1, '2025-05-15 14:00:00', 14900);
Query OK, 1 row affected (0.008 sec)
MariaDB [M4NGO_DB2]> SELECT * FROM PAY;
+--------+---------------------+-------+
| PAY_ID | ORDER_TIME | PRICE |
+--------+---------------------+-------+
| 1 | 2025-05-15 14:00:00 | 14900 |
+--------+---------------------+-------+
1 row in set (0.000 sec)
16. 주문 메뉴 리스트 TABLE 만들기
MariaDB [M4NGO_DB2]> CREATE TABLE ORDER_LIST(
-> ORDER_LIST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> PAY_ID INT UNSIGNED NOT NULL,
-> MENU_ID SMALLINT UNSIGNED NOT NULL,
-> EA SMALLINT UNSIGNED NOT NULL,
-> SIZEUP TINYINT UNSIGNED NOT NULL);
Query OK, 0 rows affected (0.017 sec)
MariaDB [M4NGO_DB2]> INSERT INTO ORDER_LIST VALUES(1, 1, 102, 2, 1);
Query OK, 1 row affected (0.008 sec)
MariaDB [M4NGO_DB2]> INSERT INTO ORDER_LIST VALUES(2, 1, 103, 1, 0);
Query OK, 1 row affected (0.008 sec)
MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM ORDER_LIST;
+---------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+----------------------+------+-----+---------+----------------+
| ORDER_LIST_ID | int(10) unsigned | NO | PRI | NULL | auto_increment |
| PAY_ID | int(10) unsigned | NO | | NULL | |
| MENU_ID | smallint(5) unsigned | NO | | NULL | |
| EA | smallint(5) unsigned | NO | | NULL | |
| SIZEUP | tinyint(3) unsigned | NO | | NULL | |
+---------------+----------------------+------+-----+---------+----------------+
5 rows in set (0.001 sec)
MariaDB [M4NGO_DB2]> SELECT * FROM ORDER_LIST;
+---------------+--------+---------+----+--------+
| ORDER_LIST_ID | PAY_ID | MENU_ID | EA | SIZEUP |
+---------------+--------+---------+----+--------+
| 1 | 1 | 102 | 2 | 1 |
| 2 | 1 | 103 | 1 | 0 |
+---------------+--------+---------+----+--------+
2 rows in set (0.000 sec)
17. 주문옵션 TABLE 만들기
MariaDB [M4NGO_DB2]> CREATE TABLE ORDER_OPT(
-> ORDER_OPT_ID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> ORDER_LIST_ID INT UNSIGNED NOT NULL,
-> OPT_DETAIL_ID TINYINT UNSIGNED NOT NULL);
Query OK, 0 rows affected (0.017 sec)
MariaDB [M4NGO_DB2]> INSERT INTO ORDER_OPT VALUES(1, 1, 7);
Query OK, 1 row affected (0.008 sec)
MariaDB [M4NGO_DB2]> INSERT INTO ORDER_OPT VALUES(2, 1, 11);
Query OK, 1 row affected (0.008 sec)
MariaDB [M4NGO_DB2]> INSERT INTO ORDER_OPT VALUES(3, 2, 6);
Query OK, 1 row affected (0.008 sec)
MariaDB [M4NGO_DB2]> SHOW COLUMNS FROM ORDER_OPT;
+---------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+----------------+
| ORDER_OTR_ID | int(10) unsigned | NO | PRI | NULL | auto_increment |
| ORDER_LIST_ID | int(10) unsigned | NO | | NULL | |
| OPT_DETAIL_ID | tinyint(3) unsigned | NO | | NULL | |
+---------------+---------------------+------+-----+---------+----------------+
3 rows in set (0.001 sec)
MariaDB [M4NGO_DB2]> SELECT * FROM ORDER_OPT;
+--------------+---------------+---------------+
| ORDER_OTR_ID | ORDER_LIST_ID | OPT_DETAIL_ID |
+--------------+---------------+---------------+
| 1 | 1 | 7 |
| 2 | 1 | 11 |
| 3 | 2 | 6 |
+--------------+---------------+---------------+
3 rows in set (0.000 sec)
18. 주문관련 외래키 추가하기
MariaDB [M4NGO_DB2]> ALTER TABLE ORDER_LIST ADD FOREIGN KEY (PAY_ID) REFERENCES PAY (PAY_ID);
Query OK, 2 rows affected (0.035 sec)
Records: 2 Duplicates: 0 Warnings: 0
MariaDB [M4NGO_DB2]> ALTER TABLE ORDER_LIST ADD FOREIGN KEY (MENU_ID) REFERENCES
MENU (MENU_ID);
Query OK, 2 rows affected (0.038 sec)
Records: 2 Duplicates: 0 Warnings: 0
MariaDB [M4NGO_DB2]> ALTER TABLE ORDER_OPT ADD FOREIGN KEY (ORDER_LIST_ID) REFERENCES ORDER_LIST (ORDER_LIST_ID);
Query OK, 3 rows affected (0.032 sec)
Records: 3 Duplicates: 0 Warnings: 0
MariaDB [M4NGO_DB2]> ALTER TABLE ORDER_OPT ADD FOREIGN KEY (OPT_DETAIL_ID) REFERENCES OPT_DETAIL (OPT_DETAIL_ID);
Query OK, 3 rows affected (0.037 sec)
Records: 3 Duplicates: 0 Warnings: 0