per3
Tables (9)
Untitled (order_detail)
- Field (order_detail_order_idx) — INT — NOT NULL
- Field (order_detail_product_idx) — INT — NOT NULL
- Field (order_detail_product_quantity) — INT — NOT NULL
Untitled (basket)
- Field (basket_email) — VARCHAR(50) — NOT NULL
- Field (basket_product_idx) — INT — NOT NULL
- Field (basket_quantity) — INT — NOT NULL
Untitled (product)
- Key (product_idx) — INT — Primary key — NOT NULL
- Field (product_name) — VARCHAR(500) — NOT NULL
- Field (product_category) — VARCHAR(500) — NOT NULL
- Field (product_detail) — VARCHAR(500) — NOT NULL
- Field (product_main_image) — VARCHAR(500) — NOT NULL
- Field (product_detail_image) — VARCHAR(500) — NOT NULL
- Field (product_price) — INT — NOT NULL
- Field (product_size) — INT — NOT NULL
- Field (product_stock) — INT — NOT NULL
- Field (product_sellingcount) — INT — NOT NULL
- Field (product_status) — TINYINT — NOT NULL
Untitled (review)
- Key (review_idx) — INT — Primary key — NOT NULL
- Field (review_email) — VARCHAR(50) — NOT NULL
- Field (review_product_idx) — INT — NOT NULL
- Field (review_subject) — VARCHAR(500) — NOT NULL
- Field (review_content) — VARCHAR(500) — NOT NULL
- Field (review_image) — VARCHAR(500) — NOT NULL
- Field (review_score) — INT — NOT NULL
- Field (review_date) — DATE — NOT NULL
- Field (review_order_idx) — INT — NOT NULL
Untitled (member)
- Key (member_email) — VARCHAR(50) — Primary key — NOT NULL
- Field (member_idx) — INT — NOT NULL
- Field (member_password) — VARCHAR(50) — NOT NULL
- Field (member_name) — VARCHAR(50) — NOT NULL
- Field (member_mobile) — VARCHAR(50) — NOT NULL
- Field (member_tel) — VARCHAR(50) — NOT NULL
- Field (member_postnum) — INT — NOT NULL
- Field (member_address) — VARCHAR(500) — NOT NULL
- Field (member_date) — DATE — NOT NULL
- Field (member_status) — TINYINT — NOT NULL
Untitled (wishlist)
- Field (wishlist_member_email) — VARCHAR(50) — NOT NULL
- Field (wishlist_procut_idx) — INT — NOT NULL
Untitled (admin)
- Key (admin_id) — VARCHAR(50) — Primary key — NOT NULL
- Field (admin_password) — VARCHAR(50) — NOT NULL
- Field (admin_name) — VARCHAR(50) — NOT NULL
- Field (admin_memo) — VARCHAR(500) — NOT NULL
Untitled (notice)
- Key (notice_idx) — INT — Primary key — NOT NULL
- Field (notice_name) — VARCHAR(500) — NOT NULL
- Field (notice_subject) — VARCHAR(500) — NOT NULL
- Field (notice_content) — VARCHAR(500) — NOT NULL
- Field (notice_file_original) — VARCHAR(500) — NOT NULL
- Field (notice_file_real) — VARCHAR(500) — NOT NULL
- Field (notice_readcount) — INT — NOT NULL
- Field (notice_date) — DATE — NOT NULL
orderlist
- Key (order_idx) — INT — Primary key — NOT NULL
- Field (order_member_email) — VARCHAR(50) — NOT NULL
- Field (order_receiver_name) — VARCHAR(50) — NOT NULL
- Field (order_receiver_mobile) — VARCHAR(50) — NOT NULL
- Field (order_receiver_postnum) — INT — NOT NULL
- Field (order_receiver_address) — VARCHAR(100) — NOT NULL
- Field (order_amount) — INT — NOT NULL
- Field (order_date) — DATE — NOT NULL