우리동네마켓
테이블 (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