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)