shop
Tables (7)
cart (Untitled2)
- id — BIGINT — Primary key — NOT NULL
- 수량 (number) — INT
- 색상 (color) — VARCHAR
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- goods_id — BIGINT — Foreign key → goods.id — NOT NULL
category1 (Untitled5)
- id — BIGINT — Primary key — NOT NULL
- category1_name (categpry_name) — VARCHAR
- created_at — TIMESTAMP
- updated_at
category2 (Untitled6)
- id — BIGINT — Primary key — NOT NULL
- category2_name — VARCHAR
- created_at — TIMESTAMP
- updated_at
- category1_id — BIGINT — Foreign key → category1.id — NOT NULL
comment (Untitled7)
- id — BIGINT — Primary key — NOT NULL
- reply_content — TEXT
- reply_photo — TEXT
- reply_writer — VARCHAR
- star — INT
- created_at (create_at) — TIMESTAMP
- updated_at — TIMESTAMP
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- goods_id — BIGINT — Foreign key → goods.id — NOT NULL
goods (Untitled4)
- id — BIGINT — Primary key — NOT NULL
- goods_title — VARCHAR
- goods_description — TEXT
- goods_price — INT
- size — VARCHAR
- 썸네일 (mainphoto) — MIDEUMTEXT
- 제품사진 (contentphoto) — MIDEUMTEXT
- goods_color — MIDEUMTEXT
- created_at (create_at) — TIMESTAMP
- updated_at
- 상위카테고리아이디 (category1_id) — BIGINT — Foreign key → category1.id — NOT NULL
- 하위카테고리아이디 (category2_id) — BIGINT — Foreign key → category2.id — NOT NULL
order (Untitled3)
- id — BIGINT — Primary key — NOT NULL
- 실수령자이름 (buyer_name) — VARCHAR
- 실수령자번호 (buyer_tel) — INT
- 실수령자주소 (buyer_addr) — VARCHAR
- 실수령자이메일 (buyer_email) — VARCHAR
- 결제금액 (amount) — VARCHAR
- 주문목록(json) (orderlist) — TEXT
- 배송상태 (orderstate) — VARCHAR
- 주문번호 (uid) — VARCHAR
- created_at — TIMESTAMP
- updated_at
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- goods_id — BIGINT — Foreign key → goods.id — NOT NULL
user (Untitled)
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR
- userid — VARCHAR
- password — VARCHAR
- email — VARCHAR
- birthday — INT
- birthdaymaddle — INT
- birthdaylast — INT
- sex — VARCHAR
- tel — INT
- addr — VARCHAR
- detailaddr — TEXT
- level — INT
- social — INT
- post — INT
- created_at — TIMESTAMP
- updated_at