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