matters_stage Database

Table	Constraint Name	Constraint
transaction_obsolete	transaction_purpose_check	((purpose = ANY (ARRAY['appreciate'::text, 'appreciate-comment'::text, 'appreciate-subsidy'::text, 'invitation-accepted'::text, 'join-by-invitation'::text, 'join-by-task'::text, 'first-post'::text, 'system-subsidy'::text])))
transaction_obsolete	transaction_type_check	((type = ANY (ARRAY['LIKE'::text, 'MAT'::text])))
appreciation	appreciation_purpose_check	((purpose = ANY (ARRAY['appreciate'::text, 'appreciate-comment'::text, 'appreciate-subsidy'::text, 'invitation-accepted'::text, 'join-by-invitation'::text, 'join-by-task'::text, 'first-post'::text, 'system-subsidy'::text])))
appreciation	appreciation_type_check	((type = ANY (ARRAY['LIKE'::text, 'MAT'::text])))
user_oauth	user_oauth_provider_check	((provider = ANY (ARRAY['facebook'::text, 'google'::text, 'medium'::text])))
action_comment	action_comment_action_check	((action = ANY (ARRAY['up_vote'::text, 'down_vote'::text])))
customer	customer_provider_check	((provider = 'stripe'::text))
user_oauth_likecoin	user_oauth_likecoin_account_type_check	((account_type = ANY (ARRAY['temporal'::text, 'general'::text])))
payout_account	payout_account_provider_check	((provider = 'stripe'::text))
payout_account	payout_account_type_check	((type = ANY (ARRAY['express'::text, 'standard'::text])))
action_article	action_article_action_check	((action = 'subscribe'::text))
verification_code	verification_code_status_check	((status = ANY (ARRAY['active'::text, 'inactive'::text, 'verified'::text, 'expired'::text, 'used'::text])))
verification_code	verification_code_type_check	((type = ANY (ARRAY['register'::text, 'email_reset'::text, 'email_reset_confirm'::text, 'password_reset'::text, 'payment_password_reset'::text, 'email_verify'::text])))
punish_record	punish_record_state_check	((state = 'banned'::text))
blocklist	blocklist_type_check	((type = ANY (ARRAY['agent_hash'::text, 'email'::text, 'domain'::text])))
release	release_channel_check	((channel = ANY (ARRAY['appStore'::text, 'googlePlay'::text])))
release	release_platform_check	((platform = ANY (ARRAY['ios'::text, 'android'::text])))
action_tag	action_tag_action_check	((action = 'follow'::text))
invitation	invitation_status_check	((status = ANY (ARRAY['pending'::text, 'activated'::text])))
action_user	action_user_action_check	((action = ANY (ARRAY['follow'::text, 'rate'::text, 'block'::text])))
transaction	transaction_currency_check	((currency = ANY (ARRAY['HKD'::text, 'LIKE'::text])))
transaction	transaction_provider_check	((provider = ANY (ARRAY['stripe'::text, 'likecoin'::text, 'matters'::text])))
transaction	transaction_purpose_check	((purpose = ANY (ARRAY['appreciate'::text, 'appreciate-comment'::text, 'appreciate-subsidy'::text, 'invitation-accepted'::text, 'join-by-invitation'::text, 'join-by-task'::text, 'first-post'::text, 'system-subsidy'::text])))
transaction	transaction_state_check	((state = ANY (ARRAY['pending'::text, 'succeeded'::text, 'failed'::text, 'canceled'::text])))
comment	comment_state_check	((state = ANY (ARRAY['active'::text, 'archived'::text, 'banned'::text, 'collapsed'::text])))
user_badge	user_badge_type_check	((type = 'seed'::text))
push_device	push_device_platform_check	((platform = ANY (ARRAY['ios'::text, 'android'::text, 'web'::text])))
push_device	push_device_provider_check	((provider = ANY (ARRAY['jpush'::text, 'fcm'::text])))
feature_flag	feature_flag_flag_check	((flag = ANY (ARRAY['on'::text, 'off'::text, 'admin'::text])))
draft	draft_publish_state_check	((publish_state = ANY (ARRAY['unpublished'::text, 'pending'::text, 'published'::text, 'error'::text])))
user	user_language_check	((language = ANY (ARRAY['zh_hant'::text, 'zh_hans'::text, 'en'::text])))
user	user_role_check	((role = ANY (ARRAY['user'::text, 'admin'::text])))
user	user_state_check	((state = ANY (ARRAY['onboarding'::text, 'active'::text, 'banned'::text, 'frozen'::text, 'archived'::text])))
article	article_state_check	((state = ANY (ARRAY['active'::text, 'banned'::text, 'archived'::text])))