ShoppingMall

테이블 (7)

Copy Of Untitled (category)

  • Key (cat_num) — int — 기본 키 — NOT NULL
  • Field (cat_main) — varchar(10)
  • Field (cat_sub) — varchar(10)

Copy Of 회원정보 (Address)

  • Key (add_num) — int — 기본 키 — NOT NULL
  • Field (user_address) — varchar(70)
  • Field (user_postcode) — varchar(10)
  • Field (user_address_detail) — varchar(50)
  • Field (add_nickname) — varchar(30)

Untitled (Order)

  • Key (order_num) — int — 기본 키 — NOT NULL
  • Field (order_datetime) — datetime
  • Key (order_user_id) — varchar(50) — 외래 키 → Untitled.Key — NOT NULL
  • Field (order_amount) — int
  • Field (order_totalPrice) — int
  • user_id (order_opt_num) — int — 외래 키 → 회원정보.user_id — NOT NULL

Untitled (product)

  • Key (pro_num) — varcahr(10) — 기본 키 — NOT NULL
  • Field (pro_name) — varcahr(50)
  • Field (pro_price) — int
  • Field (pro_detail) — longtext
  • Key (cat_num) — int — 외래 키 → Copy Of Untitled.Key — NOT NULL

Untitled (option)

  • Key (opt_num) — int — 기본 키 — NOT NULL
  • Field (opt_colour) — varchar(10)
  • Field (opt_size) — varchar(10)
  • Field (opt_stock) — int
  • Key (opt_pro_num) — varcahr(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (review)

  • Key (review_num) — int — 기본 키 — NOT NULL
  • Field (review_content) — longtext
  • Field (review_title) — varchar(100)
  • Field (review_date) — datetime
  • user_id (review_ user_id) — varchar(20) — 외래 키 → 회원정보.user_id — NOT NULL
  • Key (review_pro_num) — varcahr(10) — 외래 키 → Untitled.Key — NOT NULL

회원정보 (user)

  • user_id — varchar(20) — 기본 키 — NOT NULL
  • Field (user_pw) — varchar(255)
  • Field (user_name) — varchar(15)
  • Field (user_reg_num) — char(14)
  • Field (user_phone) — char(13)
  • Field (user_gender) — varchar(10)
  • Key (user_add_num) — int — 외래 키 → Copy Of 회원정보.Key — NOT NULL