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