shop2
Tables (5)
Sample
- id — date — Primary key — NOT NULL
- name — varchar2(30)
- Field2
- 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) — Foreign key → tb_zip_code.zipcode — NOT NULL
orders
- o_seq — number(10) — Primary key — NOT NULL
- id — varchar2(16)
- product_size — varchar2(5)
- quantity — varchar2(5)
- result — char(1)
- indate — date
- product_code2 — varchar2(20) — Foreign key → product.product_code — NOT NULL
- id2 — varchar2(20) — Foreign key → member.id — NOT NULL
product
- 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
- Field
tb_zip_code
- zipcode — varchar2(7) — Primary key — NOT NULL
- sido — varchar2(30)
- gugun — varchar2(30)
- bungi — varcahr2(30)
- dong — varchar2(30)