asasd

Tables (7)

admin

  • admin_id — varchar2(30)
  • admin_pwd — varchar2(100) — NOT NULL
  • admin_name — varchar2(15) — NOT NULL
  • admin_addr — varchar2(100)
  • admin_phone — varchar2(20)

customer

  • Key — Primary key — NOT NULL
  • customer_id — varchar2(30)
  • customer_pwd — varchar2(100) — NOT NULL
  • customer_name — varchar2(15) — NOT NULL
  • customer_addr — varchar2(100)
  • customer_phone — varchar2(20)

product

  • product_code — varchar2(100)
  • seller_id — varchar2(15)
  • product_category — varchar2(20)
  • product_thumbnail — varchar2(100)
  • product_name — varchar2(200) — NOT NULL
  • product_price — number — NOT NULL
  • product_from — varchar2(100)
  • product_detail — varchar2(200)
  • product_standard — varchar2(200)
  • product_qr — varchar2(100)
  • product_regdate — date

product_recipe

  • product_code — varchar2(100)
  • recipe_no — number

purchase

  • purchase_code — varchar2(100)
  • customer_id — varchar2(30)
  • product_code — varchar2(100)
  • product_cnt — number
  • purchase_date — date

recipe

  • recipe_no — number
  • recipe_name — varchar2(100)
  • recipe_site — varchar2(100)
  • recipe_url — varchar2(200)

seller

  • seller_id — varchar2(30)
  • seller_pwd — varchar2(100) — NOT NULL
  • seller_name — varchar2(15) — NOT NULL
  • seller_addr — varchar2(100)
  • seller_phone — varchar2(20)