beompingmall

Tables (9)

Like (찜)

  • product_id (제품 아이디) — Foreign key → Product.id — NOT NULL
  • user_id (유저 아이디) — Foreign key → User.id — NOT NULL

Order_Item (주문제품)

  • id (PK) — Primary key — NOT NULL
  • order_id (주문 아이디) — Foreign key → Orders.id — NOT NULL
  • product_id (제품 아이디) — Foreign key → Product.id — NOT NULL
  • id (Key) — Foreign key → Orders.address_id — NOT NULL
  • id (PK2) — Foreign key → Orders.user_id — NOT NULL
  • id (PK22) — Foreign key → Orders.id — NOT NULL
  • product_name (제품명)
  • quentity (수량)
  • price (가격)

Orders (주문)

  • id (PK) — Primary key — NOT NULL
  • address_id (배송지 아이디) — Foreign key → address.id — NOT NULL
  • user_id (유저 아이디) — Foreign key → User.id — NOT NULL
  • id (PK2) — Foreign key → address.user_id — NOT NULL
  • order_date (주문날짜)
  • main_product_name (대표상품)
  • total_quentity (전체수량)
  • total_price (전체가격)

Password (비밀번호)

  • id (PK) — Foreign key → User.id — NOT NULL
  • password (비밀번호)
  • updated_at (변경일)

Product (제품)

  • id (PK) — Primary key — NOT NULL
  • name (제품명)
  • price (가격)

Stock (재고)

  • id (PK) — Foreign key → Product.id — NOT NULL
  • stock (재고)

User (유저)

  • id (PK) — Primary key — NOT NULL
  • user_id (유저 아이디)
  • name (이름)
  • birthday (생일)
  • contact (연락처)
  • isDeleted (삭제여부)
  • deleted_at (삭제일)

address (주소)

  • id (Key) — Primary key — NOT NULL
  • user_id (유저아이디) — Foreign key → User.id — NOT NULL
  • locate (배송지)

deletedUser (비활성유저)

  • id (PK) — Primary key — NOT NULL
  • userId (유저 아이디)
  • pwd (비밀번호)
  • name (이름)
  • birthday (생일)
  • contact (연락처)