쇼핑몰

테이블 (9)

Untitled (product)

  • Key (product_id) — number(20) — 기본 키 — NOT NULL
  • Field (product_name) — varchar(255) — NOT NULL
  • Field (product_image) — varchar(255) — NOT NULL
  • Field (price) — INT — NOT NULL
  • Field (product_details) — varchar(255) — NOT NULL
  • Field (product_regdate) — date — NOT NULL
  • Field (product_updateDate) — date
  • Field (product_count) — INT — NOT NULL
  • Key (category_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (order)

  • Key (order_id) — number(20) — 기본 키 — NOT NULL
  • Field (totalPrice) — INT — NOT NULL
  • Field (orderDate) — date — NOT NULL
  • Field (order_updateDate) — date
  • Field (payment_method) — varchar(100) — NOT NULL
  • Field (deliveryPrice) — INT — NOT NULL
  • Key (user_id) — number(20) — 외래 키 → user.Key — NOT NULL
  • Field (orderPoint) — INT — NOT NULL

Untitled (basket)

  • Key (basket_id) — number(20) — 기본 키 — NOT NULL
  • Field (basket_regDate) — date — NOT NULL
  • Field (basket_updateDate) — date
  • Key (user_id) — number(20) — 외래 키 → user.Key — NOT NULL
  • Key (product_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (delivery)

  • Key (delivery_id) — number(20) — 기본 키 — NOT NULL
  • Field (delivery_status) — varchar(255) — NOT NULL
  • Field (delivery_startDate) — date
  • Field (delivery_arrivalDate) — date
  • Key (list_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (order_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (category)

  • Key (category_id) — number(20) — 기본 키 — NOT NULL
  • Field (category_name) — varchar(255) — NOT NULL

Untitled (order_list)

  • Key (list_id) — number(20) — 기본 키 — NOT NULL
  • Field (quantity) — INT — NOT NULL
  • Key (order_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (product_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL

Untitled (Point)

  • Key (user_id) — number(20) — 외래 키 → user.Key — NOT NULL
  • Field (totalPoint) — INT — NOT NULL
  • Field (updateDate) — date

Untitled (reply)

  • Key (reply_id) — number(20) — 기본 키 — NOT NULL
  • Field (register_date) — date
  • Field (update_date) — date
  • Field (content) — varchar(500) — NOT NULL
  • Key (product_id) — number(20) — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — number(20) — 외래 키 → user.Key — NOT NULL

user

  • Key (user_id) — number(20) — 기본 키 — NOT NULL
  • Field (avater_id) — varchar(255) — NOT NULL
  • Field (password) — varchar(255) — NOT NULL
  • Field (confirmPassword) — varchar(255) — NOT NULL
  • Field (address) — varchar(255) — NOT NULL
  • Field (name) — varchar(100) — NOT NULL
  • Field (email) — varchar(255) — NOT NULL
  • Field (phone) — varchar(255) — NOT NULL
  • Field (registerDate) — date — NOT NULL
  • Field (updateDate) — date
  • Field (role) — varchar(100) — NOT NULL