Funxtion

Tables (25)

bids

  • id (입찰ID) — serial — Primary key
  • product_id (상품ID) — bigint — Foreign key → products.id
  • bidder_id (입찰자ID) — bigint — Foreign key → members.id
  • bid_price (입찰가격) — bigint — NOT NULL
  • return_yn (반환여부) — bpchar(1)
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

chat_messages

  • id (채팅메시지ID) — serial — Primary key
  • user_id (유저ID) — bigint — Foreign key → members.id
  • room_id (채팅방ID) — bigint — Foreign key → chat_rooms.id
  • message (채팅메시지) — varchar — NOT NULL
  • read_yn (읽음여부) — bpchar(1)
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

chat_rooms

  • id (채팅방ID) — serial — Primary key
  • store_id (상점ID(판매자)) — bigint — Foreign key → members.id
  • customer_id (고객ID(구매자)) — bigint — Foreign key → members.id
  • product_id (상품ID) — bigint — Foreign key → products.id
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

members

  • id (회원번호) — serial — Primary key
  • role_id (권한ID) — bigint — Foreign key → roles.role_id
  • email (이메일(로그인아이디)) — varchar — NOT NULL
  • password (비밀번호) — varchar — NOT NULL
  • name (회원명) — varchar
  • nickname (닉네임) — varchar
  • profile_image_url (프로필이미지) — varchar
  • phone_number (휴대폰번호) — char(11)
  • intro (소개글) — varchar
  • point (보유포인트) — bigint — NOT NULL
  • social_id (소셜ID) — varchar
  • social_provider (소셜프로바이더) — varchar
  • refresh_token (리프레시 토큰) — varchar
  • delete_yn (탈퇴여부) — bpchar(1) — NOT NULL
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz
  • verified_yn (이메일 인증여부) — bpchar(1) — NOT NULL
  • auth_code (이메일 인증코드) — varchar(30)

notifications

  • id (알림ID) — serial — Primary key
  • receiver_id (수신자ID2) — bigint — Foreign key → members.id
  • product_id (상품ID2) — bigint — Foreign key → products.id
  • message (알림메시지) — varchar — NOT NULL
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

payments

  • id (포인트결제ID) — serial — Primary key
  • imp_uid (결제번호) — varchar — NOT NULL
  • email (이메일) — varchar — NOT NULL
  • status (결제상태) — varchar
  • amount (결제포인트) — bigint — NOT NULL
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

product_category

  • category_id (상품카테고리ID) — varchar — Primary key
  • category_name (상품카테고리명) — varchar — NOT NULL

product_images

  • id (상품이미지ID) — serial — Primary key
  • prodict_id (상품ID) — bigint — Foreign key → products.id
  • original_name (이미지명) — varchar(100) — NOT NULL
  • image_url (이미지 url) — VARCHAR(2048) — NOT NULL
  • size (이미지 크기) — bigint — NOT NULL
  • main_yn (메인이미지 여부) — bpchar(1)
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

product_quality_type

  • quality_id (상품품질ID) — varchar — Primary key
  • quality_name (상품품질명) — varchar — NOT NULL

product_sales_type

  • sales_id (상품판매방식ID) — varchar — Primary key
  • sales_name (상품판매방식명) — varchar — NOT NULL

product_status_type

  • status_id (상품상태ID) — varchar — Primary key
  • status_name (상품상태명) — varchar — NOT NULL

products

  • id (상품ID) — serial — Primary key
  • category_id (상품카테고리ID2) — varchar — Foreign key → product_category.category_id
  • quality_type_id (상품품질ID2) — varchar — Foreign key → product_quality_type.quality_id
  • status_type_id (상품상태ID2) — varchar — Foreign key → product_status_type.status_id
  • sales_type_id (상품판매방식ID2) — varchar — Foreign key → product_sales_type.sales_id
  • store_id (상점ID) — int4 — NOT NULL
  • product_title (상품명) — varchar — NOT NULL
  • product_desc (상품상세정보) — varchar — NOT NULL
  • product_price (상품가격(시작가)) — int4 — NOT NULL
  • location (거래지역) — varchar — NOT NULL
  • auction_winner_id (최상위입찰자ID) — int4
  • current_price (현재가격) — int4 — NOT NULL
  • cool_price (즉시구매가격) — int4
  • end_time (마감일) — timestamp
  • views (조회수) — int4
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

