핸드폰 판매 쇼핑몰
테이블 (9)
Favorite (Untitled8)
- favorite_id (seq) — INT(AI)
- product_id (Field2) — INT(AI) — 외래 키 → product.product_id
- member_id (seq2) — INT(AI) — 외래 키 → Member.member_id
Member (member)
- member_id (seq) — INT(AI) — 기본 키
- member_email (email) — VARCHAR(30)
- member_password (password) — VARCHAR(100)
- member_nickname (name) — VARCHAR(12)
- member_point (point) — INT
- member_address (address) — VARCHAR(300)
- member_detailAddress (detailAddress) — VARCHAR(20)
- member_status (status) — CAHR(1)
design (Untitled4)
- design_id (design) — INT(AI) — 기본 키
- design_name (Field2) — VARCHAR(30)
- product_id (Field3) — INT — 외래 키 → product.product_id
model (Untitled5)
- model_id (model) — INT(AI) — 기본 키
- model_name (Field2) — VARCHAR(30)
- product_id (Field) — INT(AI) — 외래 키 → product.product_id
order (Untitled6)
- order_id (Field) — BIGINT(AI) — 기본 키
- product_design (Field2) — VARCHAR(30)
- product_model (Field3) — VARCHAR(30)
- order_count (Field4) — INT
- member_id (seq) — INT(AI) — 외래 키 → Member.member_id
- product_id (Field5) — INT(AI) — 외래 키 → product.product_id
photo (Untitled7)
- photo_id (photo) — INT(AI) — 기본 키
- photo_name (Field) — VARCHAR(1000)
- product_id (Field2) — INT(AI) — 외래 키 → product.product_id
product (Untitled3)
- product_id (Field) — INT(AI) — 기본 키
- product_name (Field2) — VARCHAR(30)
- product_price (Field3) — INT
- product_Discount (Field4) — INT
- product_deliveryPrice (Field5) — INT
- member_id (seq) — INT(AI) — 외래 키 → Member.member_id
refreshToken (Untitled)
- Field — 기본 키
- refreshToken_id (seq) — INT(AI)
- refreshToken — VARCHAR(200)
- member_id (seq2) — INT — 외래 키 → Member.member_id
review (Untitled2)
- review_id (Field) — INT(AI) — 기본 키
- review_name (Field6) — VARCHAR(50)
- review_content (Field3) — VARCHAR(1000)
- review_date (fff) — Date
- review_photo (Field5) — VARCHAR(1000)
- product_id (Field2) — INT(AI) — 외래 키 → product.product_id
- member_id (seq) — INT(AI) — 외래 키 → Member.member_id