EGIS_Post
Tables (3)
comments
- id — bigserial — Primary key — NOT NULL
- post_id — int8 — NOT NULL
- parent_id — int8
- depth — int4 — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted — bool — NOT NULL
files
- id — bigserial — Primary key — NOT NULL
- post_id — int8 — NOT NULL
- original_name — text — NOT NULL
- stored_name — text — NOT NULL
- content_type — text
- size — int8 — NOT NULL
- created_at — timestamp
- deleted — bool
posts
- id — bigserial — Primary key — NOT NULL
- root_id — int8
- parent_id — int8
- depth — int4 — NOT NULL
- title — varchar(200) — NOT NULL
- content — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- deleted — bool — NOT NULL