temp

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 — Foreign key → chat_room.id — NOT NULL
  • sender_id — bigint — Foreign key → users.id
  • 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 — Foreign key → goods.id — NOT NULL
  • buyer_id — bigint — Foreign key → users.id — NOT NULL
  • created_at — timestamp — NOT NULL

emd_areas

  • id — int4 — Primary key — NOT NULL
  • sigg_area_id — int4 — Foreign key → sigg_areas.id — 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 — Foreign key → users.id — 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 — Foreign key → users.id — NOT NULL — BTREE IDX
  • selling_area_id — int4 — Foreign key → emd_areas.adm_code — NOT NULL — GIN IDX
  • category_id — int4 — Foreign key → categories.id — 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 — Foreign key → users.id — NOT NULL
  • keyword — varchar(10) — NOT NULL
  • created_at — timestamp — NOT NULL

notifications

  • id — bigint — Primary key — NOT NULL
  • receiver_id — bigint — Foreign key → users.id — 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 — Foreign key → users.id — NOT NULL
  • goods_id — bigint — Foreign key → goods.id — 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 — Foreign key → sido_areas.id — 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 — Foreign key → users.id — NOT NULL
  • goods_id — bigint — Foreign key → goods.id — 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 — Foreign key → users.id — NOT NULL
  • goods_id — bigint — Foreign key → goods.id — NOT NULL
  • created_at — timestamp — NOT NULL