secretio.public

Table	Constraint Name	Constraint
email_verification_codes	chk_verification_codes_expires	(expires_at > created_at)
email_verification_codes	chk_verification_codes_format	((code)::text ~ '^[0-9]{6}$'::text)
draw_results	chk_draw_results_date	(draw_date <= now())
draw_pairs	chk_draw_pairs_different_participants	(giver_participant_id <> receiver_participant_id)
team_members	chk_team_members_different	(team_id <> user_id)
chat_rooms	chk_chat_participants_different	(participant1_id <> participant2_id)
chat_rooms	chk_chat_participants_order	(participant1_id < participant2_id)
participant_exclusions	chk_exclusions_different_participants	(from_participant_id <> to_participant_id)
ownership_transfer_requests	chk_ownership_transfer_expires	(expires_at > created_at)
ownership_transfer_requests	chk_ownership_transfer_status	((status)::text = ANY ((ARRAY['pending'::character varying, 'accepted'::character varying, 'declined'::character varying, 'expired'::character varying, 'cancelled'::character varying])::text[]))
votes	chk_votes_type	(vote_type = ANY (ARRAY['like'::text, 'super'::text, 'favorite'::text]))
team_invites	chk_team_invites_expires	(expires_at > created_at)
team_invites	chk_team_invites_status	((status)::text = ANY ((ARRAY['pending'::character varying, 'accepted'::character varying, 'expired'::character varying, 'revoked'::character varying])::text[]))
teams	chk_teams_invite_code_length	(char_length(invite_code) >= 32)
teams	chk_teams_name_length	((char_length(name) >= 2) AND (char_length(name) <= 200))
dictionary	chk_dictionary_code_format	(code ~ '^[a-z][a-z0-9_]*$'::text)
notifications	chk_notifications_type	((type)::text = ANY ((ARRAY['email'::character varying, 'draw_result'::character varying, 'invite'::character varying, 'message'::character varying, 'gift_sent'::character varying, 'gift_received'::character varying, 'vote'::character varying])::text[]))
refresh_tokens	chk_refresh_tokens_expires	(expires_at > now())
boxes	chk_boxes_budget	((budget_min IS NULL) OR (budget_max IS NULL) OR (budget_min <= budget_max))
boxes	chk_boxes_budget_positive	((budget_min IS NULL) OR (budget_min >= (0)::numeric))
boxes	chk_boxes_dates	((draw_date IS NULL) OR (start_date IS NULL) OR (draw_date >= start_date))
boxes	chk_boxes_delivery_deadline	((delivery_deadline IS NULL) OR (draw_date IS NULL) OR (delivery_deadline >= draw_date))
boxes	chk_boxes_max_items	((max_wishlist_items > 0) AND (max_wishlist_items <= 100))
boxes	chk_boxes_name_length	((char_length(name) >= 2) AND (char_length(name) <= 200))
dictionary_item	chk_dictionary_item_code_format	(code ~ '^[a-z][a-z0-9_]*$'::text)
wishlist_items	chk_wishlist_items_name_length	((char_length(name) >= 1) AND (char_length(name) <= 500))
wishlist_items	chk_wishlist_items_price	((price IS NULL) OR (price >= (0)::numeric))
wishlist_items	chk_wishlist_items_priority	((priority >= '-100'::integer) AND (priority <= 100))
email_2fa_codes	chk_email_2fa_codes_expires	(expires_at > created_at)
email_2fa_codes	chk_email_2fa_codes_format	((code)::text ~ '^[0-9a-f]{6}$'::text)
deliveries	chk_deliveries_dates	((shipped_at IS NULL) OR (delivered_at IS NULL) OR (delivered_at >= shipped_at))
deliveries	chk_deliveries_different_participants	(giver_participant_id <> receiver_participant_id)
deliveries	chk_deliveries_tracking_format	((tracking_number IS NULL) OR ((char_length(tracking_number) >= 5) AND (char_length(tracking_number) <= 100)))
users	chk_users_email_format	(email ~* '^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,}$'::text)
users	chk_users_phone_format	((phone IS NULL) OR (phone ~ '^\+?[0-9\s\-]+$'::text))
password_reset_codes	chk_password_reset_codes_expires	(expires_at > created_at)
password_reset_codes	chk_password_reset_codes_format	((code)::text ~ '^[0-9a-f]{6}$'::text)