Closed seongkyu-lim closed 2 years ago
mysql 테이블
order_table
CREATE TABLE order_table (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'index',
user_id bigint(20) NOT NULL,
name varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
emptyness bit(1) NOT NULL,
number_of_guests int(4) NOT NULL,
created_at datetime NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
orders
CREATE TABLE orders (
id bigint(20) NOT NULL AUTO_INCREMENT,
order_type varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
payment_price bigint(20) NOT NULL,
payment_method varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
requirement varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
delivery_address varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
created_at datetime NOT NULL,
order_table_id bigint(20) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
order_menu
CREATE TABLE order_menu (
id bigint(20) NOT NULL AUTO_INCREMENT,
quantity bigint(20) DEFAULT NULL,
created_at datetime NOT NULL,
orders_id bigint(20) NOT NULL,
menu_id bigint(20) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
menu
CREATE TABLE menu (
id bigint(20) NOT NULL AUTO_INCREMENT,
name varchar(20) DEFAULT NULL,
price int(11) NOT NULL,
is_hidden bit(1) NOT NULL,
created_at datetime NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
json for order create test
{
"userId": 1,
"emptyness": true,
"tableName": "1번 테이블",
"numberOfGuests": 4,
"orderDtoList": [
{
"orderType": "매장식사",
"paymentMethod": "카드",
"requirement": "맛있게 부탁드려요",
"deliveryAddress": "없음",
"orderMenuDtoList": [
{
"quantity": 2,
"menuName": "짬뽕 세트"
}
]
},
{
"orderType": "포장",
"paymentMethod": "카드",
"requirement": "맛있게 부탁드려요",
"deliveryAddress": "없음",
"orderMenuDtoList": [
{
"quantity": 1,
"menuName": "짜장 세트"
}
]
}
]
}
6edc962a42daa9c1677f88e3ad3becb3c3af36da
요구사항 : 주문 테이블을 등록할 수 있다.
남은 과제