# Slab schema ERD

Table and field reference for the Fivetran Slab connector.

## Table & Field Reference

### post

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| archived_at | Unknown |  |
| banner_original | Unknown |  |
| banner_preset | Unknown |  |
| banner_thumb | Unknown |  |
| banner_url | Unknown |  |
| content | Json |  |
| html | Json |  |
| inserted_at | Unknown |  |
| link_access | Unknown |  |
| markdown | Json |  |
| published_at | Unknown |  |
| published_version | Json |  |
| state | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| version | Unknown |  |

### topic_ancestor

| Column | Type | Keys |
| --- | --- | --- |
| ancestor_id | Unknown | PK, FK |
| topic_id | Unknown | PK, FK |

### topic_children

| Column | Type | Keys |
| --- | --- | --- |
| children_id | Unknown | PK, FK |
| topic_id | Unknown | PK, FK |

### topic_hierarchy

| Column | Type | Keys |
| --- | --- | --- |
| hierarchy | Unknown | PK |
| topic_id | Unknown | PK, FK |

### topic_owner

| Column | Type | Keys |
| --- | --- | --- |
| owner_id | Unknown | PK, FK |
| topic_id | Unknown | PK, FK |

### topic_member

| Column | Type | Keys |
| --- | --- | --- |
| member_id | Unknown | PK, FK |
| topic_id | Unknown | PK, FK |

### topic

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| parent_id | Unknown | FK |
| banner_original | Unknown |  |
| banner_thumb | Unknown |  |
| description | Unknown |  |
| inherit_parent | Unknown |  |
| inserted_at | Unknown |  |
| member_editable | Unknown |  |
| name | Unknown |  |
| privacy | Unknown |  |
| updated_at | Unknown |  |

### post_topic

| Column | Type | Keys |
| --- | --- | --- |
| post_id | Unknown | PK, FK |
| topic_id | Unknown | PK, FK |

### organization

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| host | Unknown |  |
| inserted_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| avatar_original | Unknown |  |
| avatar_thumb | Unknown |  |
| deactivated_at | Unknown |  |
| description | Unknown |  |
| email | Unknown |  |
| inserted_at | Unknown |  |
| name | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- post(owner_id) → users(id)
- topic_ancestor(ancestor_id) → topic(id)
- topic_ancestor(topic_id) → topic(id)
- topic_children(children_id) → topic(id)
- topic_children(topic_id) → topic(id)
- topic_hierarchy(topic_id) → topic(id)
- topic_owner(owner_id) → users(id)
- topic_owner(topic_id) → topic(id)
- topic_member(member_id) → users(id)
- topic_member(topic_id) → topic(id)
- topic(parent_id) → topic(id)
- topic(organization_id) → organization(id)
- post_topic(topic_id) → topic(id)
- post_topic(post_id) → post(id)
- users(organization_id) → organization(id)