Dolpin ERD By 떡잎마을 방범대 (v1.0.0)

테이블 (12)

comment

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • moment_id — BIGINT — 외래 키 → moment.id — NOT NULL
  • content — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

keyword

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • keyword — VARCHAR(255) — NOT NULL

moment

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • place_id — BIGINT — 외래 키 → place.id — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • content — TEXT — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • is_public — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

moment_image

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • moment_id — BIGINT — 외래 키 → moment.id — NOT NULL
  • image_url — VARCHAR(255)
  • image_sequence — INTEGER — NOT NULL

place

  • id — BIGINT — 기본 키 — NOT NULL — 크롤링 데이터 ID 값 사용
  • place_category_id — BIGINT — 외래 키 → place_category.id — NOT NULL
  • location — GEOMETRY(Point, 4326) — NOT NULL
  • description — VARCHAR(100) — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20)
  • lot_address — VARCHAR(255) — NOT NULL
  • road_address — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

place_bookmark

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • place_id — BIGINT — 외래 키 → place.id — NOT NULL — 크롤링 데이터 ID 값 사용
  • created_at — TIMESTAMPTZ — NOT NULL

place_category

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • name — VARCHAR(10) — NOT NULL

place_hours

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • place_id — BIGINT — 외래 키 → place.id — NOT NULL
  • day_of_week — ENUM — NOT NULL
  • open_time — VARCHAR(10) — NOT NULL
  • close_time — VARCHAR(10) — NOT NULL
  • is_break_time — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

place_keyword

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • place_id — BIGINT — 외래 키 → place.id — NOT NULL
  • keyword_id — BIGINT — 외래 키 → keyword.id — NOT NULL

place_menu

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • place_id — BIGINT — 외래 키 → place.id — NOT NULL
  • price — INTEGER
  • menu_name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

refresh_token

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → user.id — NOT NULL
  • token — TEXT — NOT NULL
  • is_revoked — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • expired_at — TIMESTAMPTZ — NOT NULL

user

  • id — BIGSERIAL — 기본 키 — NOT NULL
  • provider_id — BIGINT — NOT NULL
  • provider — VARCHAR(10) — NOT NULL
  • image_url — VARCHAR(255)
  • introduction — VARCHAR(70)
  • username — VARCHAR(10) — NOT NULL
  • is_location_agreed — BOOLEAN — NOT NULL
  • is_privacy_agreed (privacy_agreed) — BOOLEAN — NOT NULL
  • privacy_agreed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL