Hawthorne Guild

Database Schema (Dev Environment)

Generated on: 2026-06-09T00:13:27.090Z Database host: aws-0-us-west-2.pooler.supabase.com

Table Index

CCS_avrae_sessions

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
user_id uuid   - NO - -
name text   - NO - -
map_config jsonb   - YES - -
players jsonb   - YES - -
npcs jsonb   - YES - -
monsters jsonb   - YES - -
revealed_tiles jsonb   - YES - -
created_at timestamp with time zone   - NO now() -
updated_at timestamp with time zone   - NO now() -
effects jsonb   - YES '{}'::jsonb -

CCS_battlemaps

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id bigint PK - NO - -
name text   - NO - -
grid_width integer   - YES - -
grid_height integer   - YES - -
cell_size_px integer   - YES - -
keywords text   - YES - -
creator text   - NO - -
source_url text   - YES - -
is_free_use boolean   - NO false -
is_approved boolean   - NO false -
submitted_by uuid   - NO - -
created_at timestamp with time zone   - NO now() -
image_url text   - YES - -
thumbnail_url text   - YES - -
optimized_url text   - YES - -

CCS_card_participants

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
user_id uuid PK CCS_discord_users.user_id NO - -
points integer   - NO 0 -
enabled boolean   - NO true -
enrolled_at timestamp with time zone   - NO now() -
enrolled_by uuid   CCS_discord_users.user_id YES - -

CCS_cards

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
monster_type text   - NO - -
name text   - NO - -
card_number smallint   - NO - -
rarity text   - YES - -
flavor_text text   - YES - -
bonus_description text   - NO - -
passive_bonus_text text   - YES - -
image_url text   - YES - -
image_credit text   - YES - -
is_active boolean   - NO true -
created_at timestamp with time zone   - NO now() -
created_by uuid   CCS_discord_users.user_id YES - -
mega_bonus_text text   - YES - -

CCS_discord_role_map

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
role_id text PK - NO - -
role_name text   - NO - Text Role Name (Manually Updated unless we create a bot)
elevated_access boolean   - YES false -

CCS_discord_users

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
discord_id text   - NO - -
display_name text   - YES - -
roles jsonb   - YES - Guild Roles. Updated each login, translated via discord_role_map and a function upon save.
created_at timestamp with time zone   - YES now() -
user_id uuid PK - NO - Supabase UUID for authentication and authorisation control
last_seen timestamp with time zone   - YES - -
approved_map_submitter boolean   - YES false -

CCS_errors

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id bigint PK - NO nextval('errors_id_seq'::regclass) -
created_at timestamp with time zone   - NO now() -
module text   - YES - -
error text   - YES - -
user_id uuid   - YES - -
level text   - YES 'error'::text -

CCS_freehost_images

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
image_url text   - NO - -
thumb_url text   - NO - -
delete_url text   - YES - -
provider_id text   - YES - -
viewer_url text   - YES - -
width integer   - YES - -
height integer   - YES - -
original_filename text   - YES - -
resized_url text   - YES - -
resized_width integer   - YES - -
resized_height integer   - YES - -
was_resized boolean   - YES false -

CCS_location_maps

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id bigint PK - NO nextval('location_maps_id_seq'::regclass) -
name text   - NO - -
map_file_url text   - NO - -
description text   - YES - -
created_at timestamp with time zone   - YES CURRENT_TIMESTAMP -
updated_at timestamp with time zone   - YES CURRENT_TIMESTAMP -
width smallint   - YES - -
height smallint   - YES - -
initial_x real   - YES 0 The starting horizontal coordinate (longitude) for the map view.
initial_y real   - YES 0 The starting vertical coordinate (latitude) for the map view.
initial_zoom real   - YES 0 The starting zoom level. 0 is usually full fit, positive is zoomed in.
display_height text   - YES '600px'::text The CSS height for the map widget (e.g., 80vh, 500px).

CCS_locations

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id bigint PK - NO nextval('locations_id_seq'::regclass) -
map_id bigint   - NO - -
name text   - YES - -
x numeric   - YES - -
y numeric   - YES - -
description text   - YES - -
link_url text   - YES - -
is_home boolean   - YES false -
created_at timestamp with time zone   - YES CURRENT_TIMESTAMP -

CCS_player_cards

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
user_id uuid   CCS_discord_users.user_id NO - -
card_id uuid   CCS_cards.id NO - -
state text   - NO - -
acquired_at timestamp with time zone   - NO now() -
revealed_at timestamp with time zone   - YES - -

CCS_session_images

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
user_id uuid   - NO - -
name text   - NO - -
search_keys text   - YES - -
image_id uuid   - NO - -

