20201201_DB_스크립트.txt 392 B

123456789
  1. -- 입점업체 송장번호 등록 임시 테이블 생성
  2. CREATE TABLE TB_ENTRY_UPLOAD_EXCEL (
  3. ORD_NO INT(10) UNSIGNED NOT NULL COMMENT '주문번호'
  4. , ORD_DTL_NO INT(10) UNSIGNED NOT NULL COMMENT '주문상세이력번호'
  5. , REG_NO INT(10) UNSIGNED NOT NULL COMMENT '등록자번호'
  6. , REG_DT TIMESTAMP NOT NULL DEFAULT current_timestamp() COMMENT '등록일시'
  7. );
  8. COMMIT;