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