0725

Tables (4)

Post (posts)

  • (id) — int — Primary key — NOT NULL
  • (title) — varchar(255) — NOT NULL
  • (content) — text — NOT NULL
  • Field (createdAt) — timestamptz — NOT NULL
  • Field2 (topicLocalId) — int — NOT NULL
  • Field (viewCount) — int — NOT NULL
  • Field (ip) — varchar(15) — Exclude Response
  • Key (authorId) — int — Foreign key → Untitled.Key
  • Key (topicId) — int — Foreign key → Untitled.Key

Untitled (topics)

  • Key (id) — int — Primary key — NOT NULL
  • Field (name) — varchar(32) — NOT NULL
  • Field (description) — varchar(255) — NOT NULL
  • Field (createdAt) — timestamptz — NOT NULL
  • Key (creatorId) — int — Foreign key → Untitled.Key

Untitled (users)

  • Key (id) — int — Primary key — NOT NULL
  • Field (username) — varchar(32) — NOT NULL
  • Field (password) — varchar(255) — NOT NULL — Exclude Response
  • Field (email) — varchar(320) — NOT NULL
  • Field (createdAt) — timestamptz — NOT NULL

Untitled (comments)

  • Key (id) — int — Primary key — NOT NULL
  • Field (content) — text — NOT NULL
  • Field2 (createdAt) — timestamptz — NOT NULL
  • Key (userId) — int — Foreign key → Untitled.Key
  • (postId) — int — Foreign key → Post.id