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)