homework2
Tables (4)
comment
- id — bigint — Primary key — NOT NULL
- post_id (password) — bigint — Foreign key → post.id — NOT NULL
- user_id (id2) — bigint — Foreign key → user.id — NOT NULL
- content — text
- createdAt — datetime — NOT NULL
- modifiedAt — datetime — NOT NULL
like
- post_id (password) — bigint — Foreign key → post.id — NOT NULL
- user_id (id) — bigint — Foreign key → user.id — NOT NULL
- createdAt — datetime — NOT NULL
post
- id (password) — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- title — varchar(25) — NOT NULL
- content — text
- image_url — varchar(255)
- view_count — bigint — NOT NULL
- templates — varchar(6)
- createdAt — datetime — NOT NULL
- modifiedAt — datetime — NOT NULL
user
- id — bigint — Primary key — NOT NULL
- name — varchar(10 ) — NOT NULL
- nickname — varchar(20) — NOT NULL
- email — varchar(50)
- password — varchar(255) — NOT NULL
- introduce — text
- profile_image_url — varchar(255)
- createdAt — datetime — NOT NULL
- modifiedAt — datetime