musinsap

Tables (7)

admin_user (어드민 유저)

  • admin_user_id (어드민 유저 UUID) — UUID — Primary key — NOT NULL
  • product_id (제품 UUID) — UUID — Foreign key → product.product_id — NOT NULL
  • email (어드민 유저 메일) — text
  • user_password (어드민 유저 비밀번호) — text
  • shopping_mall (어드민 유저 쇼핑몰) — text

customer_user (일반 유저)

  • customer_user_id (일반 유저 UUID) — UUID — Primary key — NOT NULL
  • name (일반 유저 이름) — text
  • email (일반 유저 메일) — text
  • password (일반 유저 비밀번호) — text
  • level (일반 유저 레벨) — integer

order_history (주문 내역)

  • order_history_id (주문 내역 UUID) — UUID — Primary key — NOT NULL
  • product_id (제품 UUID) — UUID — Foreign key → product.product_id — NOT NULL
  • customer_user_id (유저 UUID) — UUID — Foreign key → customer_user.customer_user_id — NOT NULL
  • count (주문 제품 개수) — integer

orders (장바구니)

  • orders (장바구니 UUID) — UUID — Primary key — NOT NULL
  • product_id (제품 UUID) — UUID — Foreign key → product.product_id — NOT NULL
  • customer_user_id (일반 유저 UUID) — UUID — Foreign key → customer_user.customer_user_id — NOT NULL
  • count (주문 개수) — integer

product (제품)

  • product_id (제품 UUID) — UUID — Primary key — NOT NULL
  • brand (제품 브랜드) — text
  • name (제품 이름) — text
  • price (제품 가격) — integer
  • discount_rate (제품 할인률) — integer
  • category (제품 범주) — text
  • special_exhibition (제품 기획전) — boolean
  • wishlist_count (제품 찜목록 등록 개수) — integer
  • order_count (제품 주문 개수) — integer

special_exhibition (기획전)

  • specal_sxhibition_id (기획전 UUID) — UUID — Primary key — NOT NULL
  • product_id (제품 UUID) — UUID — Foreign key → product.product_id — NOT NULL

wishlist (찜목록)

  • wishlist_id (찜목록 UUID) — UUID — Primary key — NOT NULL
  • product_id (제품 UUID) — UUID — Foreign key → product.product_id — NOT NULL
  • customer_user_id (유저 UUID) — UUID — Foreign key → customer_user.customer_user_id — NOT NULL