우리동네마켓

테이블 (26)

bid

  • id — bigint — 기본 키 — NOT NULL
  • product_id — bigint — 외래 키 → product.id — NOT NULL
  • proposed_price — bigint — NOT NULL
  • delivery_type — enum('DELIVERY','PICKUP') — NOT NULL
  • delivery_fee — bigint — NOT NULL
  • offer_details — text
  • is_selected — tinyint(1) — NOT NULL
  • bid_status — enum('PENDING','WON','LOST','CANCEL') — NOT NULL
  • created_at — datetime — NOT NULL

category

  • id — int — 기본 키 — NOT NULL
  • category_name — varchar(50) — NOT NULL
  • parent_id — int — 외래 키 → category.id

comment

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • content — text — NOT NULL
  • post_type — enum('BID','COMMU') — NOT NULL
  • post_id — bigint — NOT NULL
  • parent_id — bigint — 외래 키 → comment.id
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

commerce_license

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • license_type — tinyint(1) — NOT NULL
  • license_no — bigint — NOT NULL
  • issued_by — varchar(255) — NOT NULL
  • issued_date — datetime
  • status — varchar(100) — NOT NULL

community

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — text — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

contact

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • name — varchar(100)
  • phone — varchar(100)
  • email — varchar(255)
  • is_primary — tinyint(1) — NOT NULL

document

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • doc_type — varchar(50) — NOT NULL
  • file_id — varchar(100)
  • status — enum('WAITING','DONE','CANCEL') — NOT NULL
  • submitted_at — datetime — NOT NULL
  • verified_at — datetime

image

  • id — bigint — 기본 키 — NOT NULL
  • target_id — bigint — NOT NULL
  • target_type — enum('POST','PRODUCT','REVIEW','USER') — NOT NULL
  • image_url — varchar(500) — NOT NULL
  • origin_name — varchar(255)
  • sort_order — int — NOT NULL
  • created_at — datetime — NOT NULL

likes

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • post_id — bigint — 외래 키 → post.id — NOT NULL
  • created_at — datetime — NOT NULL

location

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • zip_code — varchar(255) — NOT NULL
  • base_address — varchar(255) — NOT NULL
  • detail_address — varchar(255)
  • legal_dong_code — varchar(255) — NOT NULL
  • building_name — varchar(255)
  • address_type — enum('JIBUN','ROAD')
  • is_default — tinyint(1) — NOT NULL
  • auth_date — bigint
  • dong — varchar(255)
  • expired — bit(1) — NOT NULL
  • lat — double
  • lon — double
  • road_name — varchar(255)
  • selected — bit(1) — NOT NULL
  • verified — bit(1) — NOT NULL
  • sido — varchar(255)
  • sigungu — varchar(255)

participation

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • post_id — bigint — 외래 키 → post.id — NOT NULL
  • part_owner — tinyint(1) — NOT NULL
  • part_status — varchar(255)
  • quantity — int — NOT NULL
  • joined_at — datetime — NOT NULL

payment_cancels

  • id — bigint — 기본 키 — NOT NULL
  • purchase_id — bigint — 외래 키 → purchase.id — NOT NULL
  • refund_no — bigint — NOT NULL
  • refund_amount — bigint
  • reason — varchar(255)
  • status — enum('REQUESTED','DONE','FAILED') — NOT NULL
  • requested_at — datetime — NOT NULL
  • refunded_at — datetime

payment_events

  • id — bigint — 기본 키 — NOT NULL
  • purchase_id — bigint — 외래 키 → purchase.id — NOT NULL
  • tx_type — enum('AUTH','CAPTURE','CANCEL','REFUND') — NOT NULL
  • tx_status — enum('SUCCESS','FAILED') — NOT NULL
  • tx_amount — bigint
  • pg_tx_id — bigint — NOT NULL
  • requested_at — datetime — NOT NULL
  • processed_at — datetime — NOT NULL
  • raw_response — text
  • message — varchar(255)

post

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • product_id — bigint — 외래 키 → product.id
  • title — varchar(255) — NOT NULL
  • content — varchar(255)
  • target_count — bigint
  • current_count — bigint
  • view_count — int — NOT NULL
  • deadline — datetime — NOT NULL
  • status — varchar(255)
  • admin_comment — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • category_code — varchar(255)
  • tags — varchar(255)
  • price_per_person — bigint
  • location — varchar(255)

post_bid_list

  • id — bigint — 기본 키 — NOT NULL
  • post_id — bigint — 외래 키 → post.id — NOT NULL
  • bid_id — bigint — 외래 키 → bid.id — NOT NULL

post_image

  • id — bigint — 기본 키 — NOT NULL
  • url — varchar(255)
  • post_id — bigint — 외래 키 → post.id

product

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • name — varchar(100) — NOT NULL
  • description — varchar(255)
  • sale_price — bigint — NOT NULL

purchase

  • id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — NOT NULL
  • payment_no — int — NOT NULL
  • pg_provider — enum('KCP') — NOT NULL
  • method — enum('CARD','TRANSFER','MOBILE') — NOT NULL
  • status — enum('READY','AUTHORIZED','PAID','FAILED','CANCELED','REFUNDED')
  • requested_amount — bigint
  • approved_amount — bigint
  • paid_at — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

region

  • id — bigint — 기본 키 — NOT NULL
  • dong — varchar(255) — NOT NULL
  • sido — varchar(255) — NOT NULL
  • sigungu — varchar(255) — NOT NULL

return_policy

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • return_address — varchar(255)
  • policy_text — text — NOT NULL

review

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • post_id — bigint — 외래 키 → post.id — NOT NULL
  • content — varchar(500)
  • rating — int
  • created_at — datetime — NOT NULL

review_image

  • id — bigint — 기본 키 — NOT NULL
  • url — varchar(255)
  • review_id — bigint — 외래 키 → review.id

seller_business

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • biz_reg_no — bigint — NOT NULL
  • biz_name — varchar(255) — NOT NULL
  • ceo_name — varchar(255)
  • open_date — datetime
  • address — varchar(255)

settlement_account

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → user.id — NOT NULL
  • bank_name — varchar(100)
  • account_number — bigint — NOT NULL
  • account_holder — varchar(100)
  • is_primary — tinyint(1) — NOT NULL

user

  • id — bigint — 기본 키 — NOT NULL
  • user_type_id — bigint — 외래 키 → user_type.id — NOT NULL
  • login_id — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — varchar(100) — NOT NULL
  • birth — varchar(100) — NOT NULL
  • phone — varchar(100) — NOT NULL
  • gender — enum('M','N','W')
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • provider — varchar(255)
  • provider_id — varchar(255)
  • nickname — varchar(50)

user_type

  • id — bigint — 기본 키 — NOT NULL
  • type — varchar(255) — NOT NULL
  • description — varchar(255)
  • created_at — datetime — NOT NULL