Knock

Tables (5)

AuthSession (users_auth_session)

  • id — uuid
  • email — CHARACTER(200) — NOT NULL
  • email_code — CHARACTER(12) — NOT NULL
  • attempt — INTEGER — NOT NULL
  • exp — CHARACTER(12) — NOT NULL
  • at — CHARACTER(12) — NOT NULL

Keyword (notes_keyword)

  • id — BIGSERIAL — Primary key — NOT NULL
  • note (note_id) — BIGSERIAL — Foreign key → Note.id — NOT NULL
  • parent (parent_id) — BIGSERIAL
  • pos_x — INTEGER — NOT NULL
  • pos_y — INTEGER — NOT NULL
  • text — CHARACTER(12)
  • status — INTEGER — NOT NULL
  • timestamp — INTEGER — NOT NULL

KeywordChildren (notes_keyword_children)

  • id — BIGSERIAL — Primary key — NOT NULL
  • keyword (keyword_id) — BIGSERIAL — Foreign key → Keyword.id — NOT NULL
  • child (child_id) — BIGSERIAL — Foreign key → Keyword.id — NOT NULL

Note (notes_note)

  • id — BIGSERIAL — Primary key — NOT NULL
  • author (user_id) — BIGSERIAL — Foreign key → User.id — NOT NULL
  • display_id — uuid — NOT NULL
  • name — CHARACTER(25) — NOT NULL
  • status — CHARACTER(12) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

User (users_user)

  • id — BIGSERIAL — Primary key — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • status — CHARACTER(12)
  • is_active — BOOLEAN — NOT NULL
  • email — CHARACTER(200)