study

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