everyDay
Tables (3)
post
- post_id — Primary key — NOT NULL
- id — varchar(50) — Foreign key → user.id — NOT NULL
- title — varchar(100)
- content — longtext
- author — varchar(20)
- vote_count — int(11)
- create_at — datetime
- update_at — datetime
- Field
post_coment
- coment_id — bigint(20) — Primary key — NOT NULL
- post_id — Foreign key → post.post_id — NOT NULL
- id — varchar(50) — Foreign key → post.id — NOT NULL
- content — longtext
- Field
- parent_comment_id
user
- id — varchar(50) — Primary key — NOT NULL
- password — varchar(255)
- username — varchar(15)
- create_at — datetime
- update_at — datetime