influence/ddl/012_item_order_list.sql

-- shopdeli.ITEM_ORDER_LIST definition

CREATE TABLE `ITEM_ORDER_LIST` (
  `SEQ` int(11) NOT NULL AUTO_INCREMENT,
  `ITEM_SEQ` int(11) NOT NULL,
  `INF_SEQ` int(11) NOT NULL COMMENT '인플루언서 시퀀스',
  `BUYER_NAME` varchar(50) NOT NULL COMMENT '구매자명',
  `ADDRESS` varchar(500) NOT NULL COMMENT '구매자 주소',
  `PHONE` varchar(50) NOT NULL,
  `EMAIL` varchar(50) NOT NULL,
  `QTY` int(11) NOT NULL DEFAULT 0 COMMENT '구매수량',
  `TOTAL` int(11) NOT NULL DEFAULT 0 COMMENT '총구매금액',
  `DELI_COMP` varchar(50) DEFAULT NULL COMMENT '배송업체',
  `DELI_NUMB` varchar(50) DEFAULT NULL COMMENT '송장번호',
  `ORDER_DATE` timestamp NOT NULL DEFAULT current_timestamp() COMMENT '주문일자',
  `REG_DATE` timestamp NOT NULL DEFAULT current_timestamp() COMMENT '저장일자',
  PRIMARY KEY (`SEQ`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;