erd-1asdmcn3

Tables (8)

call_stack

  • id — String — Primary key — NOT NULL
  • tx_id — uuid
  • function_name — char
  • start_time — Time
  • end_id — Time
  • parent_name — char

organization

  • org_id — BIGINT — Primary key — NOT NULL
  • github_org_id — BIGINT — NOT NULL
  • org_name — VARCHAR(255) — NOT NULL
  • installation_id — BIGINT — NOT NULL
  • created_at — DATETIME

performance_test

  • id — long — Primary key — NOT NULL — 성능 테스트 목록
  • pr_id — long
  • commit_id — char
  • Field — VARCHAR(255)

pull_request

  • pr_id — BIGINT — Primary key — NOT NULL
  • pr_number — INT — NOT NULL
  • title — VARCHAR(500)
  • author — VARCHAR(255)
  • state — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME
  • repo_id — BIGINT — NOT NULL

repository

  • repo_id — BIGINT — Primary key — NOT NULL
  • github_repo_id — BIGINT — NOT NULL
  • repo_name — VARCHAR(255) — NOT NULL
  • full_name — VARCHAR(500) — NOT NULL
  • is_active — BOOLEAN
  • created_at — DATETIME
  • org_id — BIGINT — NOT NULL
  • is_private — VARCHAR(20)
  • repo_selection — VARCHAR(20)

sql_information

  • id — String — Primary key — NOT NULL
  • tx_id — VARCHAR(255)
  • sql_count — int
  • Field — int

user

  • user_id — BIGINT — Primary key — NOT NULL
  • login_id — VARCHAR(255) — NOT NULL
  • github_user_id — BIGINT — NOT NULL
  • github_node_id — VARCHAR(255)
  • nickname — VARCHAR(255) — NOT NULL
  • avatar_url — VARCHAR(500)
  • refresh_token — VARCHAR(512)
  • created_at — DATETIME
  • updated_at — DATETIME

user_organization

  • user_id — BIGINT — Foreign key → user.user_id — NOT NULL
  • org_id — BIGINT — Foreign key → organization.org_id — NOT NULL