Boolog_MyBatis
Tables (4)
Untitled (member)
- Key (id) — bigint — Primary key — NOT NULL
- Field (email) — varchar — NOT NULL
- Field (password) — varchar — NOT NULL
- Field (name) — varchar — NOT NULL
- Field (picture) — varchar
- Field (introduction) — varchar
- Field (provider) — varchar
- Field (provider_id) — varchar
- Field (role) — varchar — NOT NULL
- Field (reg_date) — datetime — NOT NULL
Untitled (post)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (thumbnail) — varchar
- Field (title) — varchar — NOT NULL
- Field (content) — text — NOT NULL
- Field (liked) — int — NOT NULL
- Field (tags) — varchar
- Field (created_date) — datetime — NOT NULL
- Field (modified_date) — datetime — NOT NULL
Untitled (liked_posts)
- Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (tag)
- Key (tag_name) — varchar — Primary key — NOT NULL
- Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL