dasdas
Tables (3)
boards
- id — BIGINT — Primary key — NOT NULL
- owner_id — BIGINT — Foreign key → users.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- is_public — BOOLEAN — NOT NULL
- post_count — BIGINT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
posts
- id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → boards.id — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- fullname — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- deleted_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL