pironeer_week4
Tables (4)
Comment (댓글)
- id (댓글 키) — NOT NULL — Primary key — NOT NULL
- user_id (유저 키) — NOT NULL — Foreign key → User.id — NOT NULL
- post_id (게시글 키) — NOT NULL — Foreign key → Post.id — NOT NULL
- content (내용) — NOT NULL
Like (좋아요)
- id (좋아요 키) — NOT NULL — Primary key — NOT NULL
- user_id (유저 키) — NOT NULL — Foreign key → User.id — NOT NULL
- post_id (게시글 키) — NOT NULL — Foreign key → Post.id — NOT NULL
Post (게시글)
- id (게시글 키) — NOT NULL — Primary key — NOT NULL
- user_id (유저 키) — NOT NULL — Foreign key → User.id — NOT NULL
- title (제목) — NOT NULL
- content (내용) — NOT NULL
- status (노출여부) — NOT NULL
- createdAt (생성시간) — NOT NULL
User (유저)
- id (유저 키) — NOT NULL — Primary key — NOT NULL
- name (이름) — NOT NULL