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