CCS_system

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id bigint PK - NO nextval('system_id_seq'::regclass) -
created_at timestamp with time zone   - NO now() -
setting text   - YES - -
value text   - YES - -

CCS_tokens

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
type text   - NO - -
token_code text   - YES - -
created_at timestamp with time zone   - YES now() -
user_id uuid   - YES auth.uid() -
size text   - NO 'medium'::text size
image_url text   - YES - -

ac_artificer_infusions

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
item_prereq text   - YES - -
requires_attunement text   - YES - -
level_prereq text   - YES - -
source text   - NO - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_backgrounds

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
source text   - NO - -
feature text   - YES - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_bastion_categories

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
notes text   - YES - -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -
display_order integer   - YES 0 -

ac_bastions

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
category_id uuid   ac_bastion_categories.id YES - -
name text   - NO - -
source text   - YES - -
size text   - YES - -
building_prerequisite text   - YES - -
cost_gp text   - YES - -
cost_dtp text   - YES - -
order text   - YES - -
description text   - YES - -
notes_advice text   - YES - -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_classes

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
subclass text   - NO - -
hit_die text   - YES - -
multiclassing text   - YES - -
expanded_options text   - YES - -
rage_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_downtime

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
category_id uuid   ac_downtime_categories.id YES - -
name text   - NO - -
gold_cost text   - YES - -
dtp_cost text   - YES - -
description text   - YES - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_downtime_categories

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
notes text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_eldritch_invocations

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
pact_prereq text   - YES - -
other_prereq text   - YES - -
level_prereq text   - YES - -
source text   - NO - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_equipment

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
category_id uuid   ac_equipment_categories.id YES - -
name text   - NO - -
source text   - NO - -
cost_gp text   - YES - -
weight_lbs text   - YES - -
craft_cost_gp text   - YES - -
craft_cost_dtp text   - YES - -
craft_reqs text   - YES - -
description text   - YES - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_equipment_categories

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
notes text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_feats

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
source text   - NO - -
category text   - YES - -
prerequisite text   - YES - -
ability_increase text   - YES - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_fighting_styles

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
classes text   - YES - -
source text   - NO - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_item_properties

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
category_id uuid   ac_item_properties_categories.id YES - -
name text   - NO - -
source text   - NO - -
type text   - YES - -
category_sub text   - YES - -
description text   - YES - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_item_properties_categories

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
notes text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_language_types

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
description text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_languages

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
type_id uuid   ac_language_types.id YES - -
script text   - YES - -
origin text   - YES - -
typical_speakers text   - YES - -
notes text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_loot

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
category_id uuid   ac_loot_categories.id YES - -
name text   - NO - -
source text   - NO - -
type text   - YES - -
tier text   - YES - -
description text   - YES - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_loot_categories

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
notes text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_monsters

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
category_id uuid   ac_monsters_categories.id YES - -
name text   - NO - -
source text   - NO - -
classification text   - YES - -
cr text   - YES - -
creature_type text   - YES - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_monsters_categories

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
notes text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_other_rewards

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
category_id uuid   ac_other_rewards_categories.id YES - -
name text   - NO - -
source text   - NO - -
type text   - YES - -
tier text   - YES - -
description text   - YES - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_other_rewards_categories

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
notes text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_races

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
subrace text   - NO - -
size text   - YES - -
speed text   - YES - -
language text   - YES - -
str text   - YES - -
dex text   - YES - -
con text   - YES - -
int text   - YES - -
wis text   - YES - -
cha text   - YES - -
extra text   - YES - -
source text   - YES - -
rage_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_sources

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
category_id uuid   ac_sources_categories.id YES - -
name text   - NO - -
abbreviation text   - YES - -
type text   - YES - -
ruleset text   - YES - -
allowed_content text   - YES - -
notes_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -
link text   - YES - -

ac_sources_categories

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
notes text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

ac_spells

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
name text   - NO - -
source text   - NO - -
notes text   - YES - -
rage_advice text   - YES - -
display_order integer   - YES 0 -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

discord_role_map

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
role_id text PK - NO - -
role_name text   - NO - -
elevated_access boolean   - YES false -
monster_admin boolean   - YES false -

discord_users

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
discord_id text PK - NO - -
display_name text   - YES - -
roles jsonb   - YES '[]'::jsonb -
created_at timestamp with time zone   - YES now() -
user_id uuid   - YES - -
last_seen timestamp with time zone   - YES now() -
site_admin boolean   - NO false -

errors

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id bigint PK - NO - -
created_at timestamp with time zone   - NO now() -
module text   - YES - -
error text   - YES - -
user_id uuid   - YES - -
level text   - YES 'error'::text -

events

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id integer PK - NO - -
name text   - NO - -
description text   - YES - -
is_active boolean   - YES true -
created_at timestamp with time zone   - YES now() -

