자율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