자율PJT_당근_ERD_init

테이블 (12)

Announcement

  • announcement_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
  • site_id (PK2) — SERIAL — 외래 키 → SourceSite.site_id — NOT NULL
  • origin_id (Field12) — INT
  • origin_url (Field13) — TEXT
  • title (Field2) — TEXT
  • content_html (Field) — TEXT
  • content_text (Field3) — TEXT
  • thumbnail_url (Field4) — TEXT
  • posted_at (Field5) — TIMESTAMPTZ
  • start_at (Field6) — TIMESTAMPTZ
  • end_at (Field7) — TIMESTAMPTZ
  • status (Field8) — VARCHAR(20)
  • content_hash (Field9) — VARCHAR(64)
  • created_at (Field10) — TIMESTAMPTZ
  • updated_at (Field11) — TIMESTAMPTZ

AnnouncementTag

  • announcement_id (PK) — BIGSERIAL — 외래 키 → Announcement.announcement_id — NOT NULL
  • tag_id (PK2) — SERIAL — 외래 키 → Tag.tag_id — NOT NULL

Attachment

  • attachment_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
  • announcement_id (PK2) — BIGSERIAL — 외래 키 → Announcement.announcement_id — NOT NULL
  • file_url (Field) — TEXT
  • file_type (Field2) — VARCHAR(30)
  • file_name (Field3) — TEXT
  • file_size_bytes (Field4) — BIGINT
  • local_path (Field5) — TEXT
  • created_at (Field6) — TIMESTAMPTZ

Bookmark

  • user_id (PK) — BIGSERIAL — 외래 키 → User.user_id — NOT NULL
  • announcement_id (PK2) — BIGSERIAL — 외래 키 → Announcement.announcement_id — NOT NULL
  • created_at (Field3) — TIMESTAMPTZ

CrawlJob

  • job_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
  • site_id (PK2) — SERIAL — 외래 키 → SourceSite.site_id — NOT NULL
  • scheduled_at (Field) — TIMESTAMPTZ
  • started_at (Field2) — TIMESTAMPTZ
  • finished_at (Field3) — TIMESTAMPTZ
  • status (Field4) — VARCHAR(20)
  • new_count (Field5) — INT
  • updated_count (Field6) — INT
  • error_count (Field7) — INT
  • error_message (Field8) — TEXT

CrawlLog

  • log_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
  • job_id (PK2) — BIGSERIAL — 외래 키 → CrawlJob.job_id — NOT NULL
  • level (Field) — VARCHAR(10)
  • message (Field2) — TEXT
  • created_at (Field3) — TIMESTAMPTZ

Image

  • image_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
  • user_id (PK2) — BIGSERIAL — 외래 키 → User.user_id — NOT NULL
  • image_url (URL) — VARCHAR(255)
  • image_path (PATH) — VARCHAR(255)

NotificationQueue

  • queue_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
  • user_id (PK2) — BIGSERIAL — 외래 키 → User.user_id — NOT NULL
  • announcement_id (PK3) — BIGSERIAL — 외래 키 → Announcement.announcement_id — NOT NULL
  • reason (Field) — VARCHAR(50)
  • scheduled_at (Field2) — TIMESTAMPTZ
  • sent_at (Field3) — TIMESTAMPTZ

SourceSite

  • site_id (PK) — SERIAL — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(200)
  • base_url (Field2) — TEXT
  • region_code (Field3) — VARCHAR(50)
  • is_active (Field5) — BOOLEAN
  • crawl_rule_json (Field4) — JSONB
  • created_at (Field6) — TIMESTAMPTZ
  • updated_at (Field7) — TIMESTAMPTZ

Subscription

  • subscription_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
  • user_id (PK2) — BIGSERIAL — 외래 키 → User.user_id — NOT NULL
  • type (Field) — VARCHAR(20)
  • keyword (Field2) — VARCHAR(100)
  • tag_id (FK2) — INT
  • site_id (FK3) — INT
  • frequency (Field3) — VARCHAR(20)
  • is_active (Field4) — BOOLEAN
  • created_at (Field5) — TIMESTAMPTZ

Tag

  • tag_id (PK) — SERIAL — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(60)

User

  • user_id (PK) — BIGSERIAL — 기본 키 — NOT NULL
  • profile_url (Field4) — VARCHAR(255)
  • email (Field7) — VARCHAR(255)
  • password_hash (Field9) — VARCHAR(255)
  • oauth_id (Field) — BIGINT
  • username (Field2) — VARCHAR(20)
  • is_email_verified (Field10) — BOOLEAN
  • role (Field11) — VARCHAR(20)
  • location (Field3) — VARCHAR(50)
  • email_opt_in (Field8) — BOOLEAN
  • created_at (Field5) — TIMESTAMPTZ
  • updated_at (Field6) — TIMESTAMPTZ