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)