homerun

Tables (6)

daily_saju_report

  • id — BIGSERIAL
  • player_id — BIGINT — Foreign key → players.id — NOT NULL
  • game_date — DATE — NOT NULL
  • game_day_stem — VARCHAR(10)
  • game_day_branch — VARCHAR(10)
  • five_element_interaction — JSONB
  • ten_god_interaction — JSONB
  • report_text — TEXT
  • lucky_index — INTEGER
  • status — report_status — NOT NULL
  • prompt_version — VARCHAR(20) — NOT NULL
  • attempt_count — INTEGER — NOT NULL
  • error_message — TEXT
  • generated_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • CHECK — ( status IN ( 'pending', 'generating', 'generated', 'failed' )
  • CHECK — (lucky_index IS NULL OR lucky_index BETWEEN 0 AND 100)

games

  • id — BIGSERIAL
  • game_date — DATE — NOT NULL
  • game_time — TIME
  • home_team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • away_team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • created_at — TIMESTAMP

player_saju

  • player_id — BIGINT — Foreign key → players.id
  • year_pillar — VARCHAR(10) — NOT NULL
  • month_pillar — VARCHAR(10) — NOT NULL
  • day_pillar — VARCHAR(10) — NOT NULL
  • hour_pillar — VARCHAR(10)
  • day_master — VARCHAR(10) — NOT NULL
  • five_elements — JSONB — NOT NULL
  • created_at — TIMESTAMP

players

  • id — BIGSERIAL
  • team_id — BIGINT — Foreign key → teams.id — NOT NULL
  • name — TEXT — NOT NULL
  • birth_date — DATE — NOT NULL
  • zodiac_sign — TEXT
  • birth_time — TIME
  • created_at — TIMESTAMP
  • CHECK — ( zodiac_sign IN ( '양', '황소', '쌍둥이', '게', '사자', '처녀', '천칭', '전갈', '사수', '염소', '물병', '물고기' )

teams

  • id — BIGSERIAL
  • name — TEXT — NOT NULL
  • ranking — INTEGER
  • ranking_base_date — DATE

zodiac_fortune_rankings

  • id — BIGSERIAL
  • fortune_date — DATE — NOT NULL
  • zodiac_sign — VARCHAR(10) — NOT NULL
  • rank — INTEGER — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • CHECK — ( zodiac_sign IN ( '양', '황소', '쌍둥이', '게', '사자', '처녀', '천칭', '전갈', '사수', '염소', '물병', '물고기' )
  • CHECK — (rank BETWEEN 1 AND 12)