2134

Tables (3)

tbl_order_202101

  • orderno — char(8)
  • shopcode — char(4)
  • orderdate — varchar2(8)
  • pcode — char(4)
  • amount — number(5)

tbl_product_202101

  • pcode — char(4)
  • pname — varchar2(30)
  • cost — number(7)

tbl_shop_202101

  • shopname — varchar2(20)
  • shopcode — char(4)
  • discount — number(2)