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