asdasd

Tables (11)

batch_process_event

  • batch_id — BIGSERIAL
  • job_name — VARCHAR — NOT NULL
  • job_type — VARCHAR — NOT NULL
  • time_range — VARCHAR — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • finished_at — TIMESTAMP — NOT NULL
  • status — VARCHAR — NOT NULL
  • total_count — BIGINT
  • success_count — BIGINT
  • fail_count — BIGINT
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL

cluster

  • cluster_id — BIGSERIAL
  • name — VARCHAR — NOT NULL
  • type — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

cluster_repo

  • repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
  • cluster_id — BIGINT — Foreign key → cluster.cluster_id — NOT NULL

document_chunk

  • chunk_id — BIGSERIAL
  • doc_id — BIGINT — Foreign key → repo_document.doc_id — NOT NULL
  • chunk_num — INT — NOT NULL
  • chunk_text — TEXT — NOT NULL
  • embed_model — VARCHAR — NOT NULL
  • embed_value — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

repo

  • repo_id — BIGSERIAL
  • full_name — VARCHAR — NOT NULL
  • owner_name — VARCHAR — NOT NULL
  • repo_name — VARCHAR(50) — NOT NULL
  • repo_url — VARCHAR — NOT NULL
  • primary_language — VARCHAR
  • topics — VARCHAR
  • stars_total — BIGINT — NOT NULL
  • forks_total — BIGINT — NOT NULL
  • trend_status — VARCHAR — NOT NULL
  • first_seen_at — TIMESTAMP — NOT NULL
  • last_seen_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

repo_document

  • doc_id — BIGSERIAL
  • repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
  • doc_type — VARCHAR — NOT NULL
  • origin_url — VARCHAR — NOT NULL
  • title — VARCHAR
  • content — TEXT
  • content_hash — VARCHAR
  • collected_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

repo_event

  • event_id — BIGSERIAL
  • repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
  • batch_id — BIGINT — Foreign key → batch_process_event.batch_id — NOT NULL
  • external_id — VARCHAR — NOT NULL
  • source — VARCHAR — NOT NULL
  • event_type — VARCHAR — NOT NULL
  • event_action — VARCHAR
  • actor_login — VARCHAR — NOT NULL
  • occurred_at — TIMESTAMP — NOT NULL
  • raw_json — JSON
  • created_at — TIMESTAMP — NOT NULL

repo_time

  • repo_time_id — BIGSERIAL
  • repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
  • batch_id — BIGINT — Foreign key → batch_process_event.batch_id — NOT NULL
  • bucket — TIMESTAMP — NOT NULL
  • commit_count — INT
  • pr_created — INT
  • pr_merged — INT
  • issue_created — INT
  • issue_closed — INT
  • star_count — INT
  • release_count — INT
  • active_score — DECIMAL
  • health_score — DECIMAL
  • brightness_score — DECIMAL
  • size_score — DECIMAL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

source

  • source_id — BIGSERIAL
  • repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
  • traffic_source — VARCHAR — NOT NULL
  • inflow_classify — VARCHAR — NOT NULL
  • source_url — VARCHAR — NOT NULL
  • observe_rank — INT
  • observe_date — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGSERIAL
  • email — VARCHAR(30) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • user_name — VARCHAR(40) — NOT NULL
  • profile_image — VARCHAR — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users_favorite

  • favorite_id — BIGSERIAL
  • repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL