I’m study how discourse was implemented, and I hope to understand each fields in schemas of discourse database, so that I can quickly know the meaning of things done by ruby codes.Is there a suite document for me?

The best source of schema information is probably the annotations at the bottom of fiiles in the app/models directory. For example, the posts table columns are app/models/post.rb e7bad9f05 # == Schema Information # # Table name: posts # # id :integer not null, primary key # user_id :integer # topic_id :integer not null # post_number :integer not null # raw :text not null # cooked :text not null # created_at :datetime not null # updated_at :datetime not null # reply_to_post_number :integer # reply_count :integer default(0), not null # quote_count :integer default(0), not null # deleted_at :datetime # off_topic_count :integer default(0), not null # like_count :integer default(0), not null # incoming_link_count :integer default(0), not null # bookmark_count :integer default(0), not null This file has been truncated. show original

The Discourse Data Explorer might be worth a look too. It has the tables and columns listed out.

Been a while here, but if you have the Data Explorer Plugin, you can also use the api to fetch everything: /admin/plugins/explorer/schema.json.

هل يوجد مستند يقدم تصميم مخطط قاعدة البيانات؟

مطور

TallTrees 30 نوفمبر 2020، 2:29م 3

قد يستحق Discourse Data Explorer نظرة أيضًا. فهو يحتوي على جداول وأعمدة مُدرجة.

الموضوع		الردود	مرات العرض
Database's Data Model? Product Support	7	4267	6 أغسطس 2020
Is there a data map for Discourse data? Data & reporting	2	559	19 سبتمبر 2023
Where can we get discourse database schema design diagram? Development	3	2039	17 يوليو 2022
Documentation of the entire database Data & reporting	5	1067	24 يوليو 2023
A data model to make perusing the database easier Feature data-explorer	25	2996	25 يونيو 2025

هل يوجد مستند يقدم تصميم مخطط قاعدة البيانات؟

الموضوعات ذات الصلة