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