shop2
Tables (5)
member
- ID — varchar2(20) — Primary key — NOT NULL
- Pwd — varchar2(20)
- name — varchar2(20)
- address — varchar2(20)
- tel — varchar2(13)
- indate — date
- zipcode2 — varchar2(7) — Foreign key → tb_zipcode.zipcode — NOT NULL
orders
- sale_date — date — Primary key — NOT NULL
- product_code — varchar2(260 NOT NULL, `ID` varchar2(20) — Foreign key → product.product_code — NOT NULL
- sale_amount — varchar2(5) — NOT NULL
- sale_price — varchar2(6) — NOT NULL
- sale_tot_price — varchar2(15) — NOT NULL
product
- product_code — varchar2(260 NOT NULL, `product_name` varchar2(100) — Primary key — NOT NULL
- product_url — blob
- nation_code — varchar2(6)
- product_type_code — varchar2(6)
- product_price — number(15) — NOT NULL
- product_vintage — date
- theme_code — varchar2(6 )
- today_code — varchar2(6)
sample
- id — date
- name — varchat2(30)
- Field
tb_zipcode
- zipcode — varchar2(7) — Primary key — NOT NULL
- sido — varchar2(30)
- gugun — varchar2(30)
- dong — varchat2(30)
- bungi — varchar2(30)