Tables


SchemaSpy Analysis of matters_stage

Generated on Sat Jul 25 15:16 PDT 2020

XML Representation
Insertion Order Deletion Order
TABLES 56
VIEWS 14
COLUMNS 581
Constraints 85
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 10.6

Tables

Table / View Children Parents Columns Type Comments
collection 0 2 6 Table
article_boost 0 1 5 Table
transaction_obsolete 0 2 9 Table
feedback_asset 0 2 3 Table
appreciation 0 2 9 Table
matters_today 0 1 7 Table
user_oauth 0 1 9 Table
action_comment 0 2 6 Table
customer 0 1 5 Table
report_asset 0 2 3 Table
user_oauth_likecoin 0 1 10 Table
payout_account 0 1 7 Table
action_article 0 2 6 Table
verification_code 0 1 12 Table
tag_boost 0 1 5 Table
punish_record 0 1 7 Table
matters_choice 0 1 4 Table
blocklist 0 0 8 Table
release 0 1 11 Table
action_tag 0 2 6 Table
invitation 0 2 6 Table
notice_actor 0 2 4 Table
username_edit_history 0 1 4 Table
comment_mentioned_user 0 2 4 Table
oauth_client 3 2 13 Table
oauth_access_token 0 2 8 Table
article_tag 0 2 7 Table
feedback 1 1 7 Table
article_read 0 2 7 Table
notice 2 2 8 Table
user_notify_setting 0 1 19 Table
action_user 0 2 6 Table
transaction 0 3 15 Table
article_recommend_setting 0 1 4 Table
comment 5 4 15 Table
user_badge 0 1 4 Table
push_device 0 1 9 Table
notice_detail 1 0 5 Table
feature_flag 0 0 5 Table
audio_draft 0 2 8 Table
asset_map 0 2 4 Table
article_read_count 0 2 11 Table
notice_entity 0 2 5 Table
log_record 0 1 4 Table
draft 1 3 15 Table
user_boost 0 1 5 Table
asset 9 1 7 Table
report 1 3 9 Table
user 42 1 23 Table
entity_type 3 0 2 Table
oauth_refresh_token 0 2 8 Table
oauth_authorization_code 0 2 9 Table
article 14 4 21 Table
search_history 0 1 5 Table
knex_migrations 0 0 4 Table
tag 3 0 10 Table
transaction_delta_view 0 0 15 View
article_interest_materialized 0 0 3 View
article_interest_view 0 0 3 View
featured_comment_materialized 0 0 20 View
tag_count_materialized 0 0 8 View
user_reader_materialized 0 0 21 View
article_activity_view 0 0 7 View
article_count_view 0 0 7 View
article_activity_materialized 0 0 7 View
tag_count_view 0 0 8 View
user_reader_view 0 0 21 View
article_count_materialized 0 0 7 View
article_value_view 0 0 8 View
article_value_materialized 0 0 8 View