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)