ECMall
테이블 (6)
ecmall (product)
- Product Number (p_num) — int(auto_increment) — 기본 키 — NOT NULL
- Product Name (p_name) — varchar(50)
- Product Describe (p_memo) — text
- Product Price (p_price) — int
- Product Category (p_category) — varchar(50)
- Product Stock (p_stock) — int
ecmall (userinfo)
- User Number (user_num) — int(auto_increment) — 기본 키 — NOT NULL
- User ID (user_id) — varchar(20)
- User Password (user_pw) — varchar(20)
- User Name (user_name) — varchar(50)
- User Mobile (user_mobile) — varchar(50)
- User Post Number (user_postnum) — int(10)
- User History (user_history) — int(100)
ecmall (cart)
- Key — 기본 키 — NOT NULL
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
ecmall (product_page)
- Page Number (page_num) — int(auto_increment) — 기본 키 — NOT NULL
- Product Name (p_name) — varchar(50)
- Product Price (p_price) — int(1000)
- Field2
- Field3
- Field4
- Field5
- Field6
- Field7
- Field
상품 업데이트시 사용 (product_table)
- Key — 기본 키 — NOT NULL
- product Number (p_num) — int(11), not null auto_increment
- product Name (p_name) — varchar(50), not null default
- product describe (p_des) — varchar(200), not nul l default
- product memo (p_memo) — text, not null
- product price (p_price) — int(11), not null default 0
- product image (p_image) — varchar(255), not null
주문자 정보를 담을 테이블 (userinformation)
- no (Key) — 기본 키 — NOT NULL
- USER NUMBER (user_number) — int(11), auto_increment, not null
- USER ORDER (order_id) — varchar(20), not null default
- USER NAME (user_name) — varchar(20) not null default
- USER ADDRESS (user_address) — varchar(50) not null default
- USER MOBILE (user_mobile) — varchar(18), not null default
- USER REGDATE (user_regdate) — int(11), not null default '0'
- Field7
- Field8
- Field9
- Field10