erd practice
Tables (3)
categories
- id — BIGSERIAL
- name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
posts
- id — BIGSERIAL
- users_id — BIGINT — Foreign key → users.id — NOT NULL
- categories_id — BIGINT — Foreign key → categories.id
- title — VARCHAR(200) — NOT NULL
- contents — TEXT — NOT NULL
- view — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGSERIAL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- age — SMALLINT
- password — TEXT — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL