machoman
Tables (3)
comment (댓글)
- comment_id (인덱스) — PK AI — Primary key — NOT NULL
- user_id (유저 외래키) — FK — Foreign key → user.user_id — NOT NULL
- post_id (게시글 외래키) — FK — Foreign key → post.post_id — NOT NULL
- comment (댓글) — NotNull — NOT NULL
- created_at (생성일) — NotNull — NOT NULL
- updated_at (업데이트일) — NotNull — NOT NULL
post (게시글)
- post_id (인덱스) — PK AI — Primary key — NOT NULL
- user_id (유저 외래키) — FK — Foreign key → user.user_id — NOT NULL
- title (제목) — NotNull — NOT NULL
- content (내용) — NotNull — NOT NULL
- image (이미지) — NotNull — NOT NULL
- created_at (생성일) — NotNull — NOT NULL
- updated_at (업데이트일) — NotNull — NOT NULL
user (유저)
- user_id (인덱스) — PK AI — Primary key — NOT NULL
- email (이메일) — NotNull — NOT NULL
- password (비밀번호) — NotNull
- nickname (닉네임) — NotNull — NOT NULL
- created_at (생성일) — NotNull — NOT NULL
- updated_at (업데이트일) — NotNull — NOT NULL