LIMITED ERD

Tables (15)

p_auction (경매)

  • id (경매 ID) — UUID — Primary key — NOT NULL
  • user_id (사용자 ID) — BIGINT
  • auction_product_id (경매 상품 ID) — UUID
  • status (경매 상태) — ENUM
  • starting_bid (입찰 시작가) — DECIMAL(10,2)
  • final_bid (최종 입찰가) — DECIMAL(10,2)
  • start_time (경매 시작 시간) — TIMESTAMP
  • end_time (경매 마감 시간) — TIMESTAMP
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT

p_auction_product (경매 상품)

  • id (경매 상품 ID) — UUID — Primary key — NOT NULL
  • product_id (상품 ID) — UUID
  • title (상품명) — VARCHAR(50)
  • description (상품 설명) — TEXT
  • price (가격) — DECIMAL(10,2)
  • quantity (수량) — INT
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT

p_auction_user (경매 입찰자)

  • id (경매 입찰자 ID) — UUID — Primary key — NOT NULL
  • auction_id (경매 ID) — UUID — Foreign key → p_auction.id — NOT NULL
  • user_id (사용자 ID) — BIGINT
  • bid (입찰가) — DECIMAL(10,2)
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT
  • idx_auction_user (auction_id, user_id) (중복 입찰 인덱싱)

p_coupon (쿠폰)

  • id (쿠폰 ID) — UUID — Primary key — NOT NULL
  • name (쿠폰 이름) — VARCHAR(50)
  • discount_rate (할인율) — INT
  • status (쿠폰 상태) — ENUM
  • quantity (쿠폰 개수) — INT
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT

p_limited_event (한정수량 이벤트)

  • id (한정수량 이벤트 ID) — UUID — Primary key — NOT NULL
  • limited_product_id (한정수량 상품 ID) — UUID
  • start_date (이벤트 시작 날짜) — TIMESTAMP
  • end_date (이벤트 종료 날짜) — TIMESTAMP
  • status (선착순 상품 상태) — ENUM
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT

p_limited_event_user (한정수량 구매자)

  • id (한정 수량 구매자 ID) — UUID — Primary key — NOT NULL
  • limited_evnet_id (한정수량 이벤트 ID) — UUID — Foreign key → p_limited_event.id — NOT NULL
  • user_id (사용자 ID) — BIGINT
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT

p_limited_product (한정수량 상품)

  • id (한정수량 상품 ID) — UUID — Primary key — NOT NULL
  • product_id (상품 ID) — UUID
  • title (상품명) — VARCHAR(50)
  • description (상품 설명) — TEXT
  • price (가격) — DECIMAL(10,2)
  • quantity (수량) — INT
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT

p_order (주문)

  • id (주문 ID) — UUID — Primary key — NOT NULL
  • user_id (사용자 ID) — BIGINT
  • username (사용자 이름) — VARCHAR(50)
  • status (주문 상태) — ENUM
  • product_id (상품 ID) — UUID
  • order_type (주문 상품 type) — ENUM
  • quantity (수량) — INT
  • price (가격) — DECIMAL(10,2)
  • address (주소) — VARCHAR(255)
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT

p_order_coupon (주문에 적용된 쿠폰)

  • id (주문 쿠폰 ID) — UUID — Primary key — NOT NULL
  • order_id (주문 ID) — UUID — Foreign key → p_order.id — NOT NULL
  • coupon_id (쿠폰 ID) — UUID
  • coupon_name (쿠폰 이름) — VARCHAR(50)
  • discount_rate (할인율) — INT
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT

p_preuser (체험단 이벤트)

  • id (상품 체험 ID) — UUID — Primary key — NOT NULL
  • preuser_product_id (체험 상품 ID) — UUID
  • count (체험단 인원수) — INT
  • title (체험단 명) — VARCHAR(300)
  • gender_limit (성별 제한) — ENUM
  • age_limite (나이 제한) — INT
  • recruit_start_at (모집 시작일) — TIMESTAMP
  • recurit_end_at (모집 마감일) — TIMESTAMP
  • preuser_start_at (체험단 시작일) — TIMESTAMP
  • preuser_end_at (체험단 종료일) — TIMESTAMP
  • status (체험단 상태) — ENUM
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_by (삭제자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP

p_preuser_product (체험 상품)

  • id (체험 상품 ID) — UUID — Primary key — NOT NULL
  • product_id (상품 ID) — UUID
  • title (상품명) — VARCHAR(50)
  • description (상품 설명) — TEXT
  • price (상품 가격) — DECIMAL(10,2)
  • quantity (수량) — INT
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — TIMESTAMP
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — TIMESTAMP
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — TIMESTAMP

p_preuser_user (체험상품 체험자)

  • id (체험자 ID) — UUID — Primary key — NOT NULL
  • preuser_id (상품 체험 ID) — UUID — Foreign key → p_preuser.id — NOT NULL
  • user_id (사용자 ID) — BIGINT
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT
  • preuser_id (체험단ID) — UUID

p_product (상품)

  • id (상품 ID) — UUID — Primary key — NOT NULL
  • title (상품명) — VARCHAR(50)
  • description (상품 설명) — TEXT
  • price (상품 가격) — DECIMAL(10,2)
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT

p_user (사용자)

  • id (사용자 ID) — BIGINT — Primary key — NOT NULL
  • username (사용자 이름) — VARCHAR(50)
  • password (비밀번호) — VARCHAR(255)
  • role (권한) — ENUM
  • gender (성별) — ENUM
  • age (나이) — BIGINT
  • address (주소) — VARCHAR(255)
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT

p_user_coupon (사용자 쿠폰)

  • id (사용자 쿠폰 ID) — UUID — Primary key — NOT NULL
  • coupon_id (쿠폰 ID) — UUID — Foreign key → p_coupon.id — NOT NULL
  • user_id (사용자 ID) — BIGINT
  • status (쿠폰 사용 상태) — ENUM
  • created_at (생성일자) — TIMESTAMP
  • created_by (생성자) — BIGINT
  • updated_at (수정일자) — TIMESTAMP
  • updated_by (수정자) — BIGINT
  • deleted_at (삭제일자) — TIMESTAMP
  • deleted_by (삭제자) — BIGINT