TakeIt

Tables (13)

p_category

  • id — BIGINT — Primary key — NOT NULL
  • uuid — UUID
  • name (카테고리명) — VARCHAR(50)
  • is_deleted (삭제여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)

p_coupon

  • id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → p_category.id — NOT NULL
  • uuid — UUID
  • name (쿠폰명) — VARCHAR(255)
  • type (쿠폰 타입) — ENUM
  • discount_value — INTEGER
  • min_amount (쿠폰 사용 최소 금액) — INTEGER
  • start_date (사용 가능 시작일) — TIMESTAMP
  • end_date (사용 가능 종료일) — TIMESTAMP
  • expiration_date (쿠폰 유지 기간) — INTEGER
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)

p_favorite

  • id — id — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → p_user.id — NOT NULL
  • product_id — BIGINT — Foreign key → p_product.id — NOT NULL
  • uuid — UUID
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)

p_order

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → p_user.id — NOT NULL
  • product_id — BIGINT — Foreign key → p_product.id — NOT NULL
  • user_coupon_id — BIGINT — Foreign key → p_user_coupon.id — NOT NULL
  • uuid — UUID
  • quantity (수량) — BIGINT
  • amount (주문 금액) — BIGINT
  • status (주문 상태) — ENUM
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)

p_payment

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → p_user.id — NOT NULL
  • order_id — BIGINT — Foreign key → p_order.id — NOT NULL
  • uuid — UUID
  • status (결제 상태) — ENUM
  • amount (결제 금액) — INTEGER
  • receipt (영수증) — VARCHAR(500)
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)

p_product

  • id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → p_category.id — NOT NULL
  • seller_id — BIGINT — Foreign key → p_seller_info.id — NOT NULL
  • uuid — UUID
  • product_name (상품명) — VARCHAR(255)
  • description (설명) — VARCHAR(255)
  • price (가격) — BIGINT
  • stock (수량) — INTEGER
  • limit_per_user (1인당 구매 제한 수량) — INTEGER
  • open_time (상품 판매 시작 시간) — TIMESTAMP
  • close_time (상품 판매 종료 시간) — TIMESTAMP
  • is_active (상품 전시 여부) — BOOLEAN
  • stars (평점) — DOUBLE
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)

p_product_daily_stat

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → p_product.id — NOT NULL
  • base_date (기준일) — TIMESTAMP
  • sold_stock (판매 수량) — BIGINT
  • stock (남은 수량) — BIGINT
  • people — BIGINT
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)

p_product_photo

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → p_product.id — NOT NULL
  • uuid — UUID
  • file_name (사진명) — VARCHAR(255)
  • uri — VARCHAR(255)
  • is_s3_deleted (s3 삭제 여부) — BOOLEAN
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)

p_review

  • id — BIGINT — Primary key — NOT NULL
  • order_id — BIGINT — Foreign key → p_order.id — NOT NULL
  • uuid — UUID
  • stars (평점) — INTEGER
  • comment (리뷰) — VARCHAR(255)
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)

p_review_photo

  • id — BIGINT — Primary key — NOT NULL
  • uuid — UUID
  • file_name (파일명) — VARCHAR(255)
  • uri — VARCHAR(255)
  • is_s3_deleted (s3 삭제여부) — BOOLEAN
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)
  • review_id — BIGINT — Foreign key → p_review.id — NOT NULL

p_seller_info

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → p_user.id — NOT NULL
  • business_number (사업자 번호) — VARCHAR(10)
  • business_name (사업자명) — VARCHAR(100)
  • phone_number (핸드폰 번호) — VARCHAR(20)
  • address (주소) — VARCHAR(255)
  • status (공개 상태) — ENUM
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)

p_user

  • id — BIGINT — Primary key — NOT NULL
  • username — VARCHAR(10)
  • nickname (닉네임) — VARCHAR(100)
  • email — VARCHAR(255)
  • password (비밀번호) — VARCHAR(255)
  • role — ENUM
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)

p_user_coupon

  • id — BIGINT — Primary key — NOT NULL
  • coupon_id — BIGINT — Foreign key → p_coupon.id — NOT NULL
  • uuid — UUID
  • start_date (사용 가능 시작일) — TIMESTAMP
  • end_date (사용 가능 종료일) — TIMESTAMP
  • is_used (사용 여부) — BOOLEAN
  • is_deleted (삭제 여부) — BOOLEAN
  • created_at (생성일) — TIMESTAMP
  • created_by (생성자) — VARCHAR(10)
  • updated_at (수정일) — TIMESTAMP
  • updated_by (수정자) — VARCHAR(10)
  • deleted_at (삭제일) — TIMESTAMP
  • deleted_by (삭제자) — VARCHAR(10)