shop2
Tables (5)
Sample
- id — date
- name — varchar2(30)
- Field3
- Field4
- Field5
member
- id — varchar2(20) — Primary key — NOT NULL
- pwd — varchar2(20)
- name — varchar2(20)
- address — varchar2(20)
- tel — varchar2(13)
- indate — date
- zipcode — varchar2(7) — NOT NULL
- zipcode (zipcode2) — varchar2(7) — Foreign key → tb_zipcode.zipcode — NOT NULL
orders
- o_seq — number(10) — Primary key — NOT NULL
- product_code — varchar2(20) — NOT NULL
- id — varchar2(20) — NOT NULL
- product_size — varchar2(5)
- quantity — varchar2(5)
- result — char(1)
- indate — date
- id (id2) — varchar2(20) — Foreign key → member.id — NOT NULL
- product_code (product_code2) — varchar2(20) — Foreign key → products.product_code — NOT NULL
products
- product_code — varchar2(20) — Primary key — NOT NULL
- product_name — varchar2(100)
- product_kind — char(1)
- product_price1 — varchar2(10)
- product_price2 — varchar2(10)
- product_content — varchar2(1000)
- product_image — varchar2(50)
- sizeSt — varchar2(5)
- sizeEt — varchar2(5)
- product_quantity — varchar2(5)
- useyn — char(1)
- indate — date
tb_zipcode
- zipcode — varchar2(7) — Primary key — NOT NULL
- bungi — varchar2(30)
- sido — varchar2(30)
- gugun — varchar2(30)
- dong — varchar2(30)