슈가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