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