faq

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id bigint PK - NO nextval('faq_id_seq'::regclass) -
question text   - NO - -
answer text   - NO - -
embedding USER-DEFINED   - YES - -
channel_ids ARRAY   - YES - -
category text   - NO - -

location_maps

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id bigint PK - NO - -
name text   - NO - -
map_file_url text   - NO - -
description text   - YES - -
created_at timestamp with time zone   - YES now() -
updated_at timestamp with time zone   - YES now() -
width smallint   - YES - -
height smallint   - YES - -
initial_x real   - YES 0 -
initial_y real   - YES 0 -
initial_zoom real   - YES 0 -
display_height text   - YES '600px'::text -

locations

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id bigint PK - NO - -
map_id bigint   location_maps.id NO - -
name text   - YES - -
x numeric   - YES - -
y numeric   - YES - -
description text   - YES - -
link_url text   - YES - -
is_home boolean   - YES false -
created_at timestamp with time zone   - YES now() -

lookup_habitats

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id integer PK - NO nextval('lookup_habitats_id_seq'::regclass) -
name text   - YES - -

lookups

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
type text PK - NO - -
data jsonb   - NO - -

monster_features

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO uuid_generate_v4() -
parent_row_id uuid   monsters.row_id NO - -
name text   - NO - -
description text   - NO - -
type USER-DEFINED   - NO - -
display_order integer   - YES 0 -

monster_habitats

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
parent_row_id uuid PK monsters.row_id NO - -
habitat_id integer PK lookup_habitats.id NO - -

monsters

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
row_id uuid PK - NO uuid_generate_v4() -
monster_id uuid   - NO uuid_generate_v4() -
version text   - NO '1.0'::text -
slug text   - NO - -
name text   - NO - -
is_live boolean   - YES false -
status USER-DEFINED   - YES 'Draft'::monster_status Draft, Pending, Queued, Approved, Archived
usage text   - YES - -
creator_notes text   - YES - -
reviewer_id uuid   - YES - -
image_url text   - YES - -
image_credit text   - YES - -
token_url text   - YES - -
size text   - NO - -
species text   - NO - -
alignment text   - NO - -
alignment_prefix text   - YES - -
description text   - YES - -
additional_info text   - YES - -
tags jsonb   - YES '[]'::jsonb -
ac integer   - NO - -
conditional_ac text   - YES - -
hit_dice_num integer   - NO - -
hit_dice_size integer   - NO - -
hp_modifier integer   - NO 0 -
speed text   - NO - -
init_prof text   - YES 'None'::text -
ability_scores jsonb   - NO '{}'::jsonb -
saves jsonb   - YES '{}'::jsonb -
skills text   - YES - -
damage_vulnerabilities text   - YES - -
damage_resistances text   - YES - -
damage_immunities text   - YES - -
senses text   - YES - -
languages text   - YES - -
cr numeric   - NO - -
legendary_header text   - YES - Intro text for the Legendary Actions section
lair_header text   - YES - Intro text for the Lair Actions section
regional_header text   - YES - Intro text for the Regional Effects section
created_at timestamp with time zone   - YES now() -
updated_at timestamp with time zone   - YES now() -
submitted_at timestamp with time zone   - YES - -
archived_at timestamp with time zone   - YES - -
condition_immunities text   - YES - -
creator_discord_id text   discord_users.discord_id YES - -
creator text   - YES - -
reviewer_notes text   - YES - -
passive_perc_prof text   - YES 'None'::text Proficiency level for Passive Perception calculation (None, Proficient, Expert)

rework

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -
discord_id text   - NO - -
character_name text   - YES - -
old_character jsonb   - YES - -
new_character jsonb   - YES - -
cost text   - YES - -
notes text   - YES - -
rework_type text   - YES - -

server_msg

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
message text   - NO - -
start_date date   - NO - -
end_date date   - NO - -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

session_logs

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO gen_random_uuid() -
user_id uuid   - NO - -
title text   - NO - -
session_date date   - YES - -
is_template boolean   - YES false -
form_data jsonb   - NO '{}'::jsonb -
created_at timestamp with time zone   - NO timezone('utc'::text, now()) -
updated_at timestamp with time zone   - NO timezone('utc'::text, now()) -

session_player_submissions

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id uuid PK - NO uuid_generate_v4() -
session_id uuid   session_logs.id YES - -
discord_id text   - NO - -
payload jsonb   - YES '{}'::jsonb -
updated_at timestamp with time zone   - YES timezone('utc'::text, now()) -

system

Description: No description provided.

Row-Level Security: ✓ Enabled

Columns

Field Type Key References Null Default Description
id bigint PK - NO - -
created_at timestamp with time zone   - NO now() -
setting text   - YES ''::text -
value text   - YES ''::text -