[clickhouse] Document Schema and Design Decisions #7492
Description
The design decisions and schema for ClickHouse are hidden in various threads. In this issue, we want to write an RFC to document all the design decisions that were made for ClickHouse.