차세대

테이블 (13)

activity_areas

  • user_id — bigint — 외래 키 → users.id — NOT NULL
  • reference_area_id — int4 — 외래 키 → emd_areas.id — NOT NULL
  • distance_meters — int2 — NOT NULL
  • emd_area_ids — int4 — NOT NULL — GIN IDX
  • authenticated_at — timestamp

categories

  • id — int4 — 기본 키 — NOT NULL
  • name — varchar(20) — NOT NULL

chat_messages

  • id — bigint — 기본 키 — 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

emd_areas

  • id — int4 — 기본 키 — 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

files

  • id — bigint — 기본 키 — NOT NULL
  • uploader_id — bigint — NOT NULL
  • type — varchar(50) — NOT NULL
  • name — varchar(255) — NOT NULL
  • created_at — timestamp — NOT NULL

goods

  • id — bigint — 기본 키 — 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 — 외래 키 → goods.id — NOT NULL
  • file_id — bigint — 외래 키 → files.id — NOT NULL

notification_keywords

  • id — bigint — 기본 키 — NOT NULL
  • register_id — bigint — NOT NULL
  • keyword — varchar(10) — NOT NULL
  • created_at — timestamp — NOT NULL

price_offers

  • id — bigint — 기본 키 — 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 — 기본 키 — 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 — 기본 키 — 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 — 기본 키 — 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 — 기본 키 — 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