cracktunes_main_layout

main Layout Generated using DbSchema

Main Layout

Tables

1. public._sqlx_migrations
2. public.allowed_domains
3. public.authorized_users
4. public.banned_domains
5. public.channel
6. public.command_channel
7. public.group_permission
8. public.guild
9. public.guild_member
10. public.guild_settings
11. public.ignored_channels
12. public.log_settings
13. public.message
14. public.metadata
15. public.permission_settings
16. public.play_log
17. public.playlist
18. public.playlist_track
19. public.role
20. public.shared_playlist
21. public.todo
22. public.track_reaction
23. public.user
24. public.user_channel
25. public.user_permission
26. public.user_role
27. public.user_trace
28. public.user_votes
29. public.vote_webhook
30. public.welcome_settings

Table public._sqlx_migrations

Idx	Name	Data Type
* 🔑	version	bigint
*	description	text
*	installed_on	timestamptz DEFAULT now()
*	success	boolean
*	checksum	bytea
*	execution_time	bigint

Indexes

Type	Name	On
🔑	_sqlx_migrations_pkey	ON version

Table public.allowed_domains

Idx	Name	Data Type
* 🔑 ⬈	guild_id	bigint
* 🔑	domain	text

Indexes

Type	Name	On
🔑	allowed_domains_pkey	ON guild_id, domain

Foreign Keys

Type	Name	On
	fk_allowed_domains	( guild_id ) ref public.guild_settings (guild_id)

Table public.authorized_users

Idx	Name	Data Type
* 🔑 ⬈	guild_id	bigint
* 🔑	user_id	bigint
	permissions	bigint

Indexes

Type	Name	On
🔑	authorized_users_pkey	ON guild_id, user_id

Foreign Keys

Type	Name	On
	fk_authorized_users	( guild_id ) ref public.guild_settings (guild_id)

Table public.banned_domains

Idx	Name	Data Type
* 🔑 ⬈	guild_id	bigint
* 🔑	domain	text

Indexes

Type	Name	On
🔑	banned_domains_pkey	ON guild_id, domain

Foreign Keys

Type	Name	On
	fk_banned_domains	( guild_id ) ref public.guild_settings (guild_id)

Table public.channel

Idx	Name	Data Type
* 🔑 ⬋	id	bigint
⬈	guild_id	bigint
	name	text
	type	text
	position	integer
	created_at	timestamp
	updated_at	timestamp

Indexes

Type	Name	On
🔑	channel_pkey	ON id

Foreign Keys

Type	Name	On
	fk_channel	( guild_id ) ref public.guild (id)

Table public.command_channel

Idx	Name	Data Type
* 🔑	command	text
* 🔑 ⬈	guild_id	bigint
* 🔑	channel_id	bigint
* ⬈	permission_settings_id	bigint

Indexes

Type	Name	On
🔑	command_channel_pkey	ON command, guild_id, channel_id

Foreign Keys

Type	Name	On
	fk_command_channel_permission_settings_id	( permission_settings_id ) ref public.permission_settings (id)
	fk_command_channel_guild_id	( guild_id ) ref public.guild (id)

Table public.group_permission

Idx	Name	Data Type
* 🔑	id	serial
*	group_id	bigint
* ⬈	guild_id	bigint
*	permission_key	text
*	permission_value	integer
*	created_at	timestamp DEFAULT CURRENT_TIMESTAMP

Indexes

Type	Name	On
🔑	group_permission_pkey	ON id

Foreign Keys

Type	Name	On
	fk_guild_id	( guild_id ) ref public.guild (id)

Table public.guild

Idx	Name	Data Type
* 🔑 ⬋	id	bigint
*	name	text
*	created_at	timestamp DEFAULT CURRENT_TIMESTAMP
*	updated_at	timestamp DEFAULT CURRENT_TIMESTAMP

Indexes

Type	Name	On
🔑	guild_pkey	ON id

Table public.guild_member

Idx	Name	Data Type
* 🔑 ⬈	guild_id	bigint
* 🔑 ⬈	user_id	bigint
	nick	text
	joined_at	timestamp

Indexes

Type	Name	On
🔑	guild_member_pkey	ON guild_id, user_id

Foreign Keys

Type	Name	On
	guild_member_user_id_fkey	( user_id ) ref public.user (id)
	fk_guild_member	( guild_id ) ref public.guild (id)

Table public.guild_settings

Idx	Name	Data Type
* 🔑 ⬋	guild_id	bigint
*	guild_name	text
*	prefix	text DEFAULT ‘r!’::text
*	premium	boolean DEFAULT false
*	autopause	boolean DEFAULT false
*	allow_all_domains	boolean DEFAULT true
*	allowed_domains	text[] DEFAULT ’{}‘::text[]
*	banned_domains	text[] DEFAULT ’{}‘::text[]
*	ignored_channels	bigint[] DEFAULT ’{}‘::bigint[]
*	old_volume	double precision DEFAULT 1.0
*	volume	double precision DEFAULT 1.0
*	self_deafen	boolean DEFAULT true
*	timeout_seconds	integer DEFAULT 360
*	additional_prefixes	text[] DEFAULT ’{}‘::text[]

