Head over to the "Table Editor" in the Supabase dashboard.

Make a new table called consents.

```sql
CREATE TABLE consents (
id uuid PRIMARY KEY DEFAULT uuid_generate_v4(),
user_id uuid REFERENCES auth.users (id) NOT NULL,
consent_type text NOT NULL,
consent_given boolean NOT NULL,
timestamp timestamptz DEFAULT current_timestamp
);
```

Set up authentication in your frontend app using the Supabase client.

```javascript
import { createClient } from '@supabase/supabase-js'

const supabaseUrl = 'https://your-project.supabase.co'
const supabaseKey = 'your-anon-key'
const supabase = createClient(supabaseUrl, supabaseKey)

export const signIn = async (email, password) => {
const { user, error } = await supabase.auth.signIn({ email, password })
if (error) console.error('Error', error.message)
return user
}
```

Add a section in the user registration or settings page to gather consent.

```html

```javascript
async function submitConsent() {
const consentGiven = document.getElementById('consent-checkbox').checked
const user = supabase.auth.user()
if (user) {
const { data, error } = await supabase
.from('consents')
.insert([
{ user_id: user.id, consent_type: 'terms_and_conditions', consent_given: consentGiven }
])
if (error) console.error('Error', error)
}
}
```

Give users a way to update their consent info in the settings.

```html

```javascript
async function updateConsent() {
const consentGiven = document.getElementById('consent-update-checkbox').checked
const user = supabase.auth.user()
if (user) {
const { data, error } = await supabase
.from('consents')
.update({ consent_given: consentGiven })
.eq('user_id', user.id)
.eq('consent_type', 'terms_and_conditions')
if (error) console.error('Error', error)
}
}
```

Use the Supabase client to get user consent details when you need them.

```javascript
async function fetchUserConsent() {
const user = supabase.auth.user()
if (user) {
const { data, error } = await supabase
.from('consents')
.select('*')
.eq('user_id', user.id)
if (error) console.error('Error', error)
return data
}
}
```