searchwebdb

Tables (18)

app_user

  • user_id — int
  • email — varchar(255)
  • login_id — varchar(50)
  • password_hash — varchar(255)
  • display_name — varchar(50) — NOT NULL
  • status — varchar(20) — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

category

  • category_id — int
  • parent_category_id — int — Foreign key → category.category_id
  • category_name — varchar(80) — NOT NULL
  • category_level — smallint — NOT NULL
  • is_active — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL

folder_suggestion_rule

  • folder_suggestion_rule_id — int
  • scope_type — varchar(10) — NOT NULL
  • owner_user_id — int — Foreign key → app_user.user_id
  • team_id — int — Foreign key → team.team_id
  • category_id — int — Foreign key → category.category_id — NOT NULL
  • user_folder_id — int — Foreign key → user_folder.user_folder_id
  • team_folder_id — int — Foreign key → team_folder.team_folder_id
  • priority — int — NOT NULL
  • is_active — boolean — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

link

  • link_id — bigint
  • canonical_url — text — NOT NULL
  • original_url — text — NOT NULL
  • domain — varchar(255)
  • title — varchar(255)
  • description — text
  • thumbnail_url — text
  • favicon_url — text
  • content_type — varchar(30) — NOT NULL
  • primary_category_id — int — Foreign key → category.category_id
  • category_score — numeric(5,4)
  • classifier_version — varchar(50)
  • categorized_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

link_enrichment

  • link_enrichment_id — int
  • link_id — bigint — Foreign key → link.link_id — NOT NULL
  • request_url — text — NOT NULL
  • final_url — text
  • fetch_status — varchar(20) — NOT NULL
  • classify_status — varchar(20) — NOT NULL
  • attempt_count — smallint — NOT NULL
  • last_attempt_at — timestamptz
  • error_code — varchar(50)
  • error_message — text
  • http_status — int
  • latency_ms — int
  • selected_site_name — varchar(255)
  • selected_title — text
  • selected_description — text
  • fetched_at — timestamptz
  • predicted_category_id — int — Foreign key → category.category_id
  • predicted_score — numeric(5,4)
  • classifier_version — varchar(50)
  • classified_at — timestamptz
  • keyword_extractor_version — varchar(50)
  • keyword_source — varchar(30)
  • keyword_extracted_at — timestamptz
  • suggested_user_folder_id — int — Foreign key → user_folder.user_folder_id
  • suggested_team_folder_id — int — Foreign key → team_folder.team_folder_id
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

link_enrichment_keyword

  • link_enrichment_keyword_id — bigint
  • link_enrichment_id — int — Foreign key → link_enrichment.link_enrichment_id — NOT NULL
  • keyword — varchar(100) — NOT NULL
  • score — numeric(5,4)
  • rank — smallint — NOT NULL
  • source — varchar(30)
  • created_at — timestamptz — NOT NULL

team

  • team_id — int
  • team_name — varchar(80) — NOT NULL
  • owner_user_id — int — Foreign key → app_user.user_id — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

team_folder

  • team_folder_id — int
  • team_id — int — Foreign key → team.team_id — NOT NULL
  • parent_folder_id — int — Foreign key → team_folder.team_folder_id
  • folder_name — varchar(80) — NOT NULL
  • description — text
  • created_by_user_id — int — Foreign key → app_user.user_id — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

team_folder_permission

  • team_folder_id — int — Foreign key → team_folder.team_folder_id — NOT NULL
  • user_id — int — Foreign key → app_user.user_id — NOT NULL
  • permission — varchar(20) — NOT NULL

team_member

  • team_id — int — Foreign key → team.team_id — NOT NULL
  • user_id — int — Foreign key → app_user.user_id — NOT NULL
  • role — varchar(20) — NOT NULL
  • joined_at — timestamptz — NOT NULL

team_saved_link

  • team_saved_link_id — int
  • team_folder_id — int — Foreign key → team_folder.team_folder_id — NOT NULL
  • link_id — bigint — Foreign key → link.link_id — NOT NULL
  • created_by_user_id — int — Foreign key → app_user.user_id — NOT NULL
  • display_title — varchar(255) — NOT NULL
  • note — text
  • primary_category_id — int — Foreign key → category.category_id
  • category_source — varchar(10) — NOT NULL
  • category_score — numeric(5,4)
  • categorized_at — timestamptz
  • sort_order — int — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

team_saved_link_tag

  • team_saved_link_id — int — Foreign key → team_saved_link.team_saved_link_id — NOT NULL
  • team_tag_id — bigint — Foreign key → team_tag.team_tag_id — NOT NULL
  • created_at — timestamptz — NOT NULL

team_tag

  • team_tag_id — bigint
  • team_id — int — Foreign key → team.team_id — NOT NULL
  • tag_name — varchar(50) — NOT NULL
  • created_at — timestamptz — NOT NULL

user_folder

  • user_folder_id — int
  • owner_user_id — int — Foreign key → app_user.user_id — NOT NULL
  • parent_folder_id — int — Foreign key → user_folder.user_folder_id
  • folder_name — varchar(80) — NOT NULL
  • description — text
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

user_oauth

  • user_oauth_id — int
  • user_id — int — Foreign key → app_user.user_id — NOT NULL
  • provider — varchar(30) — NOT NULL
  • provider_user_key — varchar(255) — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

user_saved_link

  • user_saved_link_id — int
  • user_folder_id — int — Foreign key → user_folder.user_folder_id — NOT NULL
  • link_id — bigint — Foreign key → link.link_id — NOT NULL
  • created_by_user_id — int — Foreign key → app_user.user_id — NOT NULL
  • display_title — varchar(255) — NOT NULL
  • note — text
  • primary_category_id — int — Foreign key → category.category_id
  • category_source — varchar(10) — NOT NULL
  • category_score — numeric(5,4)
  • categorized_at — timestamptz
  • sort_order — int — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • deleted_at — timestamptz

user_saved_link_tag

  • user_saved_link_id — int — Foreign key → user_saved_link.user_saved_link_id — NOT NULL
  • user_tag_id — bigint — Foreign key → user_tag.user_tag_id — NOT NULL
  • created_at — timestamptz — NOT NULL

user_tag

  • user_tag_id — bigint
  • owner_user_id — int — Foreign key → app_user.user_id — NOT NULL
  • tag_name — varchar(50) — NOT NULL
  • created_at — timestamptz — NOT NULL