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