community
Tables (3)
Untitled (Post)
- id — BIGINT — Primary key — NOT NULL
- title — varchar
- content — varchar
- comment_count — BIGINT
- created_date — DATETIME
- modified_date — DATETIME
- removed_date — DATETIME
- user_id — BIGINT — Foreign key → User.id — NOT NULL
Untitled (Comment)
- id — BIGINT — Primary key — NOT NULL
- content — varchar
- created_date — DATETIME
- modified_date — DATETIME
- removed_date — DATETIME
- post_id — BIGINT — Foreign key → Untitled.id — NOT NULL
- user_id — BIGINT — Foreign key → User.id — NOT NULL
User
- id — BIGINT — Primary key — NOT NULL
- user_table_id — varchar
- password — varchar
- created_date — DATETIME
- role — varchar