슈가FC

테이블 (6)

supabase auth.users 테이블 (auth.users)

  • Field (id) — uuid — 기본 키
  • Field (email)

매치 (match)

  • Key (uid) — uuid — 기본 키 — NOT NULL
  • Field (title) — varchar
  • Field (st_date) — timestampz
  • Field (ed_date) — timestampz
  • Field (created_at) — timestampz
  • Field (updated_at) — timestampz

선수 (player)

  • Field (uid) — uuid — 기본 키 — NOT NULL
  • Field (created_at) — timestamp
  • Field (updated_at) — timestamp
  • Field (birth) — varchar
  • Field (name) — varchar
  • Field (user_uid) — uuid — 외래 키 → 유저.Field

선수와 매치의 조인 (player_match_join)

  • FK (match_uid) — uuid — 외래 키 → 매치.Key — NOT NULL
  • FK (player_uid) — uuid — 외래 키 → 선수.Field — NOT NULL
  • 투표상태 (vote_state) — varchar
  • 출석상태 (attendance_state) — varchar
  • Field2 (created_at) — timestampz
  • Field (updated_at) — timestampz

유저 (public.user)

  • Field (uid) — uuid — 외래 키 → supabase auth.users 테이블.Field
  • Field (created_at) — timestampz
  • Field (updated_at) — timestampz
  • 이메일 (email) — varchar
  • Field (permissions) — varchar[]

직함 (player_title)

  • Field (player_uid) — uuid — 외래 키 → 선수.Field — NOT NULL
  • Field (created_at) — timestampz
  • Field (updated_at) — timestampz
  • Field (updated_uid) — timestampz
  • Field (code) — varchar
  • Field (title) — varchar