qna_category

  • category_id (1대1문의 카테고리 ID) — varchar — Primary key
  • category_name (1대1문의 카테고리명) — varchar — NOT NULL

qna_log

  • id (1대1문의 ID) — serial — Primary key
  • category_id (1대1문의 카테고리 ID) — varchar — Foreign key → qna_category.category_id
  • user_id (유저ID) — bigint — Foreign key → members.id
  • qna_title (1대1문의 제목) — varchar — NOT NULL
  • qna_content (1대1문의 내용) — varchar — NOT NULL
  • qna_answer (1대1문의 답변) — varchar
  • create_date (생성일) — timestamp

report_type

  • type_code (신고유형코드) — varchar — Primary key
  • type_name (신고유형명) — varchar — NOT NULL

roles (권한)

  • role_id (권한ID) — serial — Primary key
  • role_name (권한명) — varchar — NOT NULL

safe_payments

  • id (안전거래ID) — serial — Primary key
  • product_id (상품ID) — serial — Foreign key → products.id
  • seller_id (판매자ID) — bigint — Foreign key → members.id
  • buyer_id (구매자ID) — bigint — Foreign key → members.id
  • seller_ok (판매완료여부) — bpchar(1)
  • buyer_ok (구매완료여부) — bpchar(1)
  • status (안전거래상태) — varchar — NOT NULL
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

site_banner_images

  • id (배너이미지ID) — serial — Primary key
  • original_name (이미지명) — varchar — NOT NULL
  • image_url (이미지url) — VARCHAR — NOT NULL
  • size (이미지크기) — bigint — NOT NULL
  • order (배너이미지 순서) — bigint — NOT NULL
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

site_faq

  • id (FAQ ID) — serial — Primary key
  • faq_title (FAQ 제목) — varchar — NOT NULL
  • faq_content (FAQ 내용) — varchar — NOT NULL
  • faq_order (FAQ 순서) — bigint
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

site_notice

  • id (공지사항 ID) — serial — Primary key
  • notice_title (공지사항 제목) — varchar — NOT NULL
  • notice_content (공지사항 내용) — varchar — NOT NULL
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

user_favorites

  • id (관심상품ID) — serial — Primary key
  • user_id (유저ID) — bigint — Foreign key → members.id
  • product_id (상품ID) — bigint — Foreign key → products.id
  • create_date (생성일) — timestamp

user_follows

  • id (유저팔로우ID) — serial — Primary key
  • from_id (팔로워ID(팔로잉 하는 사람)) — bigint — Foreign key → members.id
  • to_id (회원번호) — bigint — Foreign key → members.id

user_point_charge_log

  • id (포인트충전ID) — serial — Primary key
  • user_id (회원번호) — bigint — Foreign key → members.id
  • point (포인트) — bigint — NOT NULL
  • cancel_yn (환불여부) — bpchar(1)
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz

user_reports

  • id (신고ID) — serial — Primary key
  • user_id (유저ID2) — bigint — Foreign key → members.id
  • product_id (상품ID2) — bigint — Foreign key → products.id
  • report_type (신고유형코드2) — varchar — Foreign key → report_type.type_code
  • create_date (생성일) — timestamp

user_reviews

  • id (유저리뷰ID) — serial — Primary key
  • buyer_id (구매자ID) — bigint — Foreign key → members.id
  • seller_id (판매자ID) — bigint — Foreign key → members.id
  • product_id (상품ID) — bigint — Foreign key → products.id
  • content (리뷰내용) — varchar — NOT NULL
  • rating (평점) — bigint
  • create_date (생성일) — timestamp
  • update_date (수정일) — timestamptz