Team7890
Tables (19)
activity_areas
- user_id — bigint — Foreign key → users.id — NOT NULL
- reference_area_id — int4 — Foreign key → emd_areas.id — NOT NULL
- distance_meters — int2 — NOT NULL
- emd_area_ids — int4 — NOT NULL — GIN IDX
- authenticated_at — timestamp
block_users
- user_id — bigint — Foreign key → users.id — NOT NULL
- target_id — bigint — Foreign key → users.id — NOT NULL
- created_at — timestamp — NOT NULL
categories
- id — int4 — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
chat_messages
- id — bigint — Primary key — NOT NULL
- chat_room_id — bigint — NOT NULL
- sender_id — bigint
- message — varchar(500) — NOT NULL
- read_or_not — bool — NOT NULL
- created_at — timestamp — NOT NULL
chat_room
- id — bigint — Primary key — NOT NULL
- goods_id — bigint — NOT NULL
- buyer_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
emd_areas
- id — int4 — Primary key — NOT NULL
- sigg_area_id — int4 — NOT NULL
- adm_code — varchar(10) — NOT NULL — BTREE IDX
- name — varchar(50) — NOT NULL — GIN IDX
- geom — geometry(MultiPolygon, 4326) — NOT NULL
- location — geometry(Point, 4326) — NOT NULL
- version — timestamp — NOT NULL
evaluation_items
- id — int4 — Primary key — NOT NULL
- score — numeric(3, 1) — NOT NULL
- text — varchar(20) — NOT NULL
files
- id — bigint — Primary key — NOT NULL
- uploader_id — bigint — NOT NULL
- type — varchar(50) — NOT NULL
- name — varchar(255) — NOT NULL
- created_at — timestamp — NOT NULL
follow_users
- user_id — bigint — Foreign key → users.id — NOT NULL
- target_id — bigint — Foreign key → users.id — NOT NULL
- created_at — timestamp — NOT NULL
goods
- id — bigint — Primary key — NOT NULL
- seller_id — bigint — NOT NULL — BTREE IDX
- selling_area_id — int4 — NOT NULL — GIN IDX
- category_id — int4 — NOT NULL — GIN IDX
- title — varchar(100) — NOT NULL — GIN IDX (TRIGRAM)
- status — enum — NOT NULL
- sell_price — int4
- view_count — int4 — NOT NULL
- description — text — NOT NULL
- refreshed_at — timestamp — NOT NULL — GIN IDX
- created_at — timestamp — NOT NULL
goods_images
- goods_id — bigint — Foreign key → goods.id — NOT NULL
- file_id — bigint — Foreign key → files.id — NOT NULL
notification_keywords
- id — bigint — Primary key — NOT NULL
- register_id — bigint — NOT NULL
- keyword — varchar(10) — NOT NULL
- created_at — timestamp — NOT NULL
notifications
- id — bigint — Primary key — NOT NULL
- receiver_id — bigint — NOT NULL
- message — varchar(255) — NOT NULL
- read_or_not — bool — NOT NULL
- type — enum — NOT NULL
- reference_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL
price_offers
- id — bigint — Primary key — NOT NULL
- offerer_id — bigint — NOT NULL
- goods_id — bigint — NOT NULL
- offered_price — int4 — NOT NULL
- accept_or_not — bool
- created_at — timestamp — NOT NULL
sido_areas
- id — int4 — Primary key — NOT NULL
- adm_code — varchar(2) — NOT NULL — BTREE IDX
- name — varchar(50) — NOT NULL — GIN IDX
- version — varchar(20) — NOT NULL
sigg_areas
- id — int4 — Primary key — NOT NULL
- sido_area_id — int4 — NOT NULL
- adm_code — varchar(5) — NOT NULL — BTREE IDX
- name — varchar(50) — NOT NULL
- version — timestamp — NOT NULL
transaction_reviews
- id — bigint — Primary key — NOT NULL
- author_id — bigint — NOT NULL
- goods_id — bigint — NOT NULL
- message — varchar(255) — NOT NULL
- evaluation_items — int4 — NOT NULL
- created_at — timestamp — NOT NULL
users
- id — bigint — Primary key — NOT NULL
- role — enum — NOT NULL — GIN IDX
- mobile_number — varchar(11) — NOT NULL — UNQUE
- activated — bool — NOT NULL
- rating_score — numeric(3, 1) — NOT NULL
- created_at — timestamp — NOT NULL
wish_lists
- id — bigint — Primary key — NOT NULL
- register_id — bigint — NOT NULL
- goods_id — bigint — NOT NULL
- created_at — timestamp — NOT NULL