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