Indexes

Type	Name	On
🔑	guild_settings_pkey	ON guild_id

Table public.ignored_channels

Idx	Name	Data Type
* 🔑 ⬈	guild_id	bigint
* 🔑	channel_id	bigint

Indexes

Type	Name	On
🔑	ignored_channels_pkey	ON guild_id, channel_id

Foreign Keys

Type	Name	On
	fk_ignored_channels	( guild_id ) ref public.guild_settings (guild_id)

Table public.log_settings

Idx	Name	Data Type
* 🔑 ⬈	guild_id	bigint
	all_log_channel	bigint
	raw_event_log_channel	bigint
	server_log_channel	bigint
	member_log_channel	bigint
	join_leave_log_channel	bigint
	voice_log_channel	bigint

Indexes

Type	Name	On
🔑	log_settings_pkey	ON guild_id

Foreign Keys

Type	Name	On
	fk_log_settings	( guild_id ) ref public.guild_settings (guild_id)

Table public.message

Idx	Name	Data Type
* 🔑	id	bigint
⬈	channel_id	bigint
⬈	author_id	bigint
	content	text
	created_at	timestamp
	updated_at	timestamp

Indexes

Type	Name	On
🔑	message_pkey	ON id

Foreign Keys

Type	Name	On
	message_author_id_fkey	( author_id ) ref public.user (id)
	fk_message	( channel_id ) ref public.channel (id)

Table public.metadata

Idx	Name	Data Type
* 🔑 ⬋	id	serial
	track	text
	artist	text
	album	text
	date	date
	channels	smallint
	channel	text
*	start_time	bigint DEFAULT 0
*	duration	bigint DEFAULT 0
	sample_rate	integer
🔎	source_url	text
	title	text
	thumbnail	text

Indexes

Type	Name	On
🔑	metadata_pkey	ON id
🔎	metadata_track_artist_album_idx	ON source_url

Table public.permission_settings

Idx	Name	Data Type
* 🔑 ⬋	id	serial
*	default_allow_all_commands	boolean
*	default_allow_all_users	boolean
*	default_allow_all_roles	boolean
*	allowed_roles	bigint[]
*	denied_roles	bigint[]
*	allowed_users	bigint[]
*	denied_users	bigint[]
*	allowed_channels	bigint[] DEFAULT ARRAY[]::bigint[]
*	denied_channels	bigint[] DEFAULT ARRAY[]::bigint[]

Indexes

Type	Name	On
🔑	permission_settings_pkey	ON id

Table public.play_log

Idx	Name	Data Type
* 🔑 ⬋	id	serial
* ⬈	user_id	bigint
* ⬈	guild_id	bigint
* ⬈	metadata_id	bigint
*	created_at	timestamp DEFAULT CURRENT_TIMESTAMP

Indexes

Type	Name	On
🔑	play_log_pkey	ON id

Foreign Keys

Type	Name	On
	play_log_metadata_id_fkey	( metadata_id ) ref public.metadata (id)
	play_log_guild_id_fkey	( guild_id ) ref public.guild_settings (guild_id)
	play_log_fk_constraint	( user_id ) ref public.user (id)

Table public.playlist

Idx	Name	Data Type
* 🔑 ⬋	id	serial
* 🔎	name	text
🔎 ⬈	user_id	bigint
*	privacy	text DEFAULT ‘private’::text

Indexes

Type	Name	On
🔑	playlist_pkey	ON id
🔎	playlist_name_user_id_idx	ON name, user_id

Foreign Keys

Type	Name	On
	fk_playlist_user	( user_id ) ref public.user (id)

Constraints

Name	Definition
playlist_privacy_check	(privacy = ANY (ARRAY[‘public’::text, ‘private’::text, ‘shared’::text]))

Table public.playlist_track

Idx	Name	Data Type
* 🔑	id	serial
* ⬈	playlist_id	integer
* ⬈	metadata_id	integer
	guild_id	bigint
	channel_id	bigint

Indexes

Type	Name	On
🔑	playlist_track_pkey	ON id

Foreign Keys

Type	Name	On
	playlist_track_metadata_id_fkey	( metadata_id ) ref public.metadata (id)
	fk_playlist_track_playlist	( playlist_id ) ref public.playlist (id)

Table public.role

Idx	Name	Data Type
* 🔑 ⬋	id	bigint
⬈	guild_id	bigint
	name	text
	color	integer
	hoist	boolean
	position	integer
	permissions	bigint
	managed	boolean
	mentionable	boolean
	created_at	timestamp
	updated_at	timestamp

Indexes

Type	Name	On
🔑	role_pkey	ON id

Foreign Keys

