What data model would you create locally for the GET /tables/{id} method task? Name the tables and entities.

For the GET /tables/{id} method, the local data model may include the following entities and tables:

• Table — the main entity representing a table with a unique identifier id. Fields may include:

  • id (PK)
  • name (table name)
  • description
  • created_at, updated_at (timestamps)

• Column — description of table columns:

  • id (PK)
  • table_id (FK to Table)
  • name
  • data_type
  • is_nullable

• Row or Record — data of the table, if content needs to be stored:

  • id (PK)
  • table_id (FK)
  • data in JSON format or separate fields depending on the structure

If the task is just to get table metadata, only Table and Column are sufficient. To return content, the Row entity is added.

Example of a simplified schema:

Table(id PK, name, description, created_at, updated_at)
Column(id PK, table_id FK, name, data_type, is_nullable)
Row(id PK, table_id FK, data JSON)