galaxy
Tables (12)
batch_process
- batch_id — BIGINT
- job_name — VARCHAR(255)
- job_type — VARCHAR(100)
- started_at — TIMESTAMP
- finished_at — TIMESTAMP
- status — VARCHAR(50)
- total_count — INT
- success_count — INT
- fail_count — INT
- error_message — TEXT
- created_at — TIMESTAMP
cluster
- cluster_id — BIGINT
- name — VARCHAR(255)
- type — VARCHAR(100)
- created_at — TIMESTAMP
document_chunk
- chunk_id — BIGINT
- doc_id — BIGINT — Foreign key → repo_document.doc_id — NOT NULL
- chunk_index — INT
- chunk_text — TEXT
- embedding — TEXT
- created_at — TIMESTAMP
repo
- repo_id — BIGINT
- full_name — VARCHAR(255) — NOT NULL
- owner_name — VARCHAR(255) — NOT NULL
- repo_name — VARCHAR(255) — NOT NULL
- repo_url — VARCHAR(255) — NOT NULL
- primary_language — VARCHAR(100)
- description — TEXT
- stars_total — BIGINT
- forks_total — BIGINT
- open_issues — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- is_deleted — BOOLEAN
repo_cluster
- id — BIGINT
- repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
- cluster_id — BIGINT — Foreign key → cluster.cluster_id — NOT NULL
repo_document
- doc_id — BIGINT
- repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
- doc_type — VARCHAR(50)
- original_url — VARCHAR(255)
- title — VARCHAR(255)
- content — TEXT
- content_hash — VARCHAR(255)
- collected_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
repo_event
- event_id — BIGINT
- repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
- batch_id — BIGINT — Foreign key → batch_process.batch_id
- external_id — VARCHAR(255) — NOT NULL
- actor_login — VARCHAR(255)
- event_type — VARCHAR(100) — NOT NULL
- event_action — VARCHAR(100)
- occurred_at — TIMESTAMP — NOT NULL
- raw_json — TEXT
- created_at — TIMESTAMP
- INDEX — idx_repo
- INDEX — idx_event_type
- INDEX — idx_occurred_at
repo_metric
- metric_id — BIGINT
- repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
- bucket — TIMESTAMP — NOT NULL
- health_score — FLOAT
- growth_score — FLOAT
- activity_score — FLOAT
- anomaly_score — FLOAT
- created_at — TIMESTAMP
repo_time
- repo_time_id — BIGINT
- repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
- bucket — TIMESTAMP — NOT NULL
- commit_count — INT
- pr_count — INT
- issue_count — INT
- star_count — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
source
- source_id — BIGINT
- repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
- traffic_source — VARCHAR(100) — NOT NULL
- inflow_classify — VARCHAR(100) — NOT NULL
- source_url — VARCHAR(255) — NOT NULL
- observe_rank — INT
- observe_date — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
users
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(255)
- profile_image — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
users_favorite
- favorite_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- repo_id — BIGINT — Foreign key → repo.repo_id — NOT NULL
- created_at — TIMESTAMP