Your phone is only shown when a player clicks "Show Contact". Tournament use only.
CREATE TABLE IF NOT EXISTS players ( id bigint generated always as identity primary key, created_at timestamptz default now(), first text not null, last text not null, phone text not null, gender text not null, dupr numeric not null, dupr_id text, categories text[], notes text ); ALTER TABLE players ENABLE ROW LEVEL SECURITY; CREATE POLICY "read" ON players FOR SELECT USING (true); CREATE POLICY "insert" ON players FOR INSERT WITH CHECK (true); CREATE POLICY "delete" ON players FOR DELETE USING (true); CREATE TABLE IF NOT EXISTS tournament ( id int primary key default 1, name text, start_date date, end_date date, location text, categories text[] ); INSERT INTO tournament(id) VALUES(1) ON CONFLICT DO NOTHING; ALTER TABLE tournament ENABLE ROW LEVEL SECURITY; CREATE POLICY "read t" ON tournament FOR SELECT USING (true); CREATE POLICY "update t" ON tournament FOR UPDATE USING (true);
Connect database to manage players.