tteodeulX2
Tables (3)
comments
- id — INT — Primary key — NOT NULL
- user_id — VACHAR(36) — Foreign key → users.id — NOT NULL
- post_id (poset_id) — INT — Foreign key → posts.id — NOT NULL
- created_at — DATE — NOT NULL
- updated_at — DATE
- content
posts
- id — INT — Primary key — NOT NULL
- user_id — VACHAR(36) — Foreign key → users.id — NOT NULL
- title — TEXT — NOT NULL
- image — TEXT — image의 path저장된다.
- content — TEXT — NOT NULL
- created_at — DATE — NOT NULL
- updated_at — DATE
- deadline — DATE — NOT NULL
- like_count — INT — NOT NULL
- dislike_count — INT — NOT NULL
users
- id — VACHAR(36) — Primary key — NOT NULL
- password — VARCHAR(30) — NOT NULL
- email — VARCHAR(30) — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- created_at — DATE — NOT NULL
- updated_at — DATE — NOT NULL
- last_login — DATE — NOT NULL
- Profile_image — TEXT — 유저프로필 이미지의 static경로