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