Type	Name	On
	fk_role	( guild_id ) ref public.guild (id)

Table public.shared_playlist

Idx	Name	Data Type
* 🔑	id	serial
🔍 ⬈	playlist_id	bigint
🔍 ⬈	shared_with_user_id	bigint

Indexes

Type	Name	On
🔑	shared_playlist_pkey	ON id
🔍	uq_shared_playlist	ON playlist_id, shared_with_user_id

Foreign Keys

Type	Name	On
	shared_playlist_shared_with_user_id_fkey	( shared_with_user_id ) ref public.user (id)
	shared_playlist_playlist_id_fkey	( playlist_id ) ref public.playlist (id)

Table public.todo

Idx	Name	Data Type
* 🔑	id	serial
* ⬈	user_id	bigint
*	description	text
*	done	boolean DEFAULT false
*	creation_date	date DEFAULT CURRENT_DATE
	done_date	date

Indexes

Type	Name	On
🔑	todo_pkey	ON id

Foreign Keys

Type	Name	On
	fk_todo_user	( user_id ) ref public.user (id)

Table public.track_reaction

Idx	Name	Data Type
* 🔑 ⬈	play_log_id	integer
*	likes	integer DEFAULT 0
*	dislikes	integer DEFAULT 0
*	skip_votes	integer DEFAULT 0
*	created_at	timestamp DEFAULT CURRENT_TIMESTAMP

Indexes

Type	Name	On
🔑	track_reaction_pkey	ON play_log_id

Foreign Keys

Type	Name	On
	fk_track_reaction_play_log	( play_log_id ) ref public.play_log (id)

Table public.user

Idx	Name	Data Type
* 🔑 ⬋	id	bigint
*	username	text
	discriminator	smallint
*	avatar_url	text DEFAULT ”::text
*	bot	boolean
*	created_at	timestamp
*	updated_at	timestamp
*	last_seen	timestamp

Indexes

Type	Name	On
🔑	user_pkey	ON id

Table public.user_channel

Idx	Name	Data Type
* 🔑 ⬈	user_id	bigint
* 🔑 ⬈	channel_id	bigint

Indexes

Type	Name	On
🔑	user_channel_pkey	ON user_id, channel_id

Foreign Keys

Type	Name	On
	user_channel_channel_id_fkey	( channel_id ) ref public.channel (id)
	fk_user_channel	( user_id ) ref public.user (id)

Table public.user_permission

Idx	Name	Data Type
* 🔑	id	serial
* ⬈	user_id	bigint
* ⬈	guild_id	bigint
*	permission_key	text
*	permission_value	integer
*	created_at	timestamp DEFAULT CURRENT_TIMESTAMP

Indexes

Type	Name	On
🔑	user_permission_pkey	ON id

Foreign Keys

Type	Name	On
	user_permission_guild_id_fkey	( guild_id ) ref public.guild (id)
	fk_user_guild_id	( user_id ) ref public.user (id)

Table public.user_role

Idx	Name	Data Type
* 🔑 ⬈	user_id	bigint
* 🔑 ⬈	role_id	bigint

Indexes

Type	Name	On
🔑	user_role_pkey	ON user_id, role_id

Foreign Keys

Type	Name	On
	user_role_role_id_fkey	( role_id ) ref public.role (id)
	fk_user_role	( user_id ) ref public.user (id)

Table public.user_trace

Idx	Name	Data Type
* 🔑	user_id	bigint
* 🔑	ts	timestamp
	whence	text

Indexes

Type	Name	On
🔑	user_trace_pkey	ON user_id, ts

Table public.user_votes

Idx	Name	Data Type
* 🔑	id	serial
* 🔎 ⬈	user_id	bigint
* 🔎	timestamp	timestamp
* 🔎	site	text

Indexes

Type	Name	On
🔑	user_votes_pkey	ON id
🔎	user_votes_user_id_idx	ON user_id, timestamp, site

Foreign Keys

Type	Name	On
	crack_voting_user_id_fkey	( user_id ) ref public.user (id)

Table public.vote_webhook

Idx	Name	Data Type
* 🔑	id	serial
*	bot_id	bigint
* ⬈	user_id	bigint
*	kind	webhook_kind
*	is_weekend	boolean
	query	text
*	created_at	timestamp DEFAULT CURRENT_TIMESTAMP

Indexes

Type	Name	On
🔑	vote_webhook_pkey	ON id

Foreign Keys

Type	Name	On
	fk_vote_webhook_user_id	( user_id ) ref public.user (id)

Table public.welcome_settings

Idx	Name	Data Type
* 🔑 ⬈	guild_id	bigint
	channel_id	bigint
	message	text
	auto_role	bigint

Indexes

Type	Name	On
🔑	welcome_settings_pkey	ON guild_id

Foreign Keys

Type	Name	On
	fk_welcome_settings	( guild_id ) ref public.guild_settings (